DBA Data[Home] [Help]

APPS.POR_VIEW_REQS_PKG dependencies on PO_HEADERS_ALL

Line 1134: PO_HEADERS_ALL PH

1130: PO_REQUISITION_LINES_ALL PRL,
1131: PO_REQ_DISTRIBUTIONS_ALL PRD,
1132: PO_DISTRIBUTIONS_ALL PD,
1133: PO_RELEASES_ALL PR,
1134: PO_HEADERS_ALL PH
1135: WHERE
1136: PD.PO_HEADER_ID = PH.PO_HEADER_ID AND
1137: PD.PO_RELEASE_ID = PR.PO_RELEASE_ID(+) AND
1138: PRD.DISTRIBUTION_ID = PD.REQ_DISTRIBUTION_ID AND

Line 1209: PO_HEADERS_ALL PH

1205: PO_REQUISITION_LINES_ALL PRL,
1206: PO_REQUISITION_HEADERS_ALL PRH,
1207: PO_LINE_LOCATIONS_ALL PLL,
1208: PO_RELEASES_ALL PR,
1209: PO_HEADERS_ALL PH
1210: WHERE
1211: PLL.PO_HEADER_ID = PH.PO_HEADER_ID AND
1212: PR.PO_RELEASE_ID(+) = PLL.PO_RELEASE_ID AND
1213: PLL.LINE_LOCATION_ID = PRL.LINE_LOCATION_ID AND

Line 1291: PO_HEADERS_ALL PH,

1287: FROM
1288: PO_REQUISITION_LINES_ALL PRL,
1289: PO_LINE_LOCATIONS_ALL PLL,
1290: PO_RELEASES_ALL PR,
1291: PO_HEADERS_ALL PH,
1292: HR_ALL_ORGANIZATION_UNITS_VL HOU
1293: WHERE
1294: PLL.PO_HEADER_ID = PH.PO_HEADER_ID(+) AND
1295: PR.PO_RELEASE_ID(+) = PLL.PO_RELEASE_ID AND

Line 1358: PO_HEADERS_ALL PH,

1354: FROM
1355: PO_REQUISITION_LINES_ALL PRL,
1356: PO_REQ_DISTRIBUTIONS_ALL PRD,
1357: PO_DISTRIBUTIONS_ALL PD,
1358: PO_HEADERS_ALL PH,
1359: HR_ALL_ORGANIZATION_UNITS_VL HOU
1360: WHERE
1361: PD.PO_HEADER_ID = PH.PO_HEADER_ID AND
1362: PRD.DISTRIBUTION_ID = PD.REQ_DISTRIBUTION_ID AND

Line 1403: PO_HEADERS_ALL PH,

1399: HOU.NAME ORG_NAME, PH.ORG_ID
1400: FROM
1401: PO_REQ_DISTRIBUTIONS_ALL PRD,
1402: PO_DISTRIBUTIONS_ALL PD,
1403: PO_HEADERS_ALL PH,
1404: HR_ALL_ORGANIZATION_UNITS_VL HOU
1405: WHERE
1406: PD.PO_HEADER_ID = PH.PO_HEADER_ID AND
1407: PRD.DISTRIBUTION_ID = PD.REQ_DISTRIBUTION_ID AND