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

Line 502: v_source_type_code oe_order_lines_all.source_type_code%type ;

498: multiorg_error exception;
499: po_multiorg_error exception;
500: lProgramId bom_cto_order_lines.program_id%type ;
501:
502: v_source_type_code oe_order_lines_all.source_type_code%type ;
503:
504: CURSOR c_circular_src IS
505: select 'Y'
506: from bom_cto_src_orgs bcso

Line 604: from oe_order_lines_all

600: else
601:
602: select source_type_code
603: into v_source_type_code
604: from oe_order_lines_all
605: where line_id = pLineId ;
606:
607: IF PG_DEBUG <> 0 THEN
608: oe_debug_pub.add('populate_plan_level: ' || ' non pc bom source type code = '|| v_source_type_code ,1);

Line 1221: from oe_order_lines_all oel,

1217: Code has been replaced due to 11.5.10 OM data model change
1218: ----------------------------------------------------------
1219: select nvl(master_organization_id,-99) -- bugfix 2646849: master_organization_id can be 0
1220: into lValidationOrg
1221: from oe_order_lines_all oel,
1222: oe_system_parameters_all ospa
1223: where oel.line_id = pLineid
1224: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) --bug 1531691
1225: and oel.inventory_item_id = pModelItemId;

Line 1235: into lValidationOrg from oe_order_lines_all oel

1231: END IF;
1232:
1233:
1234: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
1235: into lValidationOrg from oe_order_lines_all oel
1236: where oel.line_id = pLineId ;
1237:
1238:
1239:

Line 2127: from oe_order_lines_all OEOL , bom_inventory_components BIC , mtl_system_items MSYI

2123: , OEOL.ordered_quantity
2124: , OEOL.order_quantity_uom
2125: , nvl( MSYI.config_orgs , 1)
2126: , MSYI.config_match
2127: from oe_order_lines_all OEOL , bom_inventory_components BIC , mtl_system_items MSYI
2128: where ato_line_id = p_bcol_line_id
2129: and OEOL.component_sequence_id = BIC.component_sequence_id
2130: and OEOL.inventory_item_id = MSYI.inventory_item_id
2131: and MSYI.organization_id = c_organization_id

Line 2174: v_inventory_item_id oe_order_lines_all.inventory_item_id%type ;

2170:
2171: gUserID number ;
2172: gLoginId number ;
2173:
2174: v_inventory_item_id oe_order_lines_all.inventory_item_id%type ;
2175: v_organization_id oe_system_parameters_all.master_organization_id%type ;
2176:
2177: v_ato_line_id NUMBER;
2178: v_request_id NUMBER;

Line 2218: from oe_order_lines_all

2214: v_step := 'Step A2' ;
2215:
2216: select inventory_item_id
2217: into v_inventory_item_id
2218: from oe_order_lines_all
2219: where ato_line_id = p_bcol_line_id
2220: and line_id = p_bcol_line_id ;
2221:
2222:

Line 2235: from oe_order_lines_all oel,

2231: BUG:3484511
2232: ---------------
2233: select master_organization_id
2234: into v_organization_id
2235: from oe_order_lines_all oel,
2236: oe_system_parameters_all ospa
2237: where oel.line_id = p_bcol_line_id
2238: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) --bug 1531691
2239: and oel.inventory_item_id = v_inventory_item_id ;

Line 2251: into v_organization_id from oe_order_lines_all oel

2247: END IF;
2248:
2249:
2250: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
2251: into v_organization_id from oe_order_lines_all oel
2252: where oel.line_id = p_bcol_line_id;
2253:
2254:
2255:

Line 2320: from oe_order_lines_all OEOL , mtl_system_items MSYI

2316: , v_bcol_wip_supply_type
2317: , v_bcol_order_quantity_uom
2318: , v_bcol_config_creation
2319: , v_bcol_perform_match
2320: from oe_order_lines_all OEOL , mtl_system_items MSYI
2321: where OEOL.ato_line_id = p_bcol_line_id
2322: and OEOL.line_id = p_bcol_line_id
2323: and MSYI.bom_item_type = '1'
2324: and OEOL.inventory_item_id = MSYI.inventory_item_id

Line 3792: from oe_order_headers_all h, oe_order_lines_all l

3788: END IF;
3789:
3790: select h.source_document_type_id
3791: into l_source_document_type_id
3792: from oe_order_headers_all h, oe_order_lines_all l
3793: where h.header_id = l.header_id
3794: and l.line_id = pLineId
3795: and rownum = 1;
3796:

Line 4564: oe_order_lines_all oel,

4560:
4561: CURSOR c_rsv_details IS
4562: select reservation_id,reservation_quantity,supply_source_type_id
4563: from mtl_reservations mr,
4564: oe_order_lines_all oel,
4565: oe_order_headers_all oeh,
4566: oe_transaction_types_all ota,
4567: oe_transaction_types_tl otl,
4568: mtl_sales_orders mso

Line 5500: from oe_order_lines_all oeol , mtl_system_items msi

5496:
5497: cursor config_update( c_organization_id in number)
5498: is
5499: select line_id, split_from_line_id
5500: from oe_order_lines_all oeol , mtl_system_items msi
5501: where oeol.line_id = p_ato_line_id
5502: and oeol.inventory_item_id = msi.inventory_item_id
5503: and msi.organization_id = c_organization_id
5504: and msi.bom_item_type = 1 ;

Line 5524: from oe_order_lines_all oel,

5520: BUG:3484511
5521: -----------
5522: select master_organization_id
5523: into v_organization_id
5524: from oe_order_lines_all oel,
5525: oe_system_parameters_all ospa
5526: where oel.line_id = p_ato_line_id
5527: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) ; --bug 1531691
5528: */

Line 5538: into v_organization_id from oe_order_lines_all oel

