APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on MTL_SYSTEM_ITEMS

Line 98: FROM mtl_system_items

94: ELSE
95:
96: SELECT DECODE(inventory_asset_flag,'Y',0,1)
97: INTO l_exp_item
98: FROM mtl_system_items
99: WHERE inventory_item_id = p_item_id
100: AND organization_id = p_org_id;
101:
102: G_EXPENSE_ITEM_CACHE(p_org_id)(p_item_id) := l_exp_item;

Line 179: MTL_SYSTEM_ITEMS_B_KFV

175: IS
176: SELECT
177: concatenated_segments
178: FROM
179: MTL_SYSTEM_ITEMS_B_KFV
180: WHERE inventory_item_id = c_inventory_item_id
181: AND rownum = 1;
182:
183: l_inventory_item_number VARCHAR2(1025);

Line 995: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE';

991:
992: SELECT control_level
993: INTO l_uom_control
994: FROM mtl_item_attributes
995: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE';
996:
997: RETURN l_uom_control;
998:
999: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2745: FROM cst_pac_itms_absl_codes cpiac, MTL_SYSTEM_ITEMS_B_KFV mst

2741: ,c_absorption_level_code NUMBER
2742: )
2743: IS
2744: SELECT distinct(mst.concatenated_segments)
2745: FROM cst_pac_itms_absl_codes cpiac, MTL_SYSTEM_ITEMS_B_KFV mst
2746: WHERE cpiac.pac_period_id = c_pac_period_id
2747: AND cpiac.absorption_level_code < c_absorption_level_code
2748: AND cpiac.inventory_item_id = mst.inventory_item_id;
2749:

Line 2760: l_item_name MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;

2756: l_min_child_absl_level_code NUMBER;
2757: l_reposition_absl_level_code NUMBER;
2758:
2759: l_dead_lock_message VARCHAR2(3000) := ' ';
2760: l_item_name MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;
2761: l_continue_loop_flag VARCHAR2(1) := 'Y';
2762:
2763: BEGIN
2764: