eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_CHANGE_ORDER_PK dependencies on OE_ORDER_LINES

Line 397: lconfig_id oe_order_lines.configuration_id%type;

393: l_decimal_qty boolean := TRUE ;
394: lcancel_line boolean := FALSE;
395: lconfig_line_id number;
396: i binary_integer;
397: lconfig_id oe_order_lines.configuration_id%type;
398: lorder_no oe_order_headers_all.order_number%type;
399: lheader_id oe_order_headers_all.header_id%type;
400: lplanner_code fnd_user.user_name%type; -- Modified by Renga on 11/24/04
401: --for bug 4026568

Line 428: l_source_type_code oe_order_lines_all.source_type_code%type;

424: notify_flag Boolean := TRUE;
425:
426:
427:
428: l_source_type_code oe_order_lines_all.source_type_code%type;
429:
430: v_options_index number ;
431: v_splits_index number ;
432: l_unschedule_action boolean ;

Line 589: FROM OE_ORDER_LINES_ALL

585: lheader_id,
586: lorg_id,
587: l_source_type_code,
588: l_shipping_xfaced_flag -- Bug Fix: 4863275
589: FROM OE_ORDER_LINES_ALL
590: WHERE line_id = ato_line_id
591: AND ( item_type_code = 'STANDARD' OR item_type_code = 'OPTION' )
592: AND line_id = pLineid;
593:

Line 643: FROM oe_order_lines_all

639: lorg_id,
640: lheader_id,
641: l_source_type_code,
642: l_shipping_xfaced_flag -- Bug Fix: 4863275
643: FROM oe_order_lines_all
644: WHERE ato_line_id = plineid
645: AND item_type_code = 'CONFIG';
646:
647: IF PG_DEBUG <> 0 THEN

Line 1259: oe_order_lines_all oel,

1255: SELECT reservation_id
1256: INTO l_reservation_id
1257: FROM
1258: mtl_reservations mr,
1259: oe_order_lines_all oel,
1260: oe_order_headers_all oeh,
1261: oe_transaction_types_all ota,
1262: oe_transaction_types_tl otl,
1263: mtl_sales_orders mso

Line 1339: linv_item_id oe_order_lines_all.inventory_item_id%type;

1335:
1336: lcust_line_no varchar2(50);
1337: lnotify_person varchar2(200);
1338: i binary_integer;
1339: linv_item_id oe_order_lines_all.inventory_item_id%type;
1340: lplanner_code fnd_user.user_name%type; -- Modified by Renga on
1341: --11/24/04 for bug 4026568
1342: lship_org_id oe_order_lines_all.ship_from_org_id%type;
1343: ldummy varchar2(1);

Line 1342: lship_org_id oe_order_lines_all.ship_from_org_id%type;

1338: i binary_integer;
1339: linv_item_id oe_order_lines_all.inventory_item_id%type;
1340: lplanner_code fnd_user.user_name%type; -- Modified by Renga on
1341: --11/24/04 for bug 4026568
1342: lship_org_id oe_order_lines_all.ship_from_org_id%type;
1343: ldummy varchar2(1);
1344: lstmt number;
1345: --- Added by Renga Kannan on 03/23/2001 to implement the new bulk attribute setting calls for wf_engine
1346: l_aname wf_engine.nametabtyp;

Line 1352: l_header_id oe_order_lines_all.header_id%type;

1348: l_atxtvalue wf_engine.texttabtyp;
1349: -- End of additions.
1350:
1351: l_cancel_flag varchar2(1) := 'N';
1352: l_header_id oe_order_lines_all.header_id%type;
1353:
1354: l_mlsupply_items CTO_SUBASSEMBLY_SUP_PK.t_item_details;
1355: l_items VARCHAR2(4000);
1356: l_mlsupply_parameter number;

Line 1384: l_ord_uom2 oe_order_lines_all.ORDERED_QUANTITY_UOM2%type;

1380:
1381: --for OPM project :kkonada
1382: lord_qty2 number; --ordered qty in secondary uom
1383: l_old_ord_qty2 number;
1384: l_ord_uom2 oe_order_lines_all.ORDERED_QUANTITY_UOM2%type;
1385: l_old_ord_uom2 oe_order_lines_all.ordered_quantity_uom2%type;
1386: l_old_ord_qty number;
1387: l_ord_uom oe_order_lines_all.order_quantity_uom%type;
1388: l_old_ord_uom oe_order_lines_all.order_quantity_uom%type;

Line 1385: l_old_ord_uom2 oe_order_lines_all.ordered_quantity_uom2%type;

1381: --for OPM project :kkonada
1382: lord_qty2 number; --ordered qty in secondary uom
1383: l_old_ord_qty2 number;
1384: l_ord_uom2 oe_order_lines_all.ORDERED_QUANTITY_UOM2%type;
1385: l_old_ord_uom2 oe_order_lines_all.ordered_quantity_uom2%type;
1386: l_old_ord_qty number;
1387: l_ord_uom oe_order_lines_all.order_quantity_uom%type;
1388: l_old_ord_uom oe_order_lines_all.order_quantity_uom%type;
1389: l_qty_set varchar2(1) := 'N';

Line 1387: l_ord_uom oe_order_lines_all.order_quantity_uom%type;

1383: l_old_ord_qty2 number;
1384: l_ord_uom2 oe_order_lines_all.ORDERED_QUANTITY_UOM2%type;
1385: l_old_ord_uom2 oe_order_lines_all.ordered_quantity_uom2%type;
1386: l_old_ord_qty number;
1387: l_ord_uom oe_order_lines_all.order_quantity_uom%type;
1388: l_old_ord_uom oe_order_lines_all.order_quantity_uom%type;
1389: l_qty_set varchar2(1) := 'N';
1390: l_qty2_set varchar2(1) := 'N';
1391:

