DBA Data[Home] [Help]

APPS.RLM_EXTINTERFACE_SV dependencies on OE_ORDER_LINES_ALL

Line 1824: FROM oe_order_lines_all

1820: -- Making the change to reflect the changes OM made for in OEXFLINB.pls for 1172817
1821: --
1822: SELECT flow_status_code
1823: INTO v_status_code
1824: FROM oe_order_lines_all
1825: where line_id = x_OrderLineId;
1826: --
1827: IF v_status_code <> 'AWAITING_SHIPPING' AND
1828: v_status_code <> 'PRODUCTION_COMPLETE' AND

Line 1834: FROM oe_lookups a, oe_order_lines_all b

1830: v_status_code <> 'PICKED_PARTIAL' THEN
1831: --
1832: SELECT a.meaning
1833: INTO v_line_status
1834: FROM oe_lookups a, oe_order_lines_all b
1835: WHERE a.lookup_type like 'LINE_FLOW_STATUS'
1836: AND a.lookup_code = b.flow_status_code
1837: AND b.line_id = x_OrderLineId;
1838: --