APPS.OE_LINE_STATUS_PUB dependencies on OE_ORDER_LINES_ALL

Line 33: FROM oe_order_lines_all

29: BEGIN
30:
31: SELECT cancelled_flag
32: INTO l_cancel_flag
33: FROM oe_order_lines_all
34: WHERE line_id = p_line_id;
35:
36: -- we are returning Line_Closed_Status,
37: -- so we return Y when open_flag is N

Line 132: FROM oe_order_lines_all

128: BEGIN
129:
130: SELECT nvl(open_flag, 'Y')
131: INTO l_open_flag
132: FROM oe_order_lines_all
133: WHERE line_id = p_line_id;
134:
135: -- we are returning Line_Closed_Status,
136: -- so we return Y when open_flag is N

Line 331: FROM oe_order_lines_all

327: BEGIN
328:
329: SELECT nvl(shipped_quantity, 0)
330: INTO l_shipped_quantity
331: FROM oe_order_lines_all
332: WHERE line_id = p_line_id;
333:
334: -- we are returning Line_shipped_Status,
335: -- so we return Y when line is shipped

Line 395: FROM oe_order_lines_all

391: -- END IF;
392:
393: SELECT nvl(shipped_quantity, 0),actual_shipment_date
394: INTO l_shipped_quantity,x_result_date
395: FROM oe_order_lines_all
396: WHERE line_id = p_line_id;
397:
398: -- we are returning Line_shipped_Status,
399: -- so we return Y when line is shipped

Line 583: FROM oe_order_lines_all

579:
580:
581: SELECT nvl(shipped_quantity, 0)
582: INTO l_received_quantity
583: FROM oe_order_lines_all
584: WHERE line_id = p_line_id;
585:
586: -- we are returning Line_Receive_Status,
587: -- so we return Y when line is received

Line 682: FROM oe_order_lines_all

678: BEGIN
679:
680: SELECT invoice_interface_status_code
681: INTO l_invoice_interface_status
682: FROM oe_order_lines_all
683: WHERE line_id = p_line_id;
684:
685: -- return Y when invoice_interface_status_code is YES
686: -- and return N otherwise (for 'NO', 'PARTIAL' and 'NOT_ELIGIBLE')

Line 747: FROM oe_order_lines_all

743: WHEN NO_DATA_FOUND THEN
744:
745: SELECT header_id
746: INTO l_header_id
747: FROM oe_order_lines_all
748: WHERE line_id = p_line_id;
749:
750: SELECT wias.end_date
751: INTO x_result_date