DBA Data[Home] [Help]

APPS.POR_VIEW_REQS_PKG dependencies on PO_HEADERS_ALL

Line 1212: PO_HEADERS_ALL PH

1208: PO_REQUISITION_LINES_ALL PRL,
1209: PO_REQ_DISTRIBUTIONS_ALL PRD,
1210: PO_DISTRIBUTIONS_ALL PD,
1211: PO_RELEASES_ALL PR,
1212: PO_HEADERS_ALL PH
1213: WHERE
1214: PD.PO_HEADER_ID = PH.PO_HEADER_ID AND
1215: PD.PO_RELEASE_ID = PR.PO_RELEASE_ID(+) AND
1216: PRD.DISTRIBUTION_ID = PD.REQ_DISTRIBUTION_ID AND

Line 1332: PO_HEADERS_ALL PH

1328: PO_REQUISITION_LINES_ALL PRL,
1329: PO_REQUISITION_HEADERS_ALL PRH,
1330: PO_LINE_LOCATIONS_ALL PLL,
1331: PO_RELEASES_ALL PR,
1332: PO_HEADERS_ALL PH
1333: WHERE
1334: PLL.PO_HEADER_ID = PH.PO_HEADER_ID AND
1335: PR.PO_RELEASE_ID(+) = PLL.PO_RELEASE_ID AND
1336: PLL.LINE_LOCATION_ID = PRL.LINE_LOCATION_ID AND

Line 1414: PO_HEADERS_ALL PH,

1410: FROM
1411: PO_REQUISITION_LINES_ALL PRL,
1412: PO_LINE_LOCATIONS_ALL PLL,
1413: PO_RELEASES_ALL PR,
1414: PO_HEADERS_ALL PH,
1415: HR_ALL_ORGANIZATION_UNITS_VL HOU
1416: WHERE
1417: PLL.PO_HEADER_ID = PH.PO_HEADER_ID(+) AND
1418: PR.PO_RELEASE_ID(+) = PLL.PO_RELEASE_ID AND

Line 1481: PO_HEADERS_ALL PH,

1477: FROM
1478: PO_REQUISITION_LINES_ALL PRL,
1479: PO_REQ_DISTRIBUTIONS_ALL PRD,
1480: PO_DISTRIBUTIONS_ALL PD,
1481: PO_HEADERS_ALL PH,
1482: HR_ALL_ORGANIZATION_UNITS_VL HOU
1483: WHERE
1484: PD.PO_HEADER_ID = PH.PO_HEADER_ID AND
1485: PRD.DISTRIBUTION_ID = PD.REQ_DISTRIBUTION_ID AND

Line 1526: PO_HEADERS_ALL PH,

1522: HOU.NAME ORG_NAME, PH.ORG_ID
1523: FROM
1524: PO_REQ_DISTRIBUTIONS_ALL PRD,
1525: PO_DISTRIBUTIONS_ALL PD,
1526: PO_HEADERS_ALL PH,
1527: HR_ALL_ORGANIZATION_UNITS_VL HOU
1528: WHERE
1529: PD.PO_HEADER_ID = PH.PO_HEADER_ID AND
1530: PRD.DISTRIBUTION_ID = PD.REQ_DISTRIBUTION_ID AND