APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on OE_ORDER_LINES_ALL

Line 790: from oe_order_lines_all oel,

786:
787: CURSOR c_open_del_lines(c_line_id NUMBER)
788: IS
789: select 'x'
790: from oe_order_lines_all oel,
791: wsh_delivery_details wdd
792: where oel.open_flag = 'Y'
793: and oel.shipped_quantity is null
794: and oel.line_id = c_line_id

Line 2906: -- Oe_Order_Lines_All based on Header Id and Line Number passed.

2902: -- x_om_line_rec_type => Standalone related order line attributes record
2903: -- x_return_status => Return Status of API (Either S,U)
2904: -- COMMENT:
2905: -- Queries standalone related order lines attributes from table
2906: -- Oe_Order_Lines_All based on Header Id and Line Number passed.
2907: --=============================================================================
2908: --
2909: PROCEDURE Check_Line_Exists (
2910: p_header_id IN NUMBER,

Line 2934: from oe_order_lines_all

2930: cust_po_number,
2931: subinventory,
2932: unit_selling_price,
2933: rownum
2934: from oe_order_lines_all
2935: where line_number = p_line_number
2936: and header_id = p_header_id;
2937:
2938: l_ship_set_id NUMBER;

Line 3056: from oe_order_lines_all oel,

3052:
3053: cursor c_lock_interface_lines
3054: is
3055: select oel.line_id
3056: from oe_order_lines_all oel,
3057: wsh_del_details_interface wddi,
3058: wsh_del_assgn_interface wdai
3059: where oel.header_id = p_header_id
3060: and oel.line_number = wddi.line_number

Line 3070: from oe_order_lines_all oel

3066:
3067: cursor c_lock_non_interface_lines
3068: is
3069: select oel.line_id
3070: from oe_order_lines_all oel
3071: where oel.header_id = p_header_id
3072: and not exists
3073: ( select '1'
3074: from wsh_del_details_interface wddi,

Line 6371: FROM oe_order_lines_all oel

6367: CURSOR c_non_interface_order_lines
6368: IS
6369: SELECT oel.line_id,
6370: oel.line_number
6371: FROM oe_order_lines_all oel
6372: WHERE header_id = p_om_header_rec_type.header_id
6373: AND NOT EXISTS
6374: ( SELECT 'X'
6375: FROM Wsh_Del_Details_Interface wddi,