[Home] [Help]
99: SELECT nvl(l.ordered_quantity, 0)
100: - nvl(l.shipped_quantity,0)
101: - nvl(l.cancelled_quantity,0)
102: INTO x_open_qty
103: FROM so_headers h, so_lines l
104: WHERE h.original_system_source_code = p_order_source_id
105: AND h.original_system_reference = p_orig_sys_document_ref
106: AND h.header_id = l.header_id
107: AND l.original_system_line_reference = p_orig_sys_line_ref
204:
205: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
206: SELECT nvl(l.shipped_quantity,0)
207: INTO x_shipped_qty
208: FROM so_headers h, so_lines l
209: WHERE h.original_system_source_code = p_order_source_id
210: AND h.original_system_reference = p_orig_sys_document_ref
211: AND h.header_id = l.header_id
212: AND l.original_system_line_reference = p_orig_sys_line_ref;
316:
317: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
318: SELECT l.cancelled_quantity
319: INTO x_cancelled_qty
320: FROM so_headers h, so_lines l
321: WHERE h.original_system_source_code = p_order_source_id
322: AND h.original_system_reference = p_orig_sys_document_ref
323: AND h.header_id = l.header_id
324: AND l.original_system_line_reference = p_orig_sys_line_ref;
394:
395: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
396: SELECT h.order_number
397: INTO x_order_number
398: FROM so_headers h, so_lines l
399: WHERE h.original_system_source_code = p_order_source_id
400: AND h.original_system_reference = p_orig_sys_document_ref
401: AND h.header_id = l.header_id
402: AND l.original_system_line_reference = p_orig_sys_line_ref;
416: ------------------------------------------------------------------
417: This accepts a Requisition Line Id and returns the corresponding
418: Order Header Id.
419:
420: p_type='S' will get it from so_headers/oe_order_headers table and
421: ='D' will get it from so_drop_ship_sources/oe_drop_ship_sources
422: ------------------------------------------------------------------
423: */
424: -- aksingh question ask whether they are sending id in ref column ????? 11/28
476: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
477: IF p_type = 'H' THEN
478: SELECT h.header_id
479: INTO x_header_id
480: FROM so_headers h
481: WHERE h.original_system_source_code = p_order_source_id
482: AND h.original_system_reference = p_orig_sys_document_ref;
483:
484: ELSIF p_type = 'D' THEN
503: ------------------------------------------------------------------
504: This accepts a Order Header Id and returns the corresponding
505: Requisition Header Id.
506:
507: p_type='S' will get it from so_headers/oe_order_headers table and
508: ='D' will get it from so_drop_ship_sources/oe_drop_ship_sources
509: ------------------------------------------------------------------
510: */
511: FUNCTION Get_Req_Header_Id (
541: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
542: IF p_type = 'H' THEN /* From oe_order_headers */
543: SELECT r.requisition_header_id
544: INTO x_req_header_id
545: FROM so_headers h, po_requisition_headers r
546: WHERE h.header_id = p_header_id
547: AND h.original_system_reference = r.segment1;
548: ELSIF p_type = 'D' THEN /* From oe_drop_ship_sources */
549: SELECT d.requisition_header_id