DBA Data[Home] [Help]

APPS.WSM_WSMPNTXN_XMLP_PKG dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 108: PO_REQUISITIONS_INTERFACE_ALL PRI

104: UNION ALL
105: SELECT
106: PRI.WIP_ENTITY_ID
107: FROM
108: PO_REQUISITIONS_INTERFACE_ALL PRI
109: WHERE PRI.DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID );
110: RETURN 1;
111: END QR_PTXN_JOBREFCURDS;
112:

Line 367: PO_REQUISITIONS_INTERFACE_ALL PRI

363: OR exists (
364: SELECT
365: 1
366: FROM
367: PO_REQUISITIONS_INTERFACE_ALL PRI
368: WHERE PRI.DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID
369: AND PRI.WIP_ENTITY_ID = WIP_ENTITY_ID_1 );
370: EXCEPTION
371: WHEN NO_DATA_FOUND THEN