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_CONFIG_ITEM_PK dependencies on OE_ORDER_LINES_ALL

Line 659: from oe_order_lines_all ol

655: select nvl(costing_group_id,1)
656: into l_cst_grp
657: from pjm_project_parameters ppp
658: where ppp.project_id = ( select project_id
659: from oe_order_lines_all ol
660: where ol.line_id = pLineId )
661: and ppp.organization_id = pOrgId;
662:
663: return(l_cst_grp);

Line 765: oe_order_lines_all oel,

761:
762: select wip_entity_id
763: into lWipEntityId
764: from wip_flow_schedules wfs,
765: oe_order_lines_all oel,
766: oe_order_headers_all oeh,
767: oe_transaction_types_all ota,
768: oe_transaction_types_tl otl,
769: mtl_sales_orders mso

Line 824: oe_order_lines_all oel,

820:
821: select reservation_id
822: into lReserveId
823: from mtl_reservations mr,
824: oe_order_lines_all oel,
825: oe_order_headers_all oeh,
826: oe_transaction_types_all ota,
827: oe_transaction_types_tl otl,
828: mtl_sales_orders mso

Line 936: oe_order_lines_all oel,

932:
933: CURSOR reservations IS
934: select distinct reservation_id
935: from mtl_reservations mr,
936: oe_order_lines_all oel,
937: oe_order_headers_all oeh,
938: oe_transaction_types_all ota,
939: oe_transaction_types_tl otl,
940: mtl_sales_orders mso

Line 962: from oe_order_lines_all

958: --Begin Bugfix 1997355
959:
960: CURSOR delink_lines IS
961: select line_id
962: from oe_order_lines_all
963: where ato_line_id = pModelLineId;
964:
965: --End Bugfix 1997355
966:

Line 967: v_source_type_code oe_order_lines_all.source_type_code%type ; /* BUG#2234858 */

963: where ato_line_id = pModelLineId;
964:
965: --End Bugfix 1997355
966:
967: v_source_type_code oe_order_lines_all.source_type_code%type ; /* BUG#2234858 */
968:
969: -- Added by Renga Kannan on 05/13/02
970: -- for bug fix 2366241
971:

Line 972: l_header_id oe_order_lines_all.header_id%type;

968:
969: -- Added by Renga Kannan on 05/13/02
970: -- for bug fix 2366241
971:
972: l_header_id oe_order_lines_all.header_id%type;
973:
974: v_aps_version number := 0;
975:
976:

Line 1000: from oe_order_lines_all

996: -- needs to be retrieved to distinguish between drop shipped orders(external)
997: -- and regular orders( internal )
998:
999: select source_type_code into v_source_type_code
1000: from oe_order_lines_all
1001: where line_id = pModelLineId ;
1002:
1003:
1004:

Line 1013: from oe_order_lines_all oel

1009: -- Cancelled lines.
1010:
1011: select line_id, ship_from_org_id,header_id
1012: into lConfigLineId, lOrgId,l_header_id
1013: from oe_order_lines_all oel
1014: where ato_line_id = pModelLineId
1015: and inventory_item_id = pConfigid
1016: and item_type_code = 'CONFIG';
1017:

Line 1072: from oe_order_lines_all oel,

1068: oeh.header_id
1069: into lSalesOrderId, --header id fro rsv api
1070: lOrgId, --ship from org id
1071: lHeaderId -- header id in oeh, for wip api
1072: from oe_order_lines_all oel,
1073: oe_order_headers_all oeh,
1074: oe_transaction_types_tl oet,
1075: mtl_sales_orders mso,
1076: mtl_system_items msi

Line 1365: FROM OE_ORDER_LINES_ALL

1361: Getting the activity status code
1362: +-----------------------------------------*/
1363: SELECT nvl(cancelled_flag,'N')
1364: INTO lcancel_flag --- Reusing the variable
1365: FROM OE_ORDER_LINES_ALL
1366: WHERE line_id = pModelLineId;
1367:
1368: lStmtNumber := 520;
1369:

