DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on BOM_RESOURCES

Line 884: FROM AHL_WIP_RESOURCE_TXNS_V WIP,BOM_RESOURCES BR, MFG_LOOKUPS MFGL

880: WIP.UOM_MEANING, WIP.ACTIVITY_ID, WIP.ACTIVITY, WIP.REASON_ID, WIP.REASON_NAME,
881: WIP.REFERENCE, WIP.TRANSACTION_DATE,
882: WIP.TRANSACTION_STATUS, MFGL.MEANING RESOURCE_TYPE,
883: BR.RESOURCE_TYPE RESOURCE_TYPE_CODE, NULL SERIAL_NUMBER
884: FROM AHL_WIP_RESOURCE_TXNS_V WIP,BOM_RESOURCES BR, MFG_LOOKUPS MFGL
885: WHERE WORKORDER_ID = p_WorkorderId
886: AND OPERATION_SEQ_NUM = NVL(p_OperationSequence,OPERATION_SEQ_NUM )
887: AND BR.resource_id = WIP.resource_id
888: AND MFGL.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'