DBA Data[Home] [Help]

APPS.OE_ORDER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 2889: FROM mtl_system_items

2885: BEGIN
2886: IF l_old_line_rec.inventory_item_id is NOT NULL THEN
2887: SELECT bom_item_type
2888: INTO l_bom_item_type
2889: FROM mtl_system_items
2890: WHERE inventory_item_id = l_line_rec.inventory_item_id
2891: AND organization_id
2892: = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2893:

Line 12306: FROM MTL_SYSTEM_ITEMS_KFV

12302:
12303: BEGIN
12304: SELECT concatenated_segments
12305: INTO p_x_line_tbl(l_index).ordered_item
12306: FROM MTL_SYSTEM_ITEMS_KFV
12307: WHERE inventory_item_id = p_x_line_tbl(I).inventory_item_id
12308: AND organization_id = l_validation_org;
12309: EXCEPTION
12310: WHEN NO_DATA_FOUND THEN