[Home] [Help]
104: SELECT nvl(l.ordered_quantity, 0)
105: - nvl(l.shipped_quantity,0)
106: - nvl(l.cancelled_quantity,0)
107: INTO x_open_qty
108: FROM so_headers h, so_lines l
109: WHERE h.original_system_source_code = p_order_source_id
110: AND h.original_system_reference = p_orig_sys_document_ref
111: AND h.header_id = l.header_id
112: AND l.original_system_line_reference = p_orig_sys_line_ref
214:
215: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
216: SELECT nvl(l.shipped_quantity,0)
217: INTO x_shipped_qty
218: FROM so_headers h, so_lines l
219: WHERE h.original_system_source_code = p_order_source_id
220: AND h.original_system_reference = p_orig_sys_document_ref
221: AND h.header_id = l.header_id
222: AND l.original_system_line_reference = p_orig_sys_line_ref;
331:
332: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
333: SELECT l.cancelled_quantity
334: INTO x_cancelled_qty
335: FROM so_headers h, so_lines l
336: WHERE h.original_system_source_code = p_order_source_id
337: AND h.original_system_reference = p_orig_sys_document_ref
338: AND h.header_id = l.header_id
339: AND l.original_system_line_reference = p_orig_sys_line_ref;
410:
411: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
412: SELECT h.order_number
413: INTO x_order_number
414: FROM so_headers h, so_lines l
415: WHERE h.original_system_source_code = p_order_source_id
416: AND h.original_system_reference = p_orig_sys_document_ref
417: AND h.header_id = l.header_id
418: AND l.original_system_line_reference = p_orig_sys_line_ref;
432: ------------------------------------------------------------------
433: This accepts a Requisition Line Id and returns the corresponding
434: Order Header Id.
435:
436: p_type='S' will get it from so_headers/oe_order_headers table and
437: ='D' will get it from so_drop_ship_sources/oe_drop_ship_sources
438: ------------------------------------------------------------------
439: */
440: -- aksingh question ask whether they are sending id in ref column ????? 11/28
497: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
498: IF p_type = 'H' THEN
499: SELECT h.header_id
500: INTO x_header_id
501: FROM so_headers h
502: WHERE h.original_system_source_code = p_order_source_id
503: AND h.original_system_reference = p_orig_sys_document_ref;
504:
505: ELSIF p_type = 'D' THEN
524: ------------------------------------------------------------------
525: This accepts a Order Header Id and returns the corresponding
526: Requisition Header Id.
527:
528: p_type='S' will get it from so_headers/oe_order_headers table and
529: ='D' will get it from so_drop_ship_sources/oe_drop_ship_sources
530: ------------------------------------------------------------------
531: */
532: FUNCTION Get_Req_Header_Id (
562: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
563: IF p_type = 'H' THEN /* From oe_order_headers */
564: SELECT r.requisition_header_id
565: INTO x_req_header_id
566: FROM so_headers h, po_requisition_headers r
567: WHERE h.header_id = p_header_id
568: AND h.original_system_reference = r.segment1;
569: ELSIF p_type = 'D' THEN /* From oe_drop_ship_sources */
570: SELECT d.requisition_header_id