Line 1508: --- Flag setting. Instead we will update the flags in OE_ORDER_LINES_ALL

1504: lStmtNumber := 533;
1505:
1506: --- Added by Renga Kannan on 02/02/2001
1507: --- We have decided not to call process order API to change
1508: --- Flag setting. Instead we will update the flags in OE_ORDER_LINES_ALL
1509: --- directly. This decision is taken during change order project.
1510: --- Updating OE_ORDE_LINES_ALL directly instead of calling Process order
1511: --- API was recommended by Rajeev Bellamkonda from OM team. Date 02/02/2001
1512:

Line 1538: UPDATE OE_ORDER_LINES_ALL

1534: oe_debug_pub.add('delink_item: Value of the profile ONT_BYPASS_ATP :' ||l_bypassatp_profile_value ,3);
1535: END IF;
1536:
1537: IF (NVL(l_bypassatp_profile_value,'N') <> 'Y') THEN
1538: UPDATE OE_ORDER_LINES_ALL
1539: SET visible_demand_flag = 'Y'
1540: WHERE ato_line_id = pModelLineId
1541: and header_id = l_header_id
1542: and open_flag = 'Y'

Line 1661: OE_ORDER_LINES_ALL B

1657: lStmtNumber := 600;
1658: SELECT Order_number
1659: INTO l_order_number
1660: FROM OE_ORDER_HEADERS_ALL A,
1661: OE_ORDER_LINES_ALL B
1662: WHERE B.line_id = pModelLineId
1663: AND A.Header_id = B.Header_Id;
1664:
1665: IF PG_DEBUG <> 0 THEN

Line 1726: /* Since oe_config_util.delink_config deleted lConfigLineId from oe_order_lines_all before

1722: END LOOP;
1723:
1724:
1725:
1726: /* Since oe_config_util.delink_config deleted lConfigLineId from oe_order_lines_all before
1727: opening delink_lines cursor , lConfigLineId needs to be passed explicitely */
1728:
1729: p_config_line_arr_delink(index_counter_delink) := lConfigLineId;
1730: CLOSE delink_lines;

Line 1861: pReqDate in oe_order_lines_all.schedule_ship_date%type,

1857:
1858:
1859: function load_mandatory_comps(
1860: pLineId in number,
1861: pReqDate in oe_order_lines_all.schedule_ship_date%type,
1862: xGrpId out NOCOPY number,
1863: xErrorMessage out NOCOPY varchar2 ,
1864: xMessageName out NOCOPY varchar2 ,
1865: xTableName out NOCOPY varchar2 )

Line 1944: from mtl_system_items msi , oe_order_lines_all oel

1940: /* Bugfix 2047428 */
1941: lStmtNumber := 599;
1942: select NVL(msi.atp_components_flag,'N')
1943: into latpcompflag
1944: from mtl_system_items msi , oe_order_lines_all oel
1945: where oel.inventory_item_id = msi.inventory_item_id
1946: and oel.ship_from_org_id = msi.organization_id
1947: and oel.line_id = pLineId
1948: and oel.ordered_quantity > 0;

Line 2005: oe_order_lines_all oel,

2001: oel.inventory_item_id,
2002: oel.Line_Id,
2003: xGrpId
2004: from
2005: oe_order_lines_all oel,
2006: mtl_system_items msi
2007: where oel.line_id = pLineId
2008: and oel.inventory_item_id = msi.inventory_item_id
2009: and oel.ship_from_org_id = msi.organization_id

Line 2073: oe_order_lines_all oel,

2069: bet.top_item_id,
2070: oel.line_id,
2071: xGrpId
2072: from
2073: oe_order_lines_all oel,
2074: bom_explosion_temp bet,
2075: mtl_system_items msi
2076: where oel.ato_line_id = pLineId
2077: and oel.line_id <> pLineId

Line 2112: oe_order_lines_all oel,

2108: bet.top_item_id,
2109: oel.line_id,
2110: xGrpId
2111: from
2112: oe_order_lines_all oel,
2113: bom_explosion_temp bet,
2114: mtl_system_items msi,
2115: bom_bill_of_materials bbm,
2116: bom_inventory_components bic