5534: END IF;
5535:
5536:
5537: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
5538: into v_organization_id from oe_order_lines_all oel
5539: where oel.line_id = p_ato_line_id;
5540:
5541:
5542:

Line 5620: from oe_order_lines_all

5616: oe_debug_pub.add('CTO_UTILITY_PK.adjust_bcol_for_split: entered ' || p_ato_line_id , 1);
5617:
5618: update bom_cto_order_lines bcol
5619: set ordered_quantity = ( select ordered_quantity
5620: from oe_order_lines_all
5621: where ato_line_id = bcol.ato_line_id
5622: and line_id = bcol.line_id )
5623: where ato_line_id = p_ato_line_id ;
5624:

Line 5643: from oe_order_lines_all

5639: oe_debug_pub.add('CTO_UTILITY_PK.adjust_bcol_for_warehouse: entered ' || p_ato_line_id , 1);
5640:
5641: update bom_cto_order_lines bcol
5642: set ship_from_org_id = ( select ship_from_org_id
5643: from oe_order_lines_all
5644: where ato_line_id = bcol.ato_line_id
5645: and line_id = bcol.line_id )
5646: where ato_line_id = p_ato_line_id ;
5647:

Line 5684: oe_order_lines_all oel,

5680: SELECT reservation_id
5681: INTO l_reservation_id
5682: FROM
5683: mtl_reservations mr,
5684: oe_order_lines_all oel,
5685: oe_order_headers_all oeh,
5686: oe_transaction_types_all ota,
5687: oe_transaction_types_tl otl,
5688: mtl_sales_orders mso

Line 6758: from oe_order_lines_all

6754: from bom_cto_order_lines
6755: where ato_line_id = p_bcol_line_id;
6756:
6757: select count(*) into oe_count
6758: from oe_order_lines_all
6759: where ato_line_id = p_bcol_line_id
6760: and item_type_code <>'CONFIG'
6761: and ordered_quantity > 0 ; -- Added this condition to take care of cancel line cases.
6762:

Line 6786: from oe_order_lines_all oel

6782: begin
6783: select 'Y' into v_oe_bcol_diff from dual
6784: where exists
6785: ((Select 1
6786: from oe_order_lines_all oel
6787: Where not exists
6788: ( Select bcol.line_id,
6789: bcol.ordered_quantity,
6790: bcol.inventory_item_id

Line 6808: from oe_order_lines_all oel

6804: Where not exists
6805: ( Select oel.line_id,
6806: oel.ordered_quantity,
6807: oel.inventory_item_id
6808: from oe_order_lines_all oel
6809: where oel.ato_line_id = p_bcol_line_id
6810: and oel.line_id = bcol.line_id
6811: and oel.ordered_quantity = bcol.ordered_quantity
6812: and oel.inventory_item_id = bcol.inventory_item_id

Line 6848: oe_debug_pub.add ('validate_oe_data: data in BCOL and OE_ORDER_LINES_ALL does not match' , 1);

6844:
6845:
6846: if( v_oe_bcol_diff = 'Y' ) then
6847: IF PG_DEBUG <> 0 THEN
6848: oe_debug_pub.add ('validate_oe_data: data in BCOL and OE_ORDER_LINES_ALL does not match' , 1);
6849: END IF;
6850: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6851: end if;
6852:

Line 7208: l_order_uom_code oe_order_lines_all.order_quantity_uom%type;

7204: --Bugfix 13554996: New variables
7205: l_conv_qty_lot_level number;
7206: l_conv_qty_item_level number;
7207: l_item_id mtl_system_items_kfv.inventory_item_id%type;
7208: l_order_uom_code oe_order_lines_all.order_quantity_uom%type;
7209:
7210: --This gets the reservation_qty and the type of reservation
7211: -- Modified by Renga Kannan on 06/24/05 for Cross Dock project
7212: -- getting reservation qty for ASN, Internal req and Receiving supply types also

Line 7265: -- oe_order_lines_all oel

7261: -- into x_primary_uom_code,
7262: -- l_order_uom_code,
7263: -- l_item_id
7264: -- from mtl_system_items msi,
7265: -- oe_order_lines_all oel
7266: -- where msi.inventory_item_id = oel.inventory_item_id
7267: -- and msi.organization_id = oel.ship_from_org_id
7268: -- and oel.line_id = p_order_line_id; --bugfix 4557050
7269:

Line 7279: oe_order_lines_all oel,

7275: l_order_uom_code,
7276: l_item_id,
7277: l_routing_type
7278: from mtl_system_items msi,
7279: oe_order_lines_all oel,
7280: bom_operational_routings bor
7281: where msi.inventory_item_id = oel.inventory_item_id
7282: and msi.organization_id = oel.ship_from_org_id
7283: and oel.line_id = p_order_line_id

Line 7478: oe_order_lines_all oel

7474: sum(nvl(po.secondary_quantity,0))
7475: into l_ext_req_qty,
7476: l_ext_req_secondary_qty
7477: from po_requisitions_interface_all po,
7478: oe_order_lines_all oel
7479: where po.interface_source_line_id = oel.line_id
7480: and oel.line_id = p_order_line_id
7481: and po.item_id = oel.inventory_item_id
7482: and po.source_type_code = 'VENDOR'

Line 7491: oe_order_lines_all oel

7487: sum(nvl(po.secondary_quantity,0))
7488: into l_int_req_qty,
7489: l_int_req_secondary_qty --changed as part of opm code review
7490: from po_requisitions_interface_all po,
7491: oe_order_lines_all oel
7492: where po.interface_source_line_id = oel.line_id
7493: and oel.line_id = p_order_line_id
7494: and po.item_id = oel.inventory_item_id
7495: and po.source_type_code = 'INVENTORY'