APPS.OE_ORDER_IMPORT_INTEROP_PUB dependencies on SO_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 508: FROM so_drop_ship_sources d

504:
505: ELSIF p_type = 'D' THEN
506: SELECT max(d.header_id)
507: INTO x_header_id
508: FROM so_drop_ship_sources d
509: WHERE d.requisition_header_id = p_requisition_header_id;
510: END IF;
511:
512: 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 572: FROM so_drop_ship_sources d

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;
574: END IF;
575: END IF;
576: RETURN x_req_header_id;