APPS.INV_MWB_CYCLE_COUNT dependencies on MTL_CC_SUBINVENTORIES

Line 48: from mtl_cc_subinventories

44: and abc_class_id = p_abc_class_id;
45:
46: select count(*)
47: into l_subs_ct
48: from mtl_cc_subinventories
49: where cycle_count_header_id = p_cycle_count_header_id
50: and subinventory = p_subinventory_code;
51:
52: select mtl_cc_schedule_requests_s.nextval

Line 57: insert into mtl_cc_subinventories

53: into l_cycle_count_schedule_id
54: from dual;
55:
56: IF l_subs_ct = 0 then
57: insert into mtl_cc_subinventories
58: ( cycle_count_header_id ,
59: subinventory ,
60: last_update_date ,
61: last_updated_by ,