APPS.OE_ORDER_IMPORT_INTEROP_PUB dependencies on OE_DROP_SHIP_SOURCES

Line 437: ='D' will get it from so_drop_ship_sources/oe_drop_ship_sources

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
441: FUNCTION Get_Header_Id (

Line 491: FROM oe_drop_ship_sources d

487:
488: ELSIF p_type = 'D' THEN
489: SELECT max(d.header_id)
490: INTO x_header_id
491: FROM oe_drop_ship_sources d
492: WHERE d.requisition_header_id = p_requisition_header_id
493: AND d.requisition_line_id =
494: nvl(p_requisition_line_id, d.requisition_line_id);
495: END IF;

Line 529: ='D' will get it from so_drop_ship_sources/oe_drop_ship_sources

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 (
533: p_header_id IN NUMBER

Line 556: ELSIF p_type = 'D' THEN /* From oe_drop_ship_sources */

552: SELECT source_document_id
553: INTO x_req_header_id
554: FROM oe_order_headers_all
555: WHERE header_id = p_header_id;
556: ELSIF p_type = 'D' THEN /* From oe_drop_ship_sources */
557: SELECT max(d.requisition_header_id)
558: INTO x_req_header_id
559: FROM oe_drop_ship_sources d
560: WHERE d.header_id = p_header_id;

Line 559: FROM oe_drop_ship_sources d

555: WHERE header_id = p_header_id;
556: ELSIF p_type = 'D' THEN /* From oe_drop_ship_sources */
557: SELECT max(d.requisition_header_id)
558: INTO x_req_header_id
559: FROM oe_drop_ship_sources d
560: WHERE d.header_id = p_header_id;
561: END IF;
562: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
563: IF p_type = 'H' THEN /* From oe_order_headers */

Line 569: ELSIF p_type = 'D' THEN /* From oe_drop_ship_sources */

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
571: INTO x_req_header_id
572: FROM so_drop_ship_sources d
573: WHERE d.header_id = p_header_id;

Line 675: FROM oe_drop_ship_sources d

671: l_header_id_count NUMBER := 0;
672: -- Addded not null condition for the bug 3688591
673: CURSOR header_id_cur is
674: SELECT distinct d.requisition_header_id
675: FROM oe_drop_ship_sources d
676: WHERE d.header_id = p_header_id
677: And d.requisition_header_id is not null;
678: --
679: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;