DBA Data[Home] [Help]

APPS.POR_VIEW_REQS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 1292: HR_ALL_ORGANIZATION_UNITS_VL HOU

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
1296: PLL.LINE_LOCATION_ID(+) = PRL.LINE_LOCATION_ID AND

Line 1359: HR_ALL_ORGANIZATION_UNITS_VL HOU

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
1363: PRD.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID AND

Line 1404: HR_ALL_ORGANIZATION_UNITS_VL HOU

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
1408: PRD.REQUISITION_LINE_ID = c_req_line_id AND