[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:
245: porl.secondary_unit_of_measure secondary_unit_of_measure,
246: porl.secondary_quantity secondary_quantity,
247: porl.preferred_grade preferred_grade, /* B1548597 OPM */
248: /* Supplier PCard FPH */
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,
392: order by blanket_po_header_id,
393: doc_generation_method,
394: blanket_po_line_num,
395: /* Supplier PCard FPH */
396: 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)),
397: need_by_date, -- bug 2378110
398: requisition_line_id
399: for update of porl.line_location_id;
400: