Oracle EBS: 工單狀況與lookup_code對應

 工單狀況與lookup_code對應

SELECT flv.language,

       flv.lookup_code,

       flv.meaning,

       flv.description,

       flv.source_lang,

       flv.security_group_id,

       flv.tag,

       flttl.lookup_type,

       flttl.view_application_id,

       flttl.language,

       flttl.meaning,

       flttl.description

  FROM applsys.fnd_lookup_values flv, applsys.fnd_lookup_types_tl flttl

 WHERE (flttl.lookup_type = flv.lookup_type

        AND flv.lookup_type LIKE 'WIP_JOB_STATUS');