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.OE_CONFIG_UTIL dependencies on OE_ORDER_LINES_ALL

Line 1152: From oe_order_lines_all

1148: -- re-fetch the value to pass it to lock api.
1149: BEGIN
1150: Select config_rev_nbr
1151: Into l_config_rev_nbr
1152: From oe_order_lines_all
1153: Where line_id = l_line_id;
1154: END;
1155:
1156: l_order_number := OE_SCHEDULE_UTIL.Get_Order_Number(p_header_id);

Line 2595: FROM oe_order_lines_all

2591: l_count := 0;
2592:
2593: SELECT /* MOAC_SQL_CHANGE */ count(*)
2594: INTO l_count
2595: FROM oe_order_lines_all
2596: WHERE top_model_line_id = p_top_model_line_id
2597: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
2598: AND open_flag = 'Y'
2599: AND link_to_line_id =

Line 2601: FROM oe_order_lines_all

2597: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
2598: AND open_flag = 'Y'
2599: AND link_to_line_id =
2600: (SELECT line_id
2601: FROM oe_order_lines_all
2602: WHERE top_model_line_id = p_top_model_line_id
2603: AND component_code = l_parent
2604: AND open_flag = 'Y' );
2605:

Line 2693: FROM OE_ORDER_LINES_ALL

2689: INTO l_header_id, l_config_hdr_id, l_config_rev_nbr, l_model_qty,
2690: l_configuration_id, l_order_source_id, l_orig_sys_document_ref,
2691: l_orig_sys_line_ref, l_orig_sys_shipment_ref, l_change_sequence,
2692: l_source_document_type_id, l_source_document_id, l_source_document_line_id
2693: FROM OE_ORDER_LINES_ALL
2694: WHERE line_id = p_model_line_id;
2695: EXCEPTION
2696: WHEN OTHERS THEN
2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3791: FROM OE_ORDER_LINES_ALL

3787: /* adding component number in this cursor to fix bug 2733667 */
3788:
3789: CURSOR c1 IS
3790: SELECT line_id
3791: FROM OE_ORDER_LINES_ALL
3792: WHERE HEADER_ID = l_header_id AND
3793: TOP_MODEL_LINE_ID = p_top_model_line_id
3794: ORDER BY line_number,shipment_number,nvl(option_number,-1),nvl(component_number,-1);
3795:

Line 3809: FROM oe_order_lines_all

3805:
3806: BEGIN
3807: SELECT header_id
3808: INTO l_header_id
3809: FROM oe_order_lines_all
3810: WHERE line_id = p_top_model_line_id;
3811: EXCEPTION
3812: WHEN NO_DATA_FOUND THEN
3813: l_header_id := 0;

Line 3861: FROM OE_ORDER_LINES_ALL

3857:
3858:
3859: CURSOR c1 IS
3860: SELECT line_id
3861: FROM OE_ORDER_LINES_ALL
3862: WHERE HEADER_ID = l_header_id AND
3863: TOP_MODEL_LINE_ID = l_top_model_line_id AND
3864: ATO_LINE_ID = p_ato_line_id
3865: ORDER BY line_number,shipment_number,nvl(option_number,-1);

Line 3879: FROM oe_order_lines_all

3875:
3876: BEGIN
3877: SELECT top_model_line_id ,header_id
3878: INTO l_top_model_line_id,l_header_id
3879: FROM oe_order_lines_all
3880: WHERE line_id = p_ato_line_id;
3881: EXCEPTION
3882: WHEN NO_DATA_FOUND THEN
3883: l_top_model_line_id := 0;

Line 4039: FROM OE_ORDER_LINES_ALL

4035:
4036:
4037: CURSOR c1 IS
4038: SELECT line_id
4039: FROM OE_ORDER_LINES_ALL
4040: WHERE HEADER_ID = l_header_id AND
4041: TOP_MODEL_LINE_ID = l_top_model_line_id AND
4042: LINK_TO_LINE_ID = p_line_id AND
4043: ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_INCLUDED

Line 4061: FROM oe_order_lines_all

