APPS.POR_VIEW_REQS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 1310: HR_ALL_ORGANIZATION_UNITS_VL HOU

1306: purchasing_org ,
1307: order_status
1308: FROM
1309: PO_CLMREQ_LINE_AWD_REFS_V ph,
1310: HR_ALL_ORGANIZATION_UNITS_VL HOU
1311: WHERE
1312: ph.requisition_header_id = p_req_header_id
1313: AND PH.ORG_ID = HOU.ORGANIZATION_ID (+) ;
1314:

Line 1415: HR_ALL_ORGANIZATION_UNITS_VL HOU

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

Line 1482: HR_ALL_ORGANIZATION_UNITS_VL HOU

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

Line 1527: HR_ALL_ORGANIZATION_UNITS_VL HOU

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

Line 1728: HR_ALL_ORGANIZATION_UNITS_VL HOU

1724: order_hold_flag ,
1725: buyer
1726: FROM PO_CLMREQ_LINE_AWD_REFS_V ph,
1727: PER_ALL_PEOPLE_F PAPF,
1728: HR_ALL_ORGANIZATION_UNITS_VL HOU
1729: WHERE
1730: ph.requisition_line_id = p_req_line_id
1731: AND PH.ORG_ID = HOU.ORGANIZATION_ID (+)
1732: AND PH.AGENT_ID = PAPF.PERSON_ID (+)