DBA Data[Home] [Help]

APPS.AHL_PRD_MRSHL_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 123: (SELECT MLU.meaning from fnd_lookup_values_vl MLU where MLU.LOOKUP_TYPE ='AHL_JOB_STATUS' AND MLU.LOOKUP_CODE = AWOS.status_code) job_status_meaning,

119: AWOS.workorder_name job_number,
120: --AWOS.job_status_code,
121: AWOS.status_code job_status_code,
122: --AWOS.job_status_meaning,
123: (SELECT MLU.meaning from fnd_lookup_values_vl MLU where MLU.LOOKUP_TYPE ='AHL_JOB_STATUS' AND MLU.LOOKUP_CODE = AWOS.status_code) job_status_meaning,
124: ASML.operation_sequence, MSIK.concatenated_segments ,
125: MSIK.description, MSIK.primary_uom_code,MSIK.primary_unit_of_measure,
126: WIRO.REQUIRED_QUANTITY , WIRO.DATE_REQUIRED,
127: asml.scheduled_quantity ,asml.scheduled_date ,

Line 203: (SELECT MLU.meaning from fnd_lookup_values_vl MLU where MLU.LOOKUP_TYPE ='AHL_JOB_STATUS' AND MLU.LOOKUP_CODE = AWOS.status_code) job_status_meaning,

199: AWOS.workorder_name job_number,
200: --AWOS.job_status_code,
201: AWOS.status_code job_status_code,
202: --AWOS.job_status_meaning,
203: (SELECT MLU.meaning from fnd_lookup_values_vl MLU where MLU.LOOKUP_TYPE ='AHL_JOB_STATUS' AND MLU.LOOKUP_CODE = AWOS.status_code) job_status_meaning,
204: ASML.operation_sequence, MSIK.concatenated_segments ,
205: MSIK.description, MSIK.primary_uom_code,MSIK.primary_unit_of_measure,
206: WIRO.REQUIRED_QUANTITY , WIRO.DATE_REQUIRED,
207: asml.scheduled_quantity ,asml.scheduled_date ,

Line 551: (SELECT MLU.meaning from fnd_lookup_values_vl MLU where MLU.LOOKUP_TYPE ='AHL_JOB_STATUS' AND MLU.LOOKUP_CODE = AWOS.status_code) job_status_meaning,

547: AWOS.workorder_name job_number,
548: --AWOS.job_status_code,
549: AWOS.status_code job_status_code,
550: --AWOS.job_status_meaning,
551: (SELECT MLU.meaning from fnd_lookup_values_vl MLU where MLU.LOOKUP_TYPE ='AHL_JOB_STATUS' AND MLU.LOOKUP_CODE = AWOS.status_code) job_status_meaning,
552: ASML.operation_sequence, MSIK.concatenated_segments ,
553: MSIK.description, MSIK.primary_uom_code,MSIK.primary_unit_of_measure,
554: WIRO.REQUIRED_QUANTITY , WIRO.DATE_REQUIRED,
555: asml.scheduled_quantity ,asml.scheduled_date ,

Line 628: (SELECT MLU.meaning from fnd_lookup_values_vl MLU where MLU.LOOKUP_TYPE ='AHL_JOB_STATUS' AND MLU.LOOKUP_CODE = AWOS.status_code) job_status_meaning,

624: AWOS.workorder_name job_number,
625: --AWOS.job_status_code,
626: AWOS.status_code job_status_code,
627: --AWOS.job_status_meaning,
628: (SELECT MLU.meaning from fnd_lookup_values_vl MLU where MLU.LOOKUP_TYPE ='AHL_JOB_STATUS' AND MLU.LOOKUP_CODE = AWOS.status_code) job_status_meaning,
629: ASML.operation_sequence, MSIK.concatenated_segments ,
630: MSIK.description, MSIK.primary_uom_code,MSIK.primary_unit_of_measure,
631: WIRO.REQUIRED_QUANTITY , WIRO.DATE_REQUIRED,
632: asml.scheduled_quantity ,asml.scheduled_date ,