Line 1388: l_old_ord_uom oe_order_lines_all.order_quantity_uom%type;

1384: l_ord_uom2 oe_order_lines_all.ORDERED_QUANTITY_UOM2%type;
1385: l_old_ord_uom2 oe_order_lines_all.ordered_quantity_uom2%type;
1386: l_old_ord_qty number;
1387: l_ord_uom oe_order_lines_all.order_quantity_uom%type;
1388: l_old_ord_uom oe_order_lines_all.order_quantity_uom%type;
1389: l_qty_set varchar2(1) := 'N';
1390: l_qty2_set varchar2(1) := 'N';
1391:
1392: -- bug 7447357.pdube Mon Oct 20 04:03:59 PDT 2008

Line 1426: oe_order_lines_all oel,

1422: CURSOR get_buyer_from_po(config_line_id IN NUMBER) IS
1423: select u.user_name
1424: from mtl_reservations mr,
1425: po_headers_all poh,
1426: oe_order_lines_all oel,
1427: fnd_user u
1428: where oel.line_id = config_line_id and
1429: mr.demand_source_type_id in (8,2) and
1430: mr.demand_source_line_id = oel.line_id and

Line 1444: oe_order_lines_all oel,

1440: select u.user_name
1441: from mtl_reservations mr,
1442: po_requisition_headers_all porh,
1443: po_requisition_lines_all porl,
1444: oe_order_lines_all oel,
1445: fnd_user u
1446: where oel.line_id = config_line_id and
1447: mr.demand_source_type_id in (8,2) and
1448: mr.demand_source_line_id = oel.line_id and

Line 1460: from oe_order_lines_all

1456: -- bug 7447357.ntungare
1457: -- Cursor to get the Config Item line id
1458: CURSOR get_config_line_id(p_header_id IN NUMBER) IS
1459: select line_id
1460: from oe_order_lines_all
1461: where inventory_item_id = pconfig_id and
1462: header_id = p_header_id;
1463:
1464: l_config_line_id NUMBER;

Line 1483: -- Get the information from OE_ORDER_LINES_ALL table for the Model line

1479: litem_key := to_char(pline_no)||to_char(sysdate,'mmddyyhhmiss');
1480: luser_key := litem_key;
1481:
1482: --
1483: -- Get the information from OE_ORDER_LINES_ALL table for the Model line
1484: --
1485:
1486: lstmt := 20;
1487: IF PG_DEBUG <> 0 THEN

Line 1488: oe_debug_pub.add('start_work_flow: ' || 'Getting details from Oe_order_lines for line id '||to_char(pline_no),5);

1484: --
1485:
1486: lstmt := 20;
1487: IF PG_DEBUG <> 0 THEN
1488: oe_debug_pub.add('start_work_flow: ' || 'Getting details from Oe_order_lines for line id '||to_char(pline_no),5);
1489: END IF;
1490:
1491: SELECT
1492: schedule_ship_date,

Line 1517: oe_order_lines_all

1513: l_header_id,
1514: l_ord_uom2, --ORDERED_QUANTITY_UOM2 for OPM proj
1515: l_ord_uom --order_quantity_uom for OPM proj
1516: FROM
1517: oe_order_lines_all
1518: WHERE
1519: line_id = pline_no;
1520:
1521: --OPM. Defaulting the primary and secondry uom and qty

Line 1815: from oe_order_lines_all oel

1811:
1812:
1813: select oel.line_number || '.' || oel.shipment_number || '.' || nvl( oel.option_number , '' ) , ordered_quantity
1814: into v_model_line_num , v_split_qty
1815: from oe_order_lines_all oel
1816: where line_id = v_split_line_id ;
1817:
1818: /*
1819: select ordered_quantity into v_split_qty from bom_cto_order_lines

Line 2363: l_ato_line_id OE_ORDER_LINES_ALL.ATO_LINE_ID%TYPE;

2359: X_Msg_data OUT NOCOPY Varchar2) IS
2360:
2361: TYPE PROCESS_SET IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;
2362: l_chgtype CTO_CHANGE_ORDER_PK.change_table_type;
2363: l_ato_line_id OE_ORDER_LINES_ALL.ATO_LINE_ID%TYPE;
2364: l_process_set PROCESS_SET;
2365: l_Stmt_no Number ;
2366: i Number;
2367: l_item_type_code OE_ORDER_LINES_ALL.item_type_code%type ; /* BUG#1874380 */

Line 2367: l_item_type_code OE_ORDER_LINES_ALL.item_type_code%type ; /* BUG#1874380 */

2363: l_ato_line_id OE_ORDER_LINES_ALL.ATO_LINE_ID%TYPE;
2364: l_process_set PROCESS_SET;
2365: l_Stmt_no Number ;
2366: i Number;
2367: l_item_type_code OE_ORDER_LINES_ALL.item_type_code%type ; /* BUG#1874380 */
2368:
2369: BEGIN
2370:
2371: l_Stmt_no := 10;

Line 2386: FROM OE_ORDER_LINES_ALL

2382: SELECT Ato_line_id ,
2383: item_type_code /* BUG#1874380 */
2384: INTO l_ato_line_iD,
2385: l_item_type_code /* BUG#1874380 */
2386: FROM OE_ORDER_LINES_ALL
2387: WHERE line_id = Pchgtype(i).old_value;
2388:
2389: IF PG_DEBUG <> 0 THEN
2390: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'The line_id = '||Pchgtype(i).old_value||' ATO line id ='||l_ato_line_id,3);