DBA Data[Home] [Help]

APPS.OE_ORDER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 2812: FROM mtl_system_items

2808: BEGIN
2809: IF l_old_line_rec.inventory_item_id is NOT NULL THEN
2810: SELECT bom_item_type
2811: INTO l_bom_item_type
2812: FROM mtl_system_items
2813: WHERE inventory_item_id = l_line_rec.inventory_item_id
2814: AND organization_id
2815: = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2816:

Line 12077: FROM MTL_SYSTEM_ITEMS_KFV

12073:
12074: BEGIN
12075: SELECT concatenated_segments
12076: INTO p_x_line_tbl(l_index).ordered_item
12077: FROM MTL_SYSTEM_ITEMS_KFV
12078: WHERE inventory_item_id = p_x_line_tbl(I).inventory_item_id
12079: AND organization_id = l_validation_org;
12080: EXCEPTION
12081: WHEN NO_DATA_FOUND THEN