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 500: v_source_type_code oe_order_lines_all.source_type_code%type ;

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

Line 602: from oe_order_lines_all

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

Line 1219: from oe_order_lines_all oel,

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

Line 1233: into lValidationOrg from oe_order_lines_all oel

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

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

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

Line 2172: v_inventory_item_id oe_order_lines_all.inventory_item_id%type ;

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

Line 2216: from oe_order_lines_all

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

Line 2233: from oe_order_lines_all oel,

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

Line 2249: into v_organization_id from oe_order_lines_all oel

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

Line 2318: from oe_order_lines_all OEOL , mtl_system_items MSYI

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

Line 3770: from oe_order_headers_all h, oe_order_lines_all l

3766: END IF;
3767:
3768: select h.source_document_type_id
3769: into l_source_document_type_id
3770: from oe_order_headers_all h, oe_order_lines_all l
3771: where h.header_id = l.header_id
3772: and l.line_id = pLineId
3773: and rownum = 1;
3774:

Line 4540: oe_order_lines_all oel,

4536:
4537: CURSOR c_rsv_details IS
4538: select reservation_id,reservation_quantity,supply_source_type_id
4539: from mtl_reservations mr,
4540: oe_order_lines_all oel,
4541: oe_order_headers_all oeh,
4542: oe_transaction_types_all ota,
4543: oe_transaction_types_tl otl,
4544: mtl_sales_orders mso

Line 5476: from oe_order_lines_all oeol , mtl_system_items msi

5472:
5473: cursor config_update( c_organization_id in number)
5474: is
5475: select line_id, split_from_line_id
5476: from oe_order_lines_all oeol , mtl_system_items msi
5477: where oeol.line_id = p_ato_line_id
5478: and oeol.inventory_item_id = msi.inventory_item_id
5479: and msi.organization_id = c_organization_id
5480: and msi.bom_item_type = 1 ;

Line 5500: from oe_order_lines_all oel,

5496: BUG:3484511
5497: -----------
5498: select master_organization_id
5499: into v_organization_id
5500: from oe_order_lines_all oel,
5501: oe_system_parameters_all ospa
5502: where oel.line_id = p_ato_line_id
5503: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) ; --bug 1531691
5504: */

Line 5514: into v_organization_id from oe_order_lines_all oel

5510: END IF;
5511:
5512:
5513: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
5514: into v_organization_id from oe_order_lines_all oel
5515: where oel.line_id = p_ato_line_id;
5516:
5517:
5518:

Line 5596: from oe_order_lines_all

5592: oe_debug_pub.add('CTO_UTILITY_PK.adjust_bcol_for_split: entered ' || p_ato_line_id , 1);
5593:
5594: update bom_cto_order_lines bcol
5595: set ordered_quantity = ( select ordered_quantity
5596: from oe_order_lines_all
5597: where ato_line_id = bcol.ato_line_id
5598: and line_id = bcol.line_id )
5599: where ato_line_id = p_ato_line_id ;
5600:

Line 5619: from oe_order_lines_all

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

Line 5660: oe_order_lines_all oel,

5656: SELECT reservation_id
5657: INTO l_reservation_id
5658: FROM
5659: mtl_reservations mr,
5660: oe_order_lines_all oel,
5661: oe_order_headers_all oeh,
5662: oe_transaction_types_all ota,
5663: oe_transaction_types_tl otl,
5664: mtl_sales_orders mso

Line 6734: from oe_order_lines_all

6730: from bom_cto_order_lines
6731: where ato_line_id = p_bcol_line_id;
6732:
6733: select count(*) into oe_count
6734: from oe_order_lines_all
6735: where ato_line_id = p_bcol_line_id
6736: and item_type_code <>'CONFIG'
6737: and ordered_quantity > 0 ; -- Added this condition to take care of cancel line cases.
6738:

Line 6762: from oe_order_lines_all oel

6758: begin
6759: select 'Y' into v_oe_bcol_diff from dual
6760: where exists
6761: ((Select 1
6762: from oe_order_lines_all oel
6763: Where not exists
6764: ( Select bcol.line_id,
6765: bcol.ordered_quantity,
6766: bcol.inventory_item_id

Line 6784: from oe_order_lines_all oel

6780: Where not exists
6781: ( Select oel.line_id,
6782: oel.ordered_quantity,
6783: oel.inventory_item_id
6784: from oe_order_lines_all oel
6785: where oel.ato_line_id = p_bcol_line_id
6786: and oel.line_id = bcol.line_id
6787: and oel.ordered_quantity = bcol.ordered_quantity
6788: and oel.inventory_item_id = bcol.inventory_item_id

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

6820:
6821:
6822: if( v_oe_bcol_diff = 'Y' ) then
6823: IF PG_DEBUG <> 0 THEN
6824: oe_debug_pub.add ('validate_oe_data: data in BCOL and OE_ORDER_LINES_ALL does not match' , 1);
6825: END IF;
6826: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6827: end if;
6828:

Line 7225: oe_order_lines_all oel

7221: --need this for flow and interface data alone
7222: Select msi.primary_uom_code
7223: into x_primary_uom_code
7224: from mtl_system_items msi,
7225: oe_order_lines_all oel
7226: where msi.inventory_item_id = oel.inventory_item_id
7227: and msi.organization_id = oel.ship_from_org_id
7228: and oel.line_id = p_order_line_id; --bugfix 4557050
7229:

Line 7360: oe_order_lines_all oel

7356: sum(nvl(po.secondary_quantity,0))
7357: into l_ext_req_qty,
7358: l_ext_req_secondary_qty
7359: from po_requisitions_interface_all po,
7360: oe_order_lines_all oel
7361: where po.interface_source_line_id = oel.line_id
7362: and oel.line_id = p_order_line_id
7363: and po.item_id = oel.inventory_item_id
7364: and po.source_type_code = 'VENDOR'

Line 7372: oe_order_lines_all oel

7368: sum(nvl(po.secondary_quantity,0))
7369: into l_int_req_qty,
7370: l_int_req_secondary_qty --changed as part of opm code review
7371: from po_requisitions_interface_all po,
7372: oe_order_lines_all oel
7373: where po.interface_source_line_id = oel.line_id
7374: and oel.line_id = p_order_line_id
7375: and po.item_id = oel.inventory_item_id
7376: and po.source_type_code = 'INVENTORY'