DBA Data[Home] [Help]

APPS.WSM_WSMPNTXN_XMLP_PKG dependencies on PO_HEADERS_ALL

Line 83: PO_HEADERS_ALL PH,

79: SELECT
80: PD.WIP_ENTITY_ID
81: FROM
82: PO_RELEASES_ALL PR,
83: PO_HEADERS_ALL PH,
84: PO_DISTRIBUTIONS_ALL PD,
85: PO_LINE_LOCATIONS_ALL PL
86: WHERE PD.DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID
87: AND PD.PO_LINE_ID is not null

Line 339: PO_HEADERS_ALL PH,

335: SELECT
336: 1
337: FROM
338: PO_RELEASES_ALL PR,
339: PO_HEADERS_ALL PH,
340: PO_DISTRIBUTIONS_ALL PD,
341: PO_LINE_LOCATIONS_ALL PL
342: WHERE PD.DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID
343: AND PD.WIP_ENTITY_ID = WIP_ENTITY_ID_1