DBA Data[Home] [Help]

APPS.WIP_RESOURCE_VALIDATIONS dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 387: FROM PO_REQUISITIONS_INTERFACE_ALL PRI

383: AND nvl(PRL.cancel_flag, 'N') = 'N'
384: AND PRL.LINE_LOCATION_ID is NULL
385: UNION ALL
386: SELECT 'PO/REQ Linked'
387: FROM PO_REQUISITIONS_INTERFACE_ALL PRI
388: WHERE PRI.WIP_ENTITY_ID = p_wip_entity_id
389: AND PRI.DESTINATION_ORGANIZATION_ID = p_organization_id
390: AND (p_operation_seq_num is NULL OR
391: PRI.WIP_OPERATION_SEQ_NUM = p_operation_seq_num)

Line 503: FROM PO_REQUISITIONS_INTERFACE_ALL PRI

499: AND nvl(PRL.cancel_flag, 'N') = 'N'
500: AND PRL.LINE_LOCATION_ID is NULL
501: UNION ALL
502: SELECT 'PO/REQ Linked'
503: FROM PO_REQUISITIONS_INTERFACE_ALL PRI
504: WHERE PRI.WIP_ENTITY_ID = p_wip_entity_id
505: AND PRI.DESTINATION_ORGANIZATION_ID = p_organization_id
506: AND (p_operation_seq_num is NULL OR
507: PRI.WIP_OPERATION_SEQ_NUM = p_operation_seq_num)