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 584: from oe_order_lines_all ol

580: select nvl(costing_group_id,1)
581: into l_cst_grp
582: from pjm_project_parameters ppp
583: where ppp.project_id = ( select project_id
584: from oe_order_lines_all ol
585: where ol.line_id = pLineId )
586: and ppp.organization_id = pOrgId;
587:
588: return(l_cst_grp);

Line 690: oe_order_lines_all oel,

686:
687: select wip_entity_id
688: into lWipEntityId
689: from wip_flow_schedules wfs,
690: oe_order_lines_all oel,
691: oe_order_headers_all oeh,
692: oe_transaction_types_all ota,
693: oe_transaction_types_tl otl,
694: mtl_sales_orders mso

Line 749: oe_order_lines_all oel,

745:
746: select reservation_id
747: into lReserveId
748: from mtl_reservations mr,
749: oe_order_lines_all oel,
750: oe_order_headers_all oeh,
751: oe_transaction_types_all ota,
752: oe_transaction_types_tl otl,
753: mtl_sales_orders mso

Line 861: oe_order_lines_all oel,

857:
858: CURSOR reservations IS
859: select distinct reservation_id
860: from mtl_reservations mr,
861: oe_order_lines_all oel,
862: oe_order_headers_all oeh,
863: oe_transaction_types_all ota,
864: oe_transaction_types_tl otl,
865: mtl_sales_orders mso

Line 887: from oe_order_lines_all

883: --Begin Bugfix 1997355
884:
885: CURSOR delink_lines IS
886: select line_id
887: from oe_order_lines_all
888: where ato_line_id = pModelLineId;
889:
890: --End Bugfix 1997355
891:

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

888: where ato_line_id = pModelLineId;
889:
890: --End Bugfix 1997355
891:
892: v_source_type_code oe_order_lines_all.source_type_code%type ; /* BUG#2234858 */
893:
894: -- Added by Renga Kannan on 05/13/02
895: -- for bug fix 2366241
896:

Line 897: l_header_id oe_order_lines_all.header_id%type;

893:
894: -- Added by Renga Kannan on 05/13/02
895: -- for bug fix 2366241
896:
897: l_header_id oe_order_lines_all.header_id%type;
898:
899: v_aps_version number := 0;
900:
901:

Line 921: from oe_order_lines_all

917: -- needs to be retrieved to distinguish between drop shipped orders(external)
918: -- and regular orders( internal )
919:
920: select source_type_code into v_source_type_code
921: from oe_order_lines_all
922: where line_id = pModelLineId ;
923:
924:
925:

Line 934: from oe_order_lines_all oel

930: -- Cancelled lines.
931:
932: select line_id, ship_from_org_id,header_id
933: into lConfigLineId, lOrgId,l_header_id
934: from oe_order_lines_all oel
935: where ato_line_id = pModelLineId
936: and inventory_item_id = pConfigid
937: and item_type_code = 'CONFIG';
938:

Line 993: from oe_order_lines_all oel,

989: oeh.header_id
990: into lSalesOrderId, --header id fro rsv api
991: lOrgId, --ship from org id
992: lHeaderId -- header id in oeh, for wip api
993: from oe_order_lines_all oel,
994: oe_order_headers_all oeh,
995: oe_transaction_types_tl oet,
996: mtl_sales_orders mso,
997: mtl_system_items msi

Line 1286: FROM OE_ORDER_LINES_ALL

1282: Getting the activity status code
1283: +-----------------------------------------*/
1284: SELECT nvl(cancelled_flag,'N')
1285: INTO lcancel_flag --- Reusing the variable
1286: FROM OE_ORDER_LINES_ALL
1287: WHERE line_id = pModelLineId;
1288:
1289: lStmtNumber := 520;
1290:

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