Line 2404: pReqDate in oe_order_lines_all.schedule_ship_date%type,

2400:
2401: -- 3779636
2402: function load_mandatory_comps_pds(
2403: pLineId in number,
2404: pReqDate in oe_order_lines_all.schedule_ship_date%type,
2405: xGrpId out NOCOPY number,
2406: xErrorMessage out NOCOPY varchar2 ,
2407: xMessageName out NOCOPY varchar2 ,
2408: xTableName out NOCOPY varchar2 )

Line 2453: from mtl_system_items msi , oe_order_lines_all oel

2449:
2450: lStmtNumber := 599;
2451: select NVL(msi.atp_components_flag,'N')
2452: into latpcompflag
2453: from mtl_system_items msi , oe_order_lines_all oel
2454: where oel.inventory_item_id = msi.inventory_item_id
2455: and oel.ship_from_org_id = msi.organization_id
2456: and oel.line_id = pLineId
2457: and oel.ordered_quantity > 0;

Line 2503: oe_order_lines_all oel,

2499: oel.inventory_item_id,
2500: oel.Line_Id,
2501: xGrpId
2502: from
2503: oe_order_lines_all oel,
2504: mtl_system_items msi
2505: where oel.line_id = pLineId
2506: and oel.inventory_item_id = msi.inventory_item_id
2507: and oel.ship_from_org_id = msi.organization_id

Line 2562: oe_order_lines_all oel,

2558: bet.top_item_id,
2559: oel.line_id,
2560: xGrpId
2561: from
2562: oe_order_lines_all oel,
2563: bom_explosion_temp bet,
2564: mtl_system_items msi
2565: where oel.ato_line_id = pLineId
2566: and oel.line_id <> pLineId

Line 2823: pReqDate in oe_order_lines_all.schedule_ship_date%type,

2819:
2820: function load_mandatory_components(
2821: p_ship_set in MRP_ATP_PUB.ATP_Rec_Typ,
2822: p_model_index in number,
2823: pReqDate in oe_order_lines_all.schedule_ship_date%type,
2824: xGrpId out NOCOPY number,
2825: xErrorMessage out NOCOPY varchar2 ,
2826: xMessageName out NOCOPY varchar2 ,
2827: xTableName out NOCOPY varchar2 )

Line 3333: pReqDate in oe_order_lines_all.schedule_ship_date%type,

3329: -- 3779636
3330: function load_mandatory_components_pds(
3331: p_ship_set in MRP_ATP_PUB.ATP_Rec_Typ,
3332: p_model_index in number,
3333: pReqDate in oe_order_lines_all.schedule_ship_date%type,
3334: xGrpId out NOCOPY number,
3335: xErrorMessage out NOCOPY varchar2 ,
3336: xMessageName out NOCOPY varchar2 ,
3337: xTableName out NOCOPY varchar2 )

Line 4282: from oe_order_lines_all oel,

4278: BUG:3484511
4279: ------------------------
4280: select nvl(master_organization_id,-99) -- bugfix 2646849: master_organization_id can be 0
4281: into lValidationOrg
4282: from oe_order_lines_all oel,
4283: oe_system_parameters_all ospa
4284: where oel.line_id = pLineid
4285: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) --bug 1531691
4286: and oel.inventory_item_id = pModelId;

Line 4297: into lValidationOrg from oe_order_lines_all oel

4293: END IF;
4294:
4295:
4296: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
4297: into lValidationOrg from oe_order_lines_all oel
4298: where oel.line_id = pLineId ;
4299:
4300:
4301: end if ;

Line 4493: from oe_order_lines_all oel,

4489: into lOrderNum,
4490: lLineNum,
4491: lDeliveryNum,
4492: lOptionNum -- 2652379 : new variable
4493: from oe_order_lines_all oel,
4494: oe_order_headers_all oeh
4495: where oel.line_id = pLineId
4496: and oel.header_id = oeh.header_id;
4497:

Line 6333: from oe_order_lines_all oel,

