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_ALL

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 590: FROM OE_ORDER_LINES_ALL

586: lheader_id,
587: lorg_id,
588: l_source_type_code,
589: l_shipping_xfaced_flag -- Bug Fix: 4863275
590: FROM OE_ORDER_LINES_ALL
591: WHERE line_id = ato_line_id
592: --Adding item_type_code = 'INCLUDED' for Sun ER#9793792.
593: AND ( item_type_code = 'STANDARD' OR item_type_code = 'OPTION' OR item_type_code = 'INCLUDED')
594: AND line_id = pLineid;

Line 645: FROM oe_order_lines_all

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

Line 1278: oe_order_lines_all oel,

1274: SELECT reservation_id
1275: INTO l_reservation_id
1276: FROM
1277: mtl_reservations mr,
1278: oe_order_lines_all oel,
1279: oe_order_headers_all oeh,
1280: oe_transaction_types_all ota,
1281: oe_transaction_types_tl otl,
1282: mtl_sales_orders mso

Line 1359: linv_item_id oe_order_lines_all.inventory_item_id%type;

1355:
1356: lcust_line_no varchar2(50);
1357: lnotify_person varchar2(200);
1358: i binary_integer;
1359: linv_item_id oe_order_lines_all.inventory_item_id%type;
1360: lplanner_code fnd_user.user_name%type; -- Modified by Renga on
1361: --11/24/04 for bug 4026568
1362: lship_org_id oe_order_lines_all.ship_from_org_id%type;
1363: ldummy varchar2(1);

Line 1362: lship_org_id oe_order_lines_all.ship_from_org_id%type;

1358: i binary_integer;
1359: linv_item_id oe_order_lines_all.inventory_item_id%type;
1360: lplanner_code fnd_user.user_name%type; -- Modified by Renga on
1361: --11/24/04 for bug 4026568
1362: lship_org_id oe_order_lines_all.ship_from_org_id%type;
1363: ldummy varchar2(1);
1364: lstmt number;
1365: --- Added by Renga Kannan on 03/23/2001 to implement the new bulk attribute setting calls for wf_engine
1366: l_aname wf_engine.nametabtyp;

Line 1372: l_header_id oe_order_lines_all.header_id%type;

1368: l_atxtvalue wf_engine.texttabtyp;
1369: -- End of additions.
1370:
1371: l_cancel_flag varchar2(1) := 'N';
1372: l_header_id oe_order_lines_all.header_id%type;
1373:
1374: l_mlsupply_items CTO_SUBASSEMBLY_SUP_PK.t_item_details;
1375: l_items VARCHAR2(4000);
1376: l_mlsupply_parameter number;

Line 1404: l_ord_uom2 oe_order_lines_all.ORDERED_QUANTITY_UOM2%type;

1400:
1401: --for OPM project :kkonada
1402: lord_qty2 number; --ordered qty in secondary uom
1403: l_old_ord_qty2 number;
1404: l_ord_uom2 oe_order_lines_all.ORDERED_QUANTITY_UOM2%type;
1405: l_old_ord_uom2 oe_order_lines_all.ordered_quantity_uom2%type;
1406: l_old_ord_qty number;
1407: l_ord_uom oe_order_lines_all.order_quantity_uom%type;
1408: l_old_ord_uom oe_order_lines_all.order_quantity_uom%type;

Line 1405: l_old_ord_uom2 oe_order_lines_all.ordered_quantity_uom2%type;

1401: --for OPM project :kkonada
1402: lord_qty2 number; --ordered qty in secondary uom
1403: l_old_ord_qty2 number;
1404: l_ord_uom2 oe_order_lines_all.ORDERED_QUANTITY_UOM2%type;
1405: l_old_ord_uom2 oe_order_lines_all.ordered_quantity_uom2%type;
1406: l_old_ord_qty number;
1407: l_ord_uom oe_order_lines_all.order_quantity_uom%type;
1408: l_old_ord_uom oe_order_lines_all.order_quantity_uom%type;
1409: l_qty_set varchar2(1) := 'N';

Line 1407: l_ord_uom oe_order_lines_all.order_quantity_uom%type;

1403: l_old_ord_qty2 number;
1404: l_ord_uom2 oe_order_lines_all.ORDERED_QUANTITY_UOM2%type;
1405: l_old_ord_uom2 oe_order_lines_all.ordered_quantity_uom2%type;
1406: l_old_ord_qty number;
1407: l_ord_uom oe_order_lines_all.order_quantity_uom%type;
1408: l_old_ord_uom oe_order_lines_all.order_quantity_uom%type;
1409: l_qty_set varchar2(1) := 'N';
1410: l_qty2_set varchar2(1) := 'N';
1411:

Line 1408: l_old_ord_uom oe_order_lines_all.order_quantity_uom%type;

