APPS.OE_ORDER_IMPORT_INTEROP_PUB dependencies on SO_DROP_SHIP_SOURCES

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

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

Line 487: FROM so_drop_ship_sources d

483:
484: ELSIF p_type = 'D' THEN
485: SELECT max(d.header_id)
486: INTO x_header_id
487: FROM so_drop_ship_sources d
488: WHERE d.requisition_header_id = p_requisition_header_id;
489: END IF;
490:
491: END IF;

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

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

Line 551: FROM so_drop_ship_sources d

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
550: INTO x_req_header_id
551: FROM so_drop_ship_sources d
552: WHERE d.header_id = p_header_id;
553: END IF;
554: END IF;
555: RETURN x_req_header_id;