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.

[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 1609: AHL_OPERATION_RESOURCES AOPR,AHL_DEPARTMENT_SHIFTS ADS, mtl_employees_current_view PEPF, BOM_RESOURCES BOMR, MFG_LOOKUPS MFGL

1605: AWOS.DEPARTMENT_NAME,
1606: AWOS.DEPARTMENT_ID,
1607: AWOS.ITEM_INSTANCE_ID
1608: FROM AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDER_TASKS_V AWOS, AHL_WORKORDER_OPERATIONS AWOP,
1609: AHL_OPERATION_RESOURCES AOPR,AHL_DEPARTMENT_SHIFTS ADS, mtl_employees_current_view PEPF, BOM_RESOURCES BOMR, MFG_LOOKUPS MFGL
1610: WHERE AWAS.OPERATION_RESOURCE_ID = AOPR.OPERATION_RESOURCE_ID
1611: AND AWOP.WORKORDER_OPERATION_ID = AOPR.WORKORDER_OPERATION_ID
1612: AND AWOP.WORKORDER_ID = AWOS.WORKORDER_ID
1613: AND AWOS.DEPARTMENT_ID = ADS.DEPARTMENT_ID (+)