1404: l_ord_uom2 oe_order_lines_all.ORDERED_QUANTITY_UOM2%type;
1405: l_old_ord_uom2 oe_order_lines_all.ordered_quantity_uom2%type;
1406: l_old_ord_qty number;
1407: l_ord_uom oe_order_lines_all.order_quantity_uom%type;
1408: l_old_ord_uom oe_order_lines_all.order_quantity_uom%type;
1409: l_qty_set varchar2(1) := 'N';
1410: l_qty2_set varchar2(1) := 'N';
1411:
1412: -- bug 7447357.pdube Mon Oct 20 04:03:59 PDT 2008

Line 1446: oe_order_lines_all oel,

1442: CURSOR get_buyer_from_po(config_line_id IN NUMBER) IS
1443: select u.user_name
1444: from mtl_reservations mr,
1445: po_headers_all poh,
1446: oe_order_lines_all oel,
1447: fnd_user u
1448: where oel.line_id = config_line_id and
1449: mr.demand_source_type_id in (8,2) and
1450: mr.demand_source_line_id = oel.line_id and

Line 1464: oe_order_lines_all oel,

1460: select u.user_name
1461: from mtl_reservations mr,
1462: po_requisition_headers_all porh,
1463: po_requisition_lines_all porl,
1464: oe_order_lines_all oel,
1465: fnd_user u
1466: where oel.line_id = config_line_id and
1467: mr.demand_source_type_id in (8,2) and
1468: mr.demand_source_line_id = oel.line_id and

Line 1484: from oe_order_lines_all

1480: -- Fetching the config line id using ato line id
1481: --
1482: CURSOR get_config_line_id(p_header_id IN NUMBER, l_ato_line_id IN NUMBER) IS
1483: select line_id
1484: from oe_order_lines_all
1485: where inventory_item_id = pconfig_id and
1486: header_id = p_header_id and
1487: ato_line_id = l_ato_line_id;
1488:

Line 1501: oe_order_lines_all oel

1497: wip_discrete_jobs wdj,
1498: wip_entities we,
1499: mfg_lookups mlk,
1500: mfg_lookups mlk2,
1501: oe_order_lines_all oel
1502: WHERE oel.line_id = p_line_id
1503: AND demand_source_type_id = DECODE(CTO_WORKBENCH_UTIL_PK.get_source_document_id(p_line_id), 10,8,2)
1504: AND oel.line_id = mr.demand_source_line_id
1505: AND mr.supply_source_type_id = 5

Line 1518: oe_order_lines_all oel,

1514: SELECT mlk2.meaning supply_type,
1515: wfs.schedule_number job_number,
1516: NULL line_number
1517: FROM wip_flow_schedules wfs,
1518: oe_order_lines_all oel,
1519: mtl_system_items msi,
1520: mfg_lookups mlk,
1521: mfg_lookups mlk2
1522: WHERE wfs.demand_source_line = p_line_id

Line 1539: oe_order_lines_all oel,

1535: FROM mtl_reservations mr,
1536: po_headers_all poh,
1537: po_lines_all pol,
1538: po_line_locations_all poll,
1539: oe_order_lines_all oel,
1540: mtl_units_of_measure uom,
1541: mfg_lookups mlk2
1542: WHERE mr.demand_source_type_id IN(8,2)
1543: AND mr.demand_source_line_id = oel.line_id

Line 1560: oe_order_lines_all oel,

1556: porl.line_num line_number
1557: FROM mtl_reservations mr,
1558: po_requisition_headers_all porh,
1559: po_requisition_lines_all porl,
1560: oe_order_lines_all oel,
1561: mtl_units_of_measure uom,
1562: mfg_lookups mlk2
1563: WHERE oel.line_id = p_line_id
1564: AND mr.demand_source_type_id IN (8,2)

Line 1581: oe_order_lines_all oel,

1577: FROM oe_drop_ship_sources ods,
1578: po_headers_all poh,
1579: po_line_locations_all poll,
1580: po_lines_all pol,
1581: oe_order_lines_all oel,
1582: mtl_units_of_measure uom,
1583: mfg_lookups mlk2
1584: WHERE oel.line_id = p_line_id
1585: AND ods.line_id = oel.line_id

Line 1600: oe_order_lines_all oel,

1596: porl.line_num line_number
1597: FROM oe_drop_ship_sources ods,
1598: po_requisition_headers_all porh,
1599: po_requisition_lines_all porl,
1600: oe_order_lines_all oel,
1601: mtl_units_of_measure uom,
1602: mfg_lookups mlk2
1603: WHERE oel.line_id = p_line_id
1604: AND ods.line_id = oel.line_id

Line 1617: oe_order_lines_all oel,

1613: SELECT mlk2.meaning supply_type,
1614: asn_headers.shipment_num job_number,
1615: NULL line_number
1616: FROM mtl_reservations mr,
1617: oe_order_lines_all oel,
1618: mtl_units_of_measure uom,
1619: mfg_lookups mlk2,
1620: rcv_shipment_lines ASN_LINES,
1621: rcv_shipment_headers ASN_HEADERS

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

1651: litem_key := to_char(pline_no)||to_char(sysdate,'mmddyyhhmiss');
1652: luser_key := litem_key;
1653:
1654: --
1655: -- Get the information from OE_ORDER_LINES_ALL table for the Model line
1656: --
1657:
1658: lstmt := 20;
1659: IF PG_DEBUG <> 0 THEN