4057:
4058: BEGIN
4059: SELECT top_model_line_id ,header_id
4060: INTO l_top_model_line_id,l_header_id
4061: FROM oe_order_lines_all
4062: WHERE line_id = p_line_id;
4063: EXCEPTION
4064: WHEN NO_DATA_FOUND THEN
4065: l_top_model_line_id := 0;

Line 4764: UPDATE OE_ORDER_LINES_ALL

4760: IF nvl(p_freeze, FALSE) = TRUE OR
4761: l_freeze_macd_kit THEN
4762: -- Update the explosion date on the model line.
4763: BEGIN
4764: UPDATE OE_ORDER_LINES_ALL
4765: set explosion_date = l_explosion_date,
4766: lock_control = lock_control + 1
4767: WHERE line_id = l_parent_line_rec.line_id;
4768: EXCEPTION

Line 5629: FROM OE_ORDER_LINES_ALL

5625: l_header_id NUMBER := 0;
5626:
5627: CURSOR l_line_csr(l_top_model_line_id NUMBER) IS
5628: SELECT line_id
5629: FROM OE_ORDER_LINES_ALL
5630: WHERE HEADER_ID = l_header_id
5631: AND (TOP_MODEL_LINE_ID = l_top_model_line_id OR
5632: ( LINK_TO_LINE_ID = p_link_to_line_id AND
5633: ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_INCLUDED AND

Line 5665: FROM oe_order_lines_all

5661: END IF;
5662:
5663: SELECT header_id
5664: INTO l_header_id
5665: FROM oe_order_lines_all
5666: WHERE line_id=ll_line_id;
5667:
5668: EXCEPTION
5669: WHEN OTHERS THEN

Line 6454: FROM oe_order_lines_all oel,

6450: l_valid := 0;
6451:
6452: SELECT distinct 1
6453: INTO l_valid
6454: FROM oe_order_lines_all oel,
6455: mtl_system_items msi
6456: WHERE oel.line_id = p_line_id
6457: AND oel.inventory_item_id = msi.base_item_id
6458: AND msi.inventory_item_id = p_config_item_id;

Line 6616: UPDATE oe_order_lines_all

6612: IF l_debug_level > 0 THEN
6613: oe_debug_pub.add('ENTERING OE_CONFIG_UTIL.UPDATE_MFG_COMP_SEQ_ID' , 1);
6614: END IF;
6615:
6616: UPDATE oe_order_lines_all
6617: SET mfg_component_sequence_id = p_mfg_comp_seq_id
6618: ,last_update_date = sysdate
6619: ,last_updated_by = FND_Global.User_Id
6620: ,last_update_login = FND_Global.Login_Id

Line 8946: , OM_Parent_Line_id oe_order_lines_all.line_id%TYPE

8942: , extended_quantity bom_explosions.extended_quantity%TYPE
8943: , component_code bom_explosions.component_code%TYPE
8944: , PRIMARY_UOM_CODE bom_explosions.PRIMARY_UOM_CODE%TYPE
8945: , sort_order bom_explosions.sort_order%TYPE
8946: , OM_Parent_Line_id oe_order_lines_all.line_id%TYPE
8947: , OM_Parent_Inventory_Item_id oe_order_lines_all.Inventory_Item_id%TYPE
8948: );
8949:
8950:

Line 8947: , OM_Parent_Inventory_Item_id oe_order_lines_all.Inventory_Item_id%TYPE

8943: , component_code bom_explosions.component_code%TYPE
8944: , PRIMARY_UOM_CODE bom_explosions.PRIMARY_UOM_CODE%TYPE
8945: , sort_order bom_explosions.sort_order%TYPE
8946: , OM_Parent_Line_id oe_order_lines_all.line_id%TYPE
8947: , OM_Parent_Inventory_Item_id oe_order_lines_all.Inventory_Item_id%TYPE
8948: );
8949:
8950:
8951: CURSOR C_PreExploded_Kit (c_top_model_line_id IN NUMBER) IS

Line 8952: SELECT line_id FROM oe_order_lines_all

