DBA Data[Home] [Help]

APPS.OE_ORDER_PURGE_PVT dependencies on OE_ORDER_LINES_ALL

Line 1915: FROM oe_order_lines_all sl1,

1911: SELECT 'Open return for this sales order'
1912: /*MOAC*/
1913: --FROM oe_order_lines sl1,
1914: --oe_order_lines sl2,
1915: FROM oe_order_lines_all sl1,
1916: oe_order_lines_all sl2,
1917: oe_order_headers_all sh,
1918: oe_order_types_v ot --MOAC view based on multiple objects
1919: WHERE sh.order_number = p_order_number

Line 1916: oe_order_lines_all sl2,

1912: /*MOAC*/
1913: --FROM oe_order_lines sl1,
1914: --oe_order_lines sl2,
1915: FROM oe_order_lines_all sl1,
1916: oe_order_lines_all sl2,
1917: oe_order_headers_all sh,
1918: oe_order_types_v ot --MOAC view based on multiple objects
1919: WHERE sh.order_number = p_order_number
1920: AND sh.order_type_id = ot.order_type_id