Line 1692: oe_order_lines_all

1688: l_ord_uom2, --ORDERED_QUANTITY_UOM2 for OPM proj
1689: l_ord_uom, --order_quantity_uom for OPM proj
1690: l_ato_line_id -- bug 14209094
1691: FROM
1692: oe_order_lines_all
1693: WHERE
1694: line_id = pline_no;
1695:
1696: --OPM. Defaulting the primary and secondry uom and qty

Line 2016: from oe_order_lines_all oel

2012:
2013:
2014: select oel.line_number || '.' || oel.shipment_number || '.' || nvl( oel.option_number , '' ) , ordered_quantity
2015: into v_model_line_num , v_split_qty
2016: from oe_order_lines_all oel
2017: where line_id = v_split_line_id ;
2018:
2019: /*
2020: select ordered_quantity into v_split_qty from bom_cto_order_lines

Line 2600: l_ato_line_id OE_ORDER_LINES_ALL.ATO_LINE_ID%TYPE;

2596: X_Msg_data OUT NOCOPY Varchar2) IS
2597:
2598: TYPE PROCESS_SET IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;
2599: l_chgtype CTO_CHANGE_ORDER_PK.change_table_type;
2600: l_ato_line_id OE_ORDER_LINES_ALL.ATO_LINE_ID%TYPE;
2601: l_process_set PROCESS_SET;
2602: l_Stmt_no Number ;
2603: i Number;
2604: l_item_type_code OE_ORDER_LINES_ALL.item_type_code%type ; /* BUG#1874380 */

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

2600: l_ato_line_id OE_ORDER_LINES_ALL.ATO_LINE_ID%TYPE;
2601: l_process_set PROCESS_SET;
2602: l_Stmt_no Number ;
2603: i Number;
2604: l_item_type_code OE_ORDER_LINES_ALL.item_type_code%type ; /* BUG#1874380 */
2605:
2606: BEGIN
2607:
2608: l_Stmt_no := 10;

Line 2623: FROM OE_ORDER_LINES_ALL

2619: SELECT Ato_line_id ,
2620: item_type_code /* BUG#1874380 */
2621: INTO l_ato_line_iD,
2622: l_item_type_code /* BUG#1874380 */
2623: FROM OE_ORDER_LINES_ALL
2624: WHERE line_id = Pchgtype(i).old_value;
2625:
2626: IF PG_DEBUG <> 0 THEN
2627: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'The line_id = '||Pchgtype(i).old_value||' ATO line id ='||l_ato_line_id,3);

Line 3277: linv_item_id oe_order_lines_all.inventory_item_id%type;

3273: return fnd_user.user_name%type
3274: IS
3275:
3276: lStmtNumber number;
3277: linv_item_id oe_order_lines_all.inventory_item_id%type;
3278: lship_org_id oe_order_lines_all.ship_from_org_id%type;
3279: l_header_id oe_order_lines_all.header_id%type;
3280:
3281:

Line 3278: lship_org_id oe_order_lines_all.ship_from_org_id%type;

3274: IS
3275:
3276: lStmtNumber number;
3277: linv_item_id oe_order_lines_all.inventory_item_id%type;
3278: lship_org_id oe_order_lines_all.ship_from_org_id%type;
3279: l_header_id oe_order_lines_all.header_id%type;
3280:
3281:
3282: l_config_line_id number;

Line 3279: l_header_id oe_order_lines_all.header_id%type;

3275:
3276: lStmtNumber number;
3277: linv_item_id oe_order_lines_all.inventory_item_id%type;
3278: lship_org_id oe_order_lines_all.ship_from_org_id%type;
3279: l_header_id oe_order_lines_all.header_id%type;
3280:
3281:
3282: l_config_line_id number;
3283: lplanner_code fnd_user.user_name%type;

Line 3290: oe_order_lines_all oel,

3286: CURSOR get_buyer_from_po(config_line_id IN NUMBER) IS
3287: select u.user_name
3288: from mtl_reservations mr,
3289: po_headers_all poh,
3290: oe_order_lines_all oel,
3291: fnd_user u
3292: where oel.line_id = config_line_id and
3293: mr.demand_source_type_id in (8,2) and
3294: mr.demand_source_line_id = oel.line_id and

Line 3306: oe_order_lines_all oel,

3302: select u.user_name
3303: from mtl_reservations mr,
3304: po_requisition_headers_all porh,
3305: po_requisition_lines_all porl,
3306: oe_order_lines_all oel,
3307: fnd_user u
3308: where oel.line_id = config_line_id and
3309: mr.demand_source_type_id in (8,2) and
3310: mr.demand_source_line_id = oel.line_id and

Line 3342: oe_order_lines_all

3338: linv_item_id,
3339: lship_org_id,
3340: l_header_id
3341: FROM
3342: oe_order_lines_all
3343: WHERE
3344: line_id = pline_no;
3345:
3346: IF PG_DEBUG <> 0 THEN