1425: lStmtNumber := 533;
1426:
1427: --- Added by Renga Kannan on 02/02/2001
1428: --- We have decided not to call process order API to change
1429: --- Flag setting. Instead we will update the flags in OE_ORDER_LINES_ALL
1430: --- directly. This decision is taken during change order project.
1431: --- Updating OE_ORDE_LINES_ALL directly instead of calling Process order
1432: --- API was recommended by Rajeev Bellamkonda from OM team. Date 02/02/2001
1433:

Line 1447: UPDATE OE_ORDER_LINES_ALL

1443: -- We should not update visible demand flag to 'Y' for
1444: -- unscheduled orders. Added a condition to check
1445: -- if the line is scheduled or not
1446:
1447: UPDATE OE_ORDER_LINES_ALL
1448: SET visible_demand_flag = 'Y'
1449: WHERE ato_line_id = pModelLineId
1450: and header_id = l_header_id
1451: and open_flag = 'Y'

Line 1569: OE_ORDER_LINES_ALL B

1565: lStmtNumber := 600;
1566: SELECT Order_number
1567: INTO l_order_number
1568: FROM OE_ORDER_HEADERS_ALL A,
1569: OE_ORDER_LINES_ALL B
1570: WHERE B.line_id = pModelLineId
1571: AND A.Header_id = B.Header_Id;
1572:
1573: IF PG_DEBUG <> 0 THEN

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

1629: END LOOP;
1630:
1631:
1632:
1633: /* Since oe_config_util.delink_config deleted lConfigLineId from oe_order_lines_all before
1634: opening delink_lines cursor , lConfigLineId needs to be passed explicitely */
1635:
1636: p_config_line_arr_delink(index_counter_delink) := lConfigLineId;
1637: CLOSE delink_lines;

Line 1768: pReqDate in oe_order_lines_all.schedule_ship_date%type,

1764:
1765:
1766: function load_mandatory_comps(
1767: pLineId in number,
1768: pReqDate in oe_order_lines_all.schedule_ship_date%type,
1769: xGrpId out NOCOPY number,
1770: xErrorMessage out NOCOPY varchar2 ,
1771: xMessageName out NOCOPY varchar2 ,
1772: xTableName out NOCOPY varchar2 )

Line 1851: from mtl_system_items msi , oe_order_lines_all oel

1847: /* Bugfix 2047428 */
1848: lStmtNumber := 599;
1849: select NVL(msi.atp_components_flag,'N')
1850: into latpcompflag
1851: from mtl_system_items msi , oe_order_lines_all oel
1852: where oel.inventory_item_id = msi.inventory_item_id
1853: and oel.ship_from_org_id = msi.organization_id
1854: and oel.line_id = pLineId
1855: and oel.ordered_quantity > 0;

Line 1912: oe_order_lines_all oel,

1908: oel.inventory_item_id,
1909: oel.Line_Id,
1910: xGrpId
1911: from
1912: oe_order_lines_all oel,
1913: mtl_system_items msi
1914: where oel.line_id = pLineId
1915: and oel.inventory_item_id = msi.inventory_item_id
1916: and oel.ship_from_org_id = msi.organization_id

Line 1980: oe_order_lines_all oel,

1976: bet.top_item_id,
1977: oel.line_id,
1978: xGrpId
1979: from
1980: oe_order_lines_all oel,
1981: bom_explosion_temp bet,
1982: mtl_system_items msi
1983: where oel.ato_line_id = pLineId
1984: and oel.line_id <> pLineId

Line 2019: oe_order_lines_all oel,

2015: bet.top_item_id,
2016: oel.line_id,
2017: xGrpId
2018: from
2019: oe_order_lines_all oel,
2020: bom_explosion_temp bet,
2021: mtl_system_items msi,
2022: bom_bill_of_materials bbm,
2023: bom_inventory_components bic

Line 2311: pReqDate in oe_order_lines_all.schedule_ship_date%type,