8948: );
8949:
8950:
8951: CURSOR C_PreExploded_Kit (c_top_model_line_id IN NUMBER) IS
8952: SELECT line_id FROM oe_order_lines_all
8953: WHERE item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
8954: AND top_model_line_id = c_top_model_line_id
8955: AND top_model_line_id <> line_id;
8956:

Line 8994: FROM bom_bill_of_materials bom, oe_order_lines_all oel

8990: -- get sets to Bom_Explosion_Rec
8991: CURSOR C_Bill_Seq_id ( p_top_model_line_id IN NUMBER, p_header_id IN NUMBER
8992: , p_validation_org IN NUMBER) IS
8993: SELECT bom.bill_sequence_id, oel.line_id, oel.inventory_item_id
8994: FROM bom_bill_of_materials bom, oe_order_lines_all oel
8995: WHERE bom.ASSEMBLY_ITEM_ID = oel.inventory_item_id
8996: AND oel.top_model_line_id = p_top_model_line_id
8997: AND oel.header_id = p_header_id
8998: AND oel.item_type_code in (OE_GLOBALS.G_ITEM_CLASS,OE_GLOBALS.G_ITEM_KIT,OE_GLOBALS.G_ITEM_MODEL)

Line 9002: -- comp_number is used to set the Component_Number column on OE_Order_Lines_All

8998: AND oel.item_type_code in (OE_GLOBALS.G_ITEM_CLASS,OE_GLOBALS.G_ITEM_KIT,OE_GLOBALS.G_ITEM_MODEL)
8999: AND bom.ORGANIZATION_ID = p_validation_org
9000: AND bom.ALTERNATE_BOM_DESIGNATOR IS NULL;
9001:
9002: -- comp_number is used to set the Component_Number column on OE_Order_Lines_All
9003: -- table for all the INCLUDED item components inside its given immediate parent
9004: CURSOR comp_number (c_parent_line_id IN NUMBER, c_top_model_line_id IN NUMBER, c_header_id IN NUMBER) IS
9005: SELECT line_id
9006: FROM oe_order_lines_all

Line 9006: FROM oe_order_lines_all

9002: -- comp_number is used to set the Component_Number column on OE_Order_Lines_All
9003: -- table for all the INCLUDED item components inside its given immediate parent
9004: CURSOR comp_number (c_parent_line_id IN NUMBER, c_top_model_line_id IN NUMBER, c_header_id IN NUMBER) IS
9005: SELECT line_id
9006: FROM oe_order_lines_all
9007: WHERE link_to_line_id = c_parent_line_id
9008: AND top_model_line_id = c_top_model_line_id
9009: AND header_id = c_header_id
9010: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED;

Line 9155: -- and BOM information passed by DOO in OE_order_Lines_All table is same

9151: -- required validation to be considered but we are safely ignoring
9152: -- them.
9153: --
9154: -- Validating if the EBS BOM definition in BOM_Explosions table
9155: -- and BOM information passed by DOO in OE_order_Lines_All table is same
9156: IF l_included_item_tbl.COUNT <> l_Bom_Explosion_Tbl.COUNT THEN
9157: if l_debug_level > 0 then
9158: oe_debug_pub.add(' The count of Included Items are not same',5);
9159: end if;

Line 9224: UPDATE OE_order_Lines_All

9220: if l_debug_level > 0 then
9221: oe_debug_pub.add(' Setting the BOM data in OM for Line : '||l_included_item_tbl(i).line_id,5);
9222: end if;
9223:
9224: UPDATE OE_order_Lines_All
9225: SET Component_Sequence_id = l_Bom_Explosion_Tbl(j).component_sequence_id
9226: , Sort_Order = l_Bom_Explosion_Tbl(j).sort_order
9227: , Component_Code = l_Bom_Explosion_Tbl(j).component_code
9228: , Explosion_Date = l_explosion_date

Line 9308: UPDATE OE_order_Lines_All

9304: l_component_number := 0;
9305: END LOOP;
9306: END IF;
9307:
9308: UPDATE OE_order_Lines_All
9309: SET Explosion_Date = l_explosion_date
9310: , lock_control = lock_control + 1
9311: WHERE Line_id = l_parent_line_rec.line_id;
9312: