DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 2797: -- Oe_Order_Headers_All based on Order Number and Order Type passed.

2793: -- x_om_header_rec_type => Standalone related order header attributes record
2794: -- x_return_status => Return Status of API (Either S,U)
2795: -- COMMENT:
2796: -- Queries standalone related order header attributes from table
2797: -- Oe_Order_Headers_All based on Order Number and Order Type passed.
2798: --=============================================================================
2799: --
2800: PROCEDURE Check_Header_Exists (
2801: p_order_number IN NUMBER,

Line 2825: from oe_order_headers_all

2821: payment_term_id,
2822: shipping_method_code,
2823: freight_terms_code,
2824: fob_point_code
2825: from oe_order_headers_all
2826: where order_number = p_order_number
2827: and order_type_id = p_order_type_id;
2828:
2829: --

Line 3127: from oe_order_headers_all

3123: END IF;
3124: --
3125: select header_id
3126: into l_header_id
3127: from oe_order_headers_all
3128: where header_id = p_header_id
3129: for update nowait;
3130:
3131: --