APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on MTL_SYSTEM_ITEMS

Line 107: FROM mtl_system_items

103: END IF;
104:
105: SELECT DECODE(inventory_asset_flag,'Y',0,1)
106: INTO l_exp_item
107: FROM mtl_system_items
108: WHERE inventory_item_id = p_item_id
109: AND organization_id = p_org_id;
110:
111: IF p_subinventory_code IS NULL THEN

Line 159: MTL_SYSTEM_ITEMS_B_KFV

155: IS
156: SELECT
157: concatenated_segments
158: FROM
159: MTL_SYSTEM_ITEMS_B_KFV
160: WHERE inventory_item_id = c_inventory_item_id
161: AND rownum = 1;
162:
163: l_inventory_item_number VARCHAR2(1025);

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

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

Line 2743: FROM cst_pac_itms_absl_codes cpiac, MTL_SYSTEM_ITEMS_B_KFV mst

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

Line 2758: l_item_name MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;

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