APPS.POR_VIEW_REQS_PKG dependencies on PO_CLMREQ_LINE_AWD_REFS_V

Line 1284: FROM PO_CLMREQ_LINE_AWD_REFS_V prh

1280: IF(p_federal='Y')
1281: THEN
1282: SELECT COUNT(DISTINCT(prh.po_header_id))
1283: INTO no_of_po
1284: FROM PO_CLMREQ_LINE_AWD_REFS_V prh
1285: where
1286: prh.requisition_header_id = p_req_header_id;
1287:
1288: IF (no_of_po > 1) THEN

Line 1309: PO_CLMREQ_LINE_AWD_REFS_V ph,

1305: header_id ,
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 (+) ;

Line 1695: FROM PO_CLMREQ_LINE_AWD_REFS_V prh

1691: buyer :=null;
1692:
1693: SELECT COUNT(DISTINCT(prh.po_header_id))
1694: INTO no_of_po
1695: FROM PO_CLMREQ_LINE_AWD_REFS_V prh
1696: where
1697: prh.requisition_line_id = p_req_line_id;
1698:
1699: IF (no_of_po > 1) THEN

Line 1726: FROM PO_CLMREQ_LINE_AWD_REFS_V ph,

1722: order_status ,
1723: order_cancel_flag ,
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