APPS.CSI_DEBUG_PKG dependencies on OE_ORDER_LINES_ALL

Line 2219: FROM oe_order_lines_all

2215: SELECT line_id,
2216: inventory_item_id
2217: INTO l_ato_model_tbl(l_ind).config_line_id,
2218: l_ato_model_tbl(l_ind).config_item_id
2219: FROM oe_order_lines_all
2220: WHERE header_id = p_order_lines(p_ind).header_id
2221: AND link_to_line_id = p_order_lines(p_ind).ato_line_id
2222: AND item_type_code = 'CONFIG';
2223: EXCEPTION

Line 2232: FROM oe_order_lines_all

2228: SELECT line_id,
2229: inventory_item_id
2230: INTO l_ato_model_tbl(l_ind).config_line_id,
2231: l_ato_model_tbl(l_ind).config_item_id
2232: FROM oe_order_lines_all
2233: WHERE header_id = p_order_lines(p_ind).header_id
2234: AND link_to_line_id = p_order_lines(p_ind).ato_line_id
2235: AND item_type_code = 'CONFIG'
2236: AND split_from_line_id is null;

Line 2484: FROM oe_order_lines_all oel,

2480: oel.shipping_interfaced_flag,
2481: oel.split_from_line_id,
2482: oel.actual_shipment_date,
2483: oel.shipped_quantity
2484: FROM oe_order_lines_all oel,
2485: oe_order_headers_all oeh
2486: WHERE oeh.order_number = p_order_number
2487: AND oel.header_id = oeh.header_id
2488: ORDER BY oel.line_number, oel.sort_order;

Line 2632: p_source_table => 'OE_ORDER_LINES_ALL');

2628: px_order_lines => l_order_lines);
2629:
2630: dump_installation_details(
2631: p_order_lines => l_order_lines,
2632: p_source_table => 'OE_ORDER_LINES_ALL');
2633:
2634: dump_installation_details(
2635: p_order_lines => l_order_lines,
2636: p_source_table => 'WSH_DELIVERY_DETAILS');