DBA Data[Home] [Help]

APPS.OE_CONFIG_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 4532: FROM MTL_SYSTEM_ITEMS_KFV

4528:
4529: BEGIN
4530: SELECT concatenated_segments
4531: INTO l_line_rec.ordered_item
4532: FROM MTL_SYSTEM_ITEMS_KFV
4533: WHERE inventory_item_id = l_line_rec.inventory_item_id
4534: AND organization_id = l_validation_org;
4535: EXCEPTION
4536: WHEN NO_DATA_FOUND THEN

Line 6455: mtl_system_items msi

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;
6459:

Line 8166: from mtl_system_items mtl

8162:
8163: BEGIN
8164: select 'Y'
8165: into l_serviceable_item
8166: from mtl_system_items mtl
8167: where mtl.inventory_item_id = p_line_tbl(I).inventory_item_id
8168: and mtl.organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
8169: and mtl.serviceable_product_flag='Y'
8170: and rownum = 1;