2307:
2308: -- 3779636
2309: function load_mandatory_comps_pds(
2310: pLineId in number,
2311: pReqDate in oe_order_lines_all.schedule_ship_date%type,
2312: xGrpId out NOCOPY number,
2313: xErrorMessage out NOCOPY varchar2 ,
2314: xMessageName out NOCOPY varchar2 ,
2315: xTableName out NOCOPY varchar2 )

Line 2360: from mtl_system_items msi , oe_order_lines_all oel

2356:
2357: lStmtNumber := 599;
2358: select NVL(msi.atp_components_flag,'N')
2359: into latpcompflag
2360: from mtl_system_items msi , oe_order_lines_all oel
2361: where oel.inventory_item_id = msi.inventory_item_id
2362: and oel.ship_from_org_id = msi.organization_id
2363: and oel.line_id = pLineId
2364: and oel.ordered_quantity > 0;

Line 2410: oe_order_lines_all oel,

2406: oel.inventory_item_id,
2407: oel.Line_Id,
2408: xGrpId
2409: from
2410: oe_order_lines_all oel,
2411: mtl_system_items msi
2412: where oel.line_id = pLineId
2413: and oel.inventory_item_id = msi.inventory_item_id
2414: and oel.ship_from_org_id = msi.organization_id

Line 2469: oe_order_lines_all oel,

2465: bet.top_item_id,
2466: oel.line_id,
2467: xGrpId
2468: from
2469: oe_order_lines_all oel,
2470: bom_explosion_temp bet,
2471: mtl_system_items msi
2472: where oel.ato_line_id = pLineId
2473: and oel.line_id <> pLineId

Line 2730: pReqDate in oe_order_lines_all.schedule_ship_date%type,

2726:
2727: function load_mandatory_components(
2728: p_ship_set in MRP_ATP_PUB.ATP_Rec_Typ,
2729: p_model_index in number,
2730: pReqDate in oe_order_lines_all.schedule_ship_date%type,
2731: xGrpId out NOCOPY number,
2732: xErrorMessage out NOCOPY varchar2 ,
2733: xMessageName out NOCOPY varchar2 ,
2734: xTableName out NOCOPY varchar2 )

Line 3240: pReqDate in oe_order_lines_all.schedule_ship_date%type,

3236: -- 3779636
3237: function load_mandatory_components_pds(
3238: p_ship_set in MRP_ATP_PUB.ATP_Rec_Typ,
3239: p_model_index in number,
3240: pReqDate in oe_order_lines_all.schedule_ship_date%type,
3241: xGrpId out NOCOPY number,
3242: xErrorMessage out NOCOPY varchar2 ,
3243: xMessageName out NOCOPY varchar2 ,
3244: xTableName out NOCOPY varchar2 )

Line 4187: from oe_order_lines_all oel,

4183: BUG:3484511
4184: ------------------------
4185: select nvl(master_organization_id,-99) -- bugfix 2646849: master_organization_id can be 0
4186: into lValidationOrg
4187: from oe_order_lines_all oel,
4188: oe_system_parameters_all ospa
4189: where oel.line_id = pLineid
4190: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) --bug 1531691
4191: and oel.inventory_item_id = pModelId;

Line 4202: into lValidationOrg from oe_order_lines_all oel

4198: END IF;
4199:
4200:
4201: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
4202: into lValidationOrg from oe_order_lines_all oel
4203: where oel.line_id = pLineId ;
4204:
4205:
4206: end if ;

Line 4398: from oe_order_lines_all oel,

4394: into lOrderNum,
4395: lLineNum,
4396: lDeliveryNum,
4397: lOptionNum -- 2652379 : new variable
4398: from oe_order_lines_all oel,
4399: oe_order_headers_all oeh
4400: where oel.line_id = pLineId
4401: and oel.header_id = oeh.header_id;
4402:

Line 6148: from oe_order_lines_all oel,

6144: -------------
6145:
6146: select nvl(master_organization_id, -99) --bugfix 2646849: added nvl.
6147: into lValidationOrg
6148: from oe_order_lines_all oel,
6149: oe_system_parameters_all ospa
6150: where oel.line_id = pLineid
6151: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) --bug 1531691
6152: and oel.inventory_item_id = pModelId;

