DBA Data[Home] [Help]

APPS.AHL_PRD_PRINT_PVT dependencies on MFG_LOOKUPS

Line 2191: BOM_RESOURCES BOM, MFG_LOOKUPS MFG, AHL_WORKORDERS WO

2187: (select awo.operation_id from AHL_WORKORDER_OPERATIONS AWO
2188: where AWO.workorder_id = wo.workorder_id
2189: and awo.operation_sequence_num = WOR.OPERATION_SEQ_NUM) operation_id
2190: FROM WIP_OPERATION_RESOURCES WOR,
2191: BOM_RESOURCES BOM, MFG_LOOKUPS MFG, AHL_WORKORDERS WO
2192: WHERE WO.workorder_id = c_wo_id
2193: AND WOR.resource_id = BOM.resource_id
2194: AND WO.wip_entity_id = WOR.wip_entity_id
2195: AND MFG.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'

Line 7978: BOM_RESOURCES BOM, MFG_LOOKUPS MFG, AHL_WORKORDERS WO

7974: (select awo.operation_id from AHL_WORKORDER_OPERATIONS AWO
7975: where AWO.workorder_id = wo.workorder_id
7976: and awo.operation_sequence_num = WOR.OPERATION_SEQ_NUM) operation_id
7977: FROM WIP_OPERATION_RESOURCES WOR,
7978: BOM_RESOURCES BOM, MFG_LOOKUPS MFG, AHL_WORKORDERS WO
7979: WHERE WO.workorder_id = c_wo_id
7980: AND WOR.resource_id = BOM.resource_id
7981: AND WO.wip_entity_id = WOR.wip_entity_id
7982: AND MFG.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'