APPS.FV_CROSS_DOC_REF dependencies on PO_LINES

Line 123: FROM po_headers ph,po_lines pl,po_line_locations pll

119: l_errbuf VARCHAR2(1024);
120:
121: CURSOR po_cur IS
122: SELECT ph.po_header_id,pl.po_line_id,pll.line_location_id
123: FROM po_headers ph,po_lines pl,po_line_locations pll
124: WHERE ph.po_header_id = pl.po_header_id
125: AND pl.po_line_id = pll.po_line_id
126: AND vendor_id = vp_vendor_id
127: AND vendor_site_id = vp_vendor_site_id

Line 134: FROM po_headers ph,po_lines pl,po_line_locations pll

130: AND ph.agent_id = nvl(vp_buyer,ph.agent_id)
131: AND NOT EXISTS(SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
132: UNION
133: SELECT ph.po_header_id,pl.po_line_id,pll.line_location_id
134: FROM po_headers ph,po_lines pl,po_line_locations pll
135: WHERE ph.po_header_id = pl.po_header_id
136: AND pl.po_line_id = pll.po_line_id
137: AND vendor_id = vp_vendor_id
138: AND vendor_site_id = vp_vendor_site_id

Line 148: FROM po_headers ph,po_lines pl,po_line_locations pll

144: po_rec po_cur%ROWTYPE;
145:
146: CURSOR req_cur IS
147: SELECT ph.po_header_id,pl.po_line_id, pll.line_location_id
148: FROM po_headers ph,po_lines pl,po_line_locations pll
149: WHERE ph.po_header_id = pl.po_header_id
150: AND pl.po_line_id = pll.po_line_id
151: AND EXISTS(SELECT prh.requisition_header_id,prl.requisition_line_id
152: FROM po_requisition_headers prh,po_requisition_lines prl