6329: -------------
6330:
6331: select nvl(master_organization_id, -99) --bugfix 2646849: added nvl.
6332: into lValidationOrg
6333: from oe_order_lines_all oel,
6334: oe_system_parameters_all ospa
6335: where oel.line_id = pLineid
6336: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) --bug 1531691
6337: and oel.inventory_item_id = pModelId;

Line 6347: into lValidationOrg from oe_order_lines_all oel

6343: END IF;
6344:
6345:
6346: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
6347: into lValidationOrg from oe_order_lines_all oel
6348: where oel.line_id = pLineId ;
6349:
6350:
6351: end if ;

Line 8432: l_header_id oe_order_lines_all.header_id%type;

8428: x number;
8429: y varchar(1);
8430: z varchar(30);
8431: l_vdflag varchar(1);
8432: l_header_id oe_order_lines_all.header_id%type;
8433:
8434: --
8435: --bugfix 2840801
8436: --

Line 8443: v_schedule_status_code oe_order_lines_all.schedule_status_code%type ;

8439: l_x_error_msg_count Number;
8440: l_x_error_msg Varchar2(2000);
8441: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
8442:
8443: v_schedule_status_code oe_order_lines_all.schedule_status_code%type ;
8444: v_booked_flag oe_order_lines_all.booked_flag%type ;
8445: v_hold_id number ;
8446:
8447: --

Line 8444: v_booked_flag oe_order_lines_all.booked_flag%type ;

8440: l_x_error_msg Varchar2(2000);
8441: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
8442:
8443: v_schedule_status_code oe_order_lines_all.schedule_status_code%type ;
8444: v_booked_flag oe_order_lines_all.booked_flag%type ;
8445: v_hold_id number ;
8446:
8447: --
8448: -- bug 14474393

Line 8520: UPDATE OE_ORDER_LINES_ALL

8516:
8517: oe_debug_pub.add('link_item: ' || ' ATO line id = '||to_char(plineid),1);
8518: END IF;
8519:
8520: UPDATE OE_ORDER_LINES_ALL
8521: SET visible_demand_flag = 'N'
8522: WHERE ato_line_id = pLineId;
8523:
8524: IF PG_DEBUG <> 0 THEN

Line 8645: from oe_order_lines_all oel

8641: select nvl(component_code, oel.inventory_item_id) || '-'|| to_char(pConfigId),
8642: substrb(user_item_Description,1,240)
8643: into l_model_tab(1).component_code,
8644: l_model_tab(1).user_item_description
8645: from oe_order_lines_all oel
8646: where oel.line_id = pLineId
8647: and oel.ship_from_org_id = pOrgId;
8648: */
8649: -- bugfix 2503104: Revert this fix as OM will now populate

Line 8655: from oe_order_lines_all oel

8651: -- any compile time dependency between OM and CTO for this issue.
8652:
8653: select nvl(component_code, oel.inventory_item_id) || '-'|| to_char(pConfigId)
8654: into l_model_tab(1).component_code
8655: from oe_order_lines_all oel
8656: where oel.line_id = pLineId
8657: and oel.ship_from_org_id = pOrgId;
8658:
8659: lStmtNumber := 410;

Line 8786: from oe_order_lines_all

8782: sysdate,
8783: gLoginId,
8784: null,
8785: sysdate
8786: from oe_order_lines_all
8787: where ato_line_id=pLineId
8788: and inventory_item_id=pConfigId;
8789:
8790: */

Line 8815: from oe_order_lines_all oel

8811:
8812: lStmtNumber := 450;
8813: select line_id, header_id -- bugfix 2840801 : added header_id
8814: into l_config_line_id, l_header_id
8815: from oe_order_lines_all oel
8816: where ato_line_id = pLineId
8817: and inventory_item_id = pConfigId
8818: and item_type_code = 'CONFIG';
8819:

Line 8894: from oe_order_lines_all

8890:
8891:
8892:
8893: select schedule_status_code , booked_flag into v_schedule_Status_code , v_booked_flag
8894: from oe_order_lines_all
8895: where line_id = pLineId ;
8896:
8897:
8898: