APPS.PO_RELGEN_PKG dependencies on PO_REQUISITION_LINES

Line 89: from po_requisition_lines porl,

85: decode(porl.pcard_flag,'N',null,'S',po_pcard_pkg.get_valid_pcard_id(-99999,porl.vendor_id,porl.vendor_site_id),'Y',po_pcard_pkg.get_valid_pcard_id(prh.pcard_id,porl.vendor_id,porl.vendor_site_id)) pcard_id,
86: porl.vmi_flag, -- VMI FPH
87: porl.drop_ship_flag, --
88: porl.org_id --
89: from po_requisition_lines porl,
90: po_requisition_headers prh,
91: financials_system_parameters fsp,
92: po_system_parameters psp,
93: po_autosource_documents pad,

Line 205: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,

201: For each of the above
202: Local ASL will be preferred over global asl
203: Valid Vendor site will be preferred than vendor_site being null
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;

Line 206: p_category_id IN po_requisition_lines_all.category_id%TYPE,

202: Local ASL will be preferred over global asl
203: Valid Vendor site will be preferred than vendor_site being null
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

Line 207: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,

203: Valid Vendor site will be preferred than vendor_site being null
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,

Line 253: from po_requisition_lines porl,

249: decode(porl.pcard_flag,'N',null,'S',po_pcard_pkg.get_valid_pcard_id(-99999,porl.vendor_id,porl.vendor_site_id),'Y',po_pcard_pkg.get_valid_pcard_id(prh.pcard_id,porl.vendor_id,porl.vendor_site_id)) pcard_id,
250: porl.vmi_flag, -- VMI FPH
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,