APPS.PO_RELGEN_PKG dependencies on PO_HEADERS

Line 95: po_headers poh,

91: financials_system_parameters fsp,
92: po_system_parameters psp,
93: po_autosource_documents pad,
94: po_autosource_rules par,
95: po_headers poh,
96: po_lines pol,
97: po_vendors pov
98: where porl.requisition_header_id = prh.requisition_header_id
99: and prh.authorization_status = 'APPROVED'

Line 208: p_vendor_id IN po_headers_all.vendor_id%TYPE,

204: */
205: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,
206: p_category_id IN po_requisition_lines_all.category_id%TYPE,
207: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,
208: p_vendor_id IN po_headers_all.vendor_id%TYPE,
209: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE) return number;
210: cursor requisition_lines_cursor1
211: ( p_req_enc_flag IN VARCHAR2,
212: p_enforce_vendor_hold_flag IN VARCHAR2

Line 209: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE) return number;

205: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,
206: p_category_id IN po_requisition_lines_all.category_id%TYPE,
207: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,
208: p_vendor_id IN po_headers_all.vendor_id%TYPE,
209: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE) return number;
210: cursor requisition_lines_cursor1
211: ( p_req_enc_flag IN VARCHAR2,
212: p_enforce_vendor_hold_flag IN VARCHAR2
213: ) is

Line 255: po_headers poh,

251: porl.drop_ship_flag, --
252: porl.org_id --
253: from po_requisition_lines porl,
254: po_requisition_headers prh,
255: po_headers poh,
256: po_vendors pov,
257: po_lines pol,
258: po_asl_attributes_val_v paa -- Bug: 1945461
259: --bug 2005755 po_asl_documents pod -- Bug 1790311