DBA Data[Home] [Help]

APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on MFG_LOOKUPS

Line 628: FROM AHL_OPERATION_RESOURCES AOR, AHL_WORKORDER_OPERATIONS AWO , BOM_RESOURCES BOM, MFG_LOOKUPS MFG

624: /*
625: Cursor Curres(WORK_ID NUMBER,C_RES_SEQ NUMBER)
626: Is
627: Select AOR.RESOURCE_ID, BOM.UNIT_OF_MEASURE UOM_CODE
628: FROM AHL_OPERATION_RESOURCES AOR, AHL_WORKORDER_OPERATIONS AWO , BOM_RESOURCES BOM, MFG_LOOKUPS MFG
629: WHERE AOR.RESOURCE_SEQUENCE_NUM = C_RES_SEQ
630: AND AOR.WORKORDER_OPERATION_ID = AWO.WORKORDER_OPERATION_ID
631: AND AWO.WORKORDER_ID = WORK_ID
632: AND AOR.RESOURCE_ID = BOM.RESOURCE_ID

Line 1567: AHL_OPERATION_RESOURCES AOPR,AHL_DEPARTMENT_SHIFTS ADS, mtl_employees_current_view PEPF, BOM_RESOURCES BOMR, MFG_LOOKUPS MFGL

1563: AWOS.DEPARTMENT_NAME,
1564: AWOS.DEPARTMENT_ID,
1565: AWOS.ITEM_INSTANCE_ID
1566: FROM AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDER_TASKS_V AWOS, AHL_WORKORDER_OPERATIONS AWOP,
1567: AHL_OPERATION_RESOURCES AOPR,AHL_DEPARTMENT_SHIFTS ADS, mtl_employees_current_view PEPF, BOM_RESOURCES BOMR, MFG_LOOKUPS MFGL
1568: WHERE AWAS.OPERATION_RESOURCE_ID = AOPR.OPERATION_RESOURCE_ID
1569: AND AWOP.WORKORDER_OPERATION_ID = AOPR.WORKORDER_OPERATION_ID
1570: AND AWOP.WORKORDER_ID = AWOS.WORKORDER_ID
1571: AND AWOS.DEPARTMENT_ID = ADS.DEPARTMENT_ID (+)