DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on MFG_LOOKUPS

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

862: WIP.UOM_MEANING, WIP.ACTIVITY_ID, WIP.ACTIVITY, WIP.REASON_ID, WIP.REASON_NAME,
863: WIP.REFERENCE, WIP.TRANSACTION_DATE,
864: WIP.TRANSACTION_STATUS, MFGL.MEANING RESOURCE_TYPE,
865: BR.RESOURCE_TYPE RESOURCE_TYPE_CODE, NULL SERIAL_NUMBER
866: FROM AHL_WIP_RESOURCE_TXNS_V WIP,BOM_RESOURCES BR, MFG_LOOKUPS MFGL
867: WHERE WORKORDER_ID = p_WorkorderId
868: AND OPERATION_SEQ_NUM = NVL(p_OperationSequence,OPERATION_SEQ_NUM )
869: AND BR.resource_id = WIP.resource_id
870: AND MFGL.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'