eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_COMPLETIONS_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 205: FROM fnd_lookup_values_vl

201: IS
202: CURSOR get_status_csr(c_status_code IN VARCHAR2,
203: c_lookup_type IN VARCHAR2) IS
204: SELECT meaning
205: FROM fnd_lookup_values_vl
206: WHERE lookup_type = c_lookup_type
207: AND LOOKUP_CODE = c_status_code;
208:
209:

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

256: WDJ.COMPLETION_SUBINVENTORY,
257: WDJ.COMPLETION_LOCATOR_ID,
258: WO.visit_id,
259: WO.visit_task_id
260: FROM AHL_WORKORDERS WO, FND_LOOKUP_VALUES_VL MLU,WIP_DISCRETE_JOBS WDJ,
261: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V WHERE
262: NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
263: WHERE WDJ.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
264: AND MLU.LOOKUP_TYPE(+)='AHL_JOB_STATUS' AND WO.STATUS_CODE=MLU.LOOKUP_CODE(+)

Line 1185: FROM fnd_lookup_values_vl

1181: 'AHL_OPERATION_STATUS');
1182:
1183:
1184: /*SELECT MEANING INTO l_op_status_meaning
1185: FROM fnd_lookup_values_vl
1186: WHERE lookup_type = 'AHL_OPERATION_STATUS'
1187: AND lookup_code = p_operation_rec.status_code;
1188: */
1189: --

Line 1223: FROM fnd_lookup_values_vl

1219: l_job_status_meaning := get_status(p_workorder_rec.status_code,
1220: 'AHL_JOB_STATUS');
1221:
1222: /*SELECT MEANING INTO l_job_status_meaning
1223: FROM fnd_lookup_values_vl
1224: WHERE lookup_type = 'AHL_JOB_STATUS'
1225: AND lookup_code = p_workorder_rec.status_code;
1226: */
1227:

Line 1634: FROM fnd_lookup_values_vl

1630: l_job_status_meaning := get_status(p_workorder_rec.status_code,
1631: 'AHL_JOB_STATUS');
1632:
1633: /*SELECT MEANING INTO l_job_status_meaning
1634: FROM fnd_lookup_values_vl
1635: WHERE lookup_type = 'AHL_JOB_STATUS'
1636: AND lookup_code = p_workorder_rec.status_code;
1637: */
1638: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_WO_STATUS' );

Line 1736: FROM fnd_lookup_values_vl

1732: l_job_status_meaning := get_status(p_workorder_rec.status_code,
1733: 'AHL_JOB_STATUS');
1734:
1735: /*SELECT MEANING INTO l_job_status_meaning
1736: FROM fnd_lookup_values_vl
1737: WHERE lookup_type = 'AHL_JOB_STATUS'
1738: AND lookup_code = p_workorder_rec.status_code;
1739: */
1740: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_WO_STATUS' );

Line 6422: FROM fnd_lookup_values_vl

6418: l_status_meaning := get_status(l_mr_rec.ue_status_code,
6419: 'AHL_PRD_MR_STATUS');
6420:
6421: /*SELECT meaning INTO l_status_meaning
6422: FROM fnd_lookup_values_vl
6423: WHERE lookup_type = 'AHL_PRD_MR_STATUS'
6424: AND LOOKUP_CODE = l_mr_rec.ue_status_code;
6425: */
6426:

Line 6656: FROM fnd_lookup_values_vl

6652: l_job_status_meaning := get_status(wo_csr.status_code,
6653: 'AHL_JOB_STATUS');
6654:
6655: /*SELECT MEANING INTO l_job_status_meaning
6656: FROM fnd_lookup_values_vl
6657: WHERE lookup_type = 'AHL_JOB_STATUS'
6658: AND lookup_code = wo_csr.status_code;
6659: */
6660: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_NOT_ALL_WOS_OPEN' );

Line 7839: FROM fnd_lookup_values_vl

7835: 'AHL_PRD_MR_STATUS');
7836:
7837:
7838: /*SELECT meaning INTO l_status_meaning
7839: FROM fnd_lookup_values_vl
7840: WHERE lookup_type = 'AHL_PRD_MR_STATUS'
7841: AND LOOKUP_CODE = l_ue_status_code;
7842: */
7843: FND_MESSAGE.set_token( 'STATUS', l_status_meaning );

Line 9030: FROM fnd_lookup_values_vl

9026: -- lookup does not exist
9027: l_status_meaning := get_status(wo_csr.status_code,'AHL_JOB_STATUS');
9028:
9029: /*SELECT meaning INTO l_status_meaning
9030: FROM fnd_lookup_values_vl
9031: WHERE lookup_type = 'AHL_JOB_STATUS'
9032: AND lookup_code = wo_csr.status_code;
9033: */
9034: --

Line 9971: FROM fnd_lookup_values_vl

9967: -- so no exceptions are thrown if the
9968: -- lookup does not exist
9969: l_status_meaning := get_status(l_ue_status_code, 'AHL_PRD_MR_STATUS');
9970: /*SELECT meaning INTO l_status_meaning
9971: FROM fnd_lookup_values_vl
9972: WHERE lookup_type = 'AHL_PRD_MR_STATUS'
9973: AND LOOKUP_CODE = l_ue_status_code;
9974: */
9975: FND_MESSAGE.set_token( 'STATUS', l_status_meaning );

Line 11753: from ahl_unit_effectivities_b UE--, FND_LOOKUP_VALUES_VL FL

11749: UE.cs_incident_id,
11750: --FL.Lookup_code,
11751: --FL.Meaning,
11752: UE.qa_collection_id
11753: from ahl_unit_effectivities_b UE--, FND_LOOKUP_VALUES_VL FL
11754: where --FL.Lookup_type = 'AHL_PRD_MR_STATUS'
11755: --AND FL.Lookup_code = AHL_COMPLETIONS_PVT.get_mr_status( p_unit_effectivity_id ) AND
11756: UE.unit_effectivity_id = p_unit_effectivity_id
11757: AND UE.object_version_number = p_ue_object_version_no;

Line 11760: Select FL.Meaning FROM FND_LOOKUP_VALUES_VL FL

11756: UE.unit_effectivity_id = p_unit_effectivity_id
11757: AND UE.object_version_number = p_ue_object_version_no;
11758:
11759: CURSOR get_mr_status_csr(p_status_code VARCHAR2) IS
11760: Select FL.Meaning FROM FND_LOOKUP_VALUES_VL FL
11761: Where FL.Lookup_type = 'AHL_PRD_MR_STATUS'
11762: AND FL.Lookup_code = p_status_code;
11763:
11764: CURSOR fmp_mr_csr (p_mr_header_id IN NUMBER )