APPS.AHL_COMPLETIONS_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 179: FROM fnd_lookup_values_vl

175: IS
176: CURSOR get_status_csr(c_status_code IN VARCHAR2,
177: c_lookup_type IN VARCHAR2) IS
178: SELECT meaning
179: FROM fnd_lookup_values_vl
180: WHERE lookup_type = c_lookup_type
181: AND LOOKUP_CODE = c_status_code;
182:
183:

Line 234: FROM AHL_WORKORDERS WO, FND_LOOKUP_VALUES_VL MLU,WIP_DISCRETE_JOBS WDJ,

230: WDJ.COMPLETION_SUBINVENTORY,
231: WDJ.COMPLETION_LOCATOR_ID,
232: WO.visit_id,
233: WO.visit_task_id
234: FROM AHL_WORKORDERS WO, FND_LOOKUP_VALUES_VL MLU,WIP_DISCRETE_JOBS WDJ,
235: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V WHERE
236: NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
237: WHERE WDJ.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
238: AND MLU.LOOKUP_TYPE(+)='AHL_JOB_STATUS' AND WO.STATUS_CODE=MLU.LOOKUP_CODE(+)

Line 1144: FROM fnd_lookup_values_vl

1140: 'AHL_OPERATION_STATUS');
1141:
1142:
1143: /*SELECT MEANING INTO l_op_status_meaning
1144: FROM fnd_lookup_values_vl
1145: WHERE lookup_type = 'AHL_OPERATION_STATUS'
1146: AND lookup_code = p_operation_rec.status_code;
1147: */
1148: --

Line 1182: FROM fnd_lookup_values_vl

1178: l_job_status_meaning := get_status(p_workorder_rec.status_code,
1179: 'AHL_JOB_STATUS');
1180:
1181: /*SELECT MEANING INTO l_job_status_meaning
1182: FROM fnd_lookup_values_vl
1183: WHERE lookup_type = 'AHL_JOB_STATUS'
1184: AND lookup_code = p_workorder_rec.status_code;
1185: */
1186:

Line 1566: FROM fnd_lookup_values_vl

1562: l_job_status_meaning := get_status(p_workorder_rec.status_code,
1563: 'AHL_JOB_STATUS');
1564:
1565: /*SELECT MEANING INTO l_job_status_meaning
1566: FROM fnd_lookup_values_vl
1567: WHERE lookup_type = 'AHL_JOB_STATUS'
1568: AND lookup_code = p_workorder_rec.status_code;
1569: */
1570: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_WO_STATUS' );

Line 1668: FROM fnd_lookup_values_vl

1664: l_job_status_meaning := get_status(p_workorder_rec.status_code,
1665: 'AHL_JOB_STATUS');
1666:
1667: /*SELECT MEANING INTO l_job_status_meaning
1668: FROM fnd_lookup_values_vl
1669: WHERE lookup_type = 'AHL_JOB_STATUS'
1670: AND lookup_code = p_workorder_rec.status_code;
1671: */
1672: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_WO_STATUS' );

Line 6064: FROM fnd_lookup_values_vl

6060: l_status_meaning := get_status(l_mr_rec.ue_status_code,
6061: 'AHL_PRD_MR_STATUS');
6062:
6063: /*SELECT meaning INTO l_status_meaning
6064: FROM fnd_lookup_values_vl
6065: WHERE lookup_type = 'AHL_PRD_MR_STATUS'
6066: AND LOOKUP_CODE = l_mr_rec.ue_status_code;
6067: */
6068:

Line 6296: FROM fnd_lookup_values_vl

6292: l_job_status_meaning := get_status(wo_csr.status_code,
6293: 'AHL_JOB_STATUS');
6294:
6295: /*SELECT MEANING INTO l_job_status_meaning
6296: FROM fnd_lookup_values_vl
6297: WHERE lookup_type = 'AHL_JOB_STATUS'
6298: AND lookup_code = wo_csr.status_code;
6299: */
6300: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_NOT_ALL_WOS_OPEN' );

Line 7445: FROM fnd_lookup_values_vl

7441: 'AHL_PRD_MR_STATUS');
7442:
7443:
7444: /*SELECT meaning INTO l_status_meaning
7445: FROM fnd_lookup_values_vl
7446: WHERE lookup_type = 'AHL_PRD_MR_STATUS'
7447: AND LOOKUP_CODE = l_ue_status_code;
7448: */
7449: FND_MESSAGE.set_token( 'STATUS', l_status_meaning );

Line 8393: FROM fnd_lookup_values_vl

8389: l_status_meaning := get_status(wo_csr.status_code,
8390: 'AHL_JOB_STATUS');
8391:
8392: /*SELECT meaning INTO l_status_meaning
8393: FROM fnd_lookup_values_vl
8394: WHERE lookup_type = 'AHL_JOB_STATUS'
8395: AND lookup_code = wo_csr.status_code;
8396: */
8397: --

Line 9260: FROM fnd_lookup_values_vl

9256: l_status_meaning := get_status(l_ue_status_code,
9257: 'AHL_PRD_MR_STATUS');
9258:
9259: /*SELECT meaning INTO l_status_meaning
9260: FROM fnd_lookup_values_vl
9261: WHERE lookup_type = 'AHL_PRD_MR_STATUS'
9262: AND LOOKUP_CODE = l_ue_status_code;
9263: */
9264: FND_MESSAGE.set_token( 'STATUS', l_status_meaning );

Line 10898: from ahl_unit_effectivities_b UE--, FND_LOOKUP_VALUES_VL FL

10894: UE.cs_incident_id,
10895: --FL.Lookup_code,
10896: --FL.Meaning,
10897: UE.qa_collection_id
10898: from ahl_unit_effectivities_b UE--, FND_LOOKUP_VALUES_VL FL
10899: where --FL.Lookup_type = 'AHL_PRD_MR_STATUS'
10900: --AND FL.Lookup_code = AHL_COMPLETIONS_PVT.get_mr_status( p_unit_effectivity_id ) AND
10901: UE.unit_effectivity_id = p_unit_effectivity_id
10902: AND UE.object_version_number = p_ue_object_version_no;

Line 10905: Select FL.Meaning FROM FND_LOOKUP_VALUES_VL FL

10901: UE.unit_effectivity_id = p_unit_effectivity_id
10902: AND UE.object_version_number = p_ue_object_version_no;
10903:
10904: CURSOR get_mr_status_csr(p_status_code VARCHAR2) IS
10905: Select FL.Meaning FROM FND_LOOKUP_VALUES_VL FL
10906: Where FL.Lookup_type = 'AHL_PRD_MR_STATUS'
10907: AND FL.Lookup_code = p_status_code;
10908:
10909: CURSOR fmp_mr_csr (p_mr_header_id IN NUMBER )