APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on MTL_SYSTEM_ITEMS_B_KFV

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