APPS.OE_FREIGHT_CHOICES_PVT dependencies on OE_ORDER_LINES_ALL

Line 127: FROM oe_order_lines_all

123: ,change_sequence
124: ,source_document_type_id
125: ,source_document_id
126: ,source_document_line_id
127: FROM oe_order_lines_all
128: WHERE header_id = p_header_id
129: AND p_action <> 'R'
130: ORDER BY top_model_line_id, ato_line_id, sort_order;
131:

Line 135: FROM oe_order_lines_all

131:
132:
133: CURSOR C_INC_ITEMS_PARENT IS
134: SELECT line_id
135: FROM oe_order_lines_all
136: WHERE item_type_code IN ('MODEL', 'CLASS', 'KIT')
137: AND ato_line_id is NULL
138: AND explosion_date is NULL
139: AND NVL(fulfilled_flag,'N') <> 'Y'

Line 230: FROM oe_order_lines_all

226: -- Now number of Config lines in the table
227:
228: SELECT count(*)
229: INTO l_config_count
230: FROM oe_order_lines_all
231: WHERE item_type_code = 'CONFIG'
232: AND ato_line_id IS NOT NULL
233: AND header_id = p_header_id;
234:

Line 1365: FROM oe_order_lines_all ool

1361: CURSOR C_CONFIG_ITEM_PARENTS(p_ato_line_id IN NUMBER) IS
1362: SELECT opa.price_adjustment_id,ool.line_id,
1363: opa.adjusted_amount, opa.list_line_type_code,
1364: opa.charge_type_code
1365: FROM oe_order_lines_all ool
1366: ,oe_price_adjustments opa
1367: WHERE opa.charge_type_code IN ('FTEPRICE','FTECHARGE')
1368: AND list_line_type_code = 'COST' -- For bug 7043225
1369: AND ool.line_id = opa.line_id

Line 1374: SELECT 1 from oe_order_lines_all

1370: AND ool.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
1371: AND ool.ato_line_id = p_ato_line_id;
1372:
1373: /*CURSOR C_CONFIG_LINE_EXISTS(p_line_id IN NUMBER) IS
1374: SELECT 1 from oe_order_lines_all
1375: WHERE ato_line_id = p_line_id
1376: AND item_type_code = OE_GLOBALS.G_ITEM_CONFIG;
1377: */
1378: BEGIN

Line 1498: from oe_order_lines_all

1494: -- added by Renga after review
1495: IF query_line_tbl(1).ato_line_id is not null then
1496:
1497: select count(*) into l_config_line_exists
1498: from oe_order_lines_all
1499: where ato_line_id = query_line_tbl(1).ato_line_id
1500: and item_type_code = 'CONFIG';
1501:
1502: END IF; --ato_line_id is not null