[Home] [Help]
43: 'requisition_header_id' is added to requisition_lines_cursor and
44: requisition_lines_cursor1.
45: */
46: /* Supplier PCard FPH. Get the pcard_id from the function
47: * po_pcard_pkg.get_valid_pcard_id. This will fetch pcard_id
48: * if it is valid or null if it is not. The orderby is done
49: * in such a way that all the null pcard_ids and the non null
50: * pcard_ids are grouped together. This way all null will be
51: * grouped into one release. For the others all the same non null
81: prh.requisition_header_id requisition_header_id,
82: porl.secondary_unit_of_measure secondary_unit_of_measure,
83: porl.secondary_quantity secondary_quantity,
84: porl.preferred_grade preferred_grade, /* B1548597 OPM */
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,
148: order by blanket_po_header_id,
149: doc_generation_method,
150: blanket_po_line_num,
151: /* Supplier PCard FPH */
152: 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)),
153: need_by_date, -- bug 2378110
154: requisition_line_id
155: for update of porl.line_location_id;
156:
229: porl.secondary_unit_of_measure secondary_unit_of_measure,
230: porl.secondary_quantity secondary_quantity,
231: porl.preferred_grade preferred_grade, /* B1548597 OPM */
232: /* Supplier PCard FPH */
233: 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,
234: porl.vmi_flag, -- VMI FPH
235: porl.drop_ship_flag, --
236: porl.org_id --
237: from po_requisition_lines porl,
369: order by blanket_po_header_id,
370: doc_generation_method,
371: blanket_po_line_num,
372: /* Supplier PCard FPH */
373: 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)),
374: need_by_date, -- bug 2378110
375: requisition_line_id
376: for update of porl.line_location_id;
377: