DBA Data[Home] [Help]

APPS.WSM_WSMPNTXN_XMLP_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 99: PO_REQUISITION_LINES_ALL PRL

95: UNION ALL
96: SELECT
97: PRL.WIP_ENTITY_ID
98: FROM
99: PO_REQUISITION_LINES_ALL PRL
100: WHERE PRL.DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID
101: AND NVL(PRL.CANCEL_FLAG
102: ,'N') = 'N'
103: AND PRL.LINE_LOCATION_ID is null

Line 357: PO_REQUISITION_LINES_ALL PRL

353: OR exists (
354: SELECT
355: 1
356: FROM
357: PO_REQUISITION_LINES_ALL PRL
358: WHERE PRL.DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID
359: AND PRL.WIP_ENTITY_ID = WIP_ENTITY_ID_1
360: AND NVL(PRL.CANCEL_FLAG
361: ,'N') = 'N'