DBA Data[Home] [Help]

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 1366: FROM oe_order_lines_all ool

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

Line 1375: SELECT 1 from oe_order_lines_all

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

Line 1499: from oe_order_lines_all

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