Line 6162: into lValidationOrg from oe_order_lines_all oel

6158: END IF;
6159:
6160:
6161: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
6162: into lValidationOrg from oe_order_lines_all oel
6163: where oel.line_id = pLineId ;
6164:
6165:
6166: end if ;

Line 8151: l_header_id oe_order_lines_all.header_id%type;

8147: x number;
8148: y varchar(1);
8149: z varchar(30);
8150: l_vdflag varchar(1);
8151: l_header_id oe_order_lines_all.header_id%type;
8152:
8153: --
8154: --bugfix 2840801
8155: --

Line 8162: v_schedule_status_code oe_order_lines_all.schedule_status_code%type ;

8158: l_x_error_msg_count Number;
8159: l_x_error_msg Varchar2(2000);
8160: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
8161:
8162: v_schedule_status_code oe_order_lines_all.schedule_status_code%type ;
8163: v_booked_flag oe_order_lines_all.booked_flag%type ;
8164: v_hold_id number ;
8165:
8166: BEGIN

Line 8163: v_booked_flag oe_order_lines_all.booked_flag%type ;

8159: l_x_error_msg Varchar2(2000);
8160: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
8161:
8162: v_schedule_status_code oe_order_lines_all.schedule_status_code%type ;
8163: v_booked_flag oe_order_lines_all.booked_flag%type ;
8164: v_hold_id number ;
8165:
8166: BEGIN
8167:

Line 8234: UPDATE OE_ORDER_LINES_ALL

8230:
8231: oe_debug_pub.add('link_item: ' || ' ATO line id = '||to_char(plineid),1);
8232: END IF;
8233:
8234: UPDATE OE_ORDER_LINES_ALL
8235: SET visible_demand_flag = 'N'
8236: WHERE ato_line_id = pLineId;
8237:
8238: IF PG_DEBUG <> 0 THEN

Line 8344: from oe_order_lines_all oel

8340: select nvl(component_code, oel.inventory_item_id) || '-'|| to_char(pConfigId),
8341: substrb(user_item_Description,1,240)
8342: into l_model_tab(1).component_code,
8343: l_model_tab(1).user_item_description
8344: from oe_order_lines_all oel
8345: where oel.line_id = pLineId
8346: and oel.ship_from_org_id = pOrgId;
8347: */
8348: -- bugfix 2503104: Revert this fix as OM will now populate

Line 8354: from oe_order_lines_all oel

8350: -- any compile time dependency between OM and CTO for this issue.
8351:
8352: select nvl(component_code, oel.inventory_item_id) || '-'|| to_char(pConfigId)
8353: into l_model_tab(1).component_code
8354: from oe_order_lines_all oel
8355: where oel.line_id = pLineId
8356: and oel.ship_from_org_id = pOrgId;
8357:
8358: lStmtNumber := 410;

Line 8485: from oe_order_lines_all

8481: sysdate,
8482: gLoginId,
8483: null,
8484: sysdate
8485: from oe_order_lines_all
8486: where ato_line_id=pLineId
8487: and inventory_item_id=pConfigId;
8488:
8489: */

Line 8514: from oe_order_lines_all oel

8510:
8511: lStmtNumber := 450;
8512: select line_id, header_id -- bugfix 2840801 : added header_id
8513: into l_config_line_id, l_header_id
8514: from oe_order_lines_all oel
8515: where ato_line_id = pLineId
8516: and inventory_item_id = pConfigId
8517: and item_type_code = 'CONFIG';
8518:

Line 8593: from oe_order_lines_all

8589:
8590:
8591:
8592: select schedule_status_code , booked_flag into v_schedule_Status_code , v_booked_flag
8593: from oe_order_lines_all
8594: where line_id = pLineId ;
8595:
8596:
8597: