APPS.CSP_PC_FORM_MTLTXNS dependencies on MTL_SYSTEM_ITEMS

Line 349: from mtl_system_items_kfv

345: ELSE
346: BEGIN
347: -- validate whether the inventory_item_is exists in the given oranization_id
348: select inventory_item_id into l_check_existence
349: from mtl_system_items_kfv
350: where inventory_item_id = p_inventory_item_id
351: and organization_id = p_organization_id;
352: EXCEPTION
353: WHEN NO_DATA_FOUND THEN

Line 361: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);

357: WHEN OTHERS THEN
358: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
359: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
360: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
361: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
362: fnd_msg_pub.add;
363: RAISE EXCP_USER_DEFINED;
364: END;
365: END IF;

Line 1064: from mtl_system_items

1060: l_inventory_item_id NUMBER := l_csp_mtltxn_rec.inventory_item_id;
1061:
1062: BEGIN
1063: select restrict_subinventories_code into l_restrict_sub_code
1064: from mtl_system_items
1065: where inventory_item_id = l_inventory_item_id
1066: and organization_id = l_csp_mtltxn_rec.organization_id;
1067:
1068: IF l_restrict_sub_code = 1 THEN