APPS.ENI_ITEMS_STAR_PKG dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 423: FROM mtl_system_items_b_kfv mti,

419: mti.unit_volume,
420: mti.weight_uom_code,
421: mti.volume_uom_code,
422: mti.eam_item_type
423: FROM mtl_system_items_b_kfv mti,
424: mtl_parameters mtp,
425: mtl_item_categories mic ,
426: mtl_item_categories mic1 ,
427: mtl_item_categories mic2 ,

Line 599: mtl_system_items_b_kfv mti,

595: mti.eam_item_type,
596: mti.creation_date,
597: mti.last_update_date
598: FROM
599: mtl_system_items_b_kfv mti,
600: mtl_parameters mtp,
601: mtl_item_categories mic,
602: mtl_item_categories mic1,
603: mtl_item_categories mic2,

Line 844: FROM mtl_system_items_b_kfv mti,

840: l_vbh_category_set,
841: 'Unassigned',
842: mti.creation_date,
843: mti.last_update_date
844: FROM mtl_system_items_b_kfv mti,
845: mtl_parameters mtp
846: WHERE mti.inventory_item_id = p_inventory_item_id
847: AND mti.organization_id = p_organization_id
848: AND mti.organization_id= mtp.organization_id;

Line 920: FROM mtl_system_items_b_kfv mti

916: ,mti.unit_volume
917: ,mti.weight_uom_code
918: ,mti.volume_uom_code
919: ,mti.eam_item_type
920: FROM mtl_system_items_b_kfv mti
921: , mtl_parameters b
922: WHERE mti.inventory_item_id = p_inventory_item_id
923: AND mti.organization_id = b.organization_id
924: AND b.master_organization_id = p_organization_id;

Line 1504: , mtl_system_items_b_kfv item

1500: , item.eam_item_type
1501: , item.creation_date
1502: , item.last_update_date
1503: FROM mtl_system_items_interface interface
1504: , mtl_system_items_b_kfv item
1505: , mtl_parameters mtp
1506: , mtl_item_categories mic
1507: , mtl_categories_b_kfv kfv
1508: , mtl_item_categories mic1

Line 1632: , mtl_system_items_b_kfv item

1628: , item.eam_item_type
1629: , item.creation_date
1630: , item.last_update_date
1631: FROM mtl_system_items_interface interface
1632: , mtl_system_items_b_kfv item
1633: , mtl_parameters mtp
1634: , mtl_item_categories mic
1635: , mtl_categories_b_kfv kfv
1636: , mtl_item_categories mic1

Line 2096: FROM MTL_SYSTEM_ITEMS_B_KFV

2092:
2093: --Start :5688257 : %Items_In_Star functions to use flex API's to get concatenated segments
2094: BEGIN
2095: SELECT NVL(LENGTH(CONCATENATED_SEGMENTS),0) INTO G_INSTALL_PHASE
2096: FROM MTL_SYSTEM_ITEMS_B_KFV
2097: WHERE ROWNUM = 1;
2098: EXCEPTION
2099: WHEN OTHERS THEN
2100: G_INSTALL_PHASE := 0;