APPS.AHL_PRD_DISPOSITION_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 203: FROM mtl_system_items_kfv

199: WHERE rt_oper_material_id = c_rt_oper_material_id;
200: l_mtl_req_flags get_mtl_req_flags%ROWTYPE;
201: CURSOR check_item_org(c_inventory_item_id NUMBER, c_organization_id NUMBER) IS
202: SELECT 'X'
203: FROM mtl_system_items_kfv
204: WHERE inventory_item_id = c_inventory_item_id
205: AND organization_id = c_organization_id;
206: CURSOR check_unit_instance(c_instance_id NUMBER) IS
207: SELECT csi_item_instance_id

Line 2930: FROM MTL_SYSTEM_ITEMS_KFV MTL

2926: -- Added the following for fixing Bug#:4059944
2927: -- To find whether the Item is IB Trackable
2928: CURSOR item_is_ib_trackable(p_inventory_item_id IN NUMBER) IS
2929: SELECT NVL(MTL.comms_nl_trackable_flag, 'N') trackable_flag
2930: FROM MTL_SYSTEM_ITEMS_KFV MTL
2931: WHERE MTL.INVENTORY_ITEM_ID= p_inventory_item_id;
2932:
2933: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 13-Dec-2007
2934: -- Cursor to check whether the disposition item is serialized or not.

Line 3516: SELECT inventory_item_id FROM MTL_SYSTEM_ITEMS_KFV

3512: SELECT item_group_id from ahl_item_groups_b
3513: WHERE name = p_item_group_name AND status_code = 'COMPLETE';
3514:
3515: CURSOR item_id_csr(p_item_number IN VARCHAR2) IS
3516: SELECT inventory_item_id FROM MTL_SYSTEM_ITEMS_KFV
3517: WHERE concatenated_segments = p_item_number;
3518:
3519: CURSOR condition_id_csr(p_condition_meaning IN VARCHAR2) IS
3520: SELECT status_id FROM mtl_material_statuses_vl

Line 3747: SELECT 'x' FROM mtl_system_items_kfv

3743: WHERE wo.workorder_id = p_workorder_id
3744: AND wo.visit_id = vi.visit_id;
3745:
3746: CURSOR val_item_csr(p_item_id NUMBER, p_organization_id NUMBER) IS
3747: SELECT 'x' FROM mtl_system_items_kfv
3748: WHERE inventory_item_id = p_inventory_item_id
3749: AND organization_id = p_organization_id;
3750:
3751:

Line 3802: FROM MTL_SYSTEM_ITEMS_KFV

3798:
3799:
3800: CURSOR item_control_csr(p_item_id IN NUMBER, p_org_id IN NUMBER) IS
3801: SELECT serial_number_control_code, revision_qty_control_code, lot_control_code
3802: FROM MTL_SYSTEM_ITEMS_KFV
3803: WHERE inventory_item_id = p_item_id
3804: AND organization_id = p_org_id;
3805:
3806: l_item_crl_rec item_control_csr%ROWTYPE;

Line 4183: FROM MTL_SYSTEM_ITEMS_KFV MTL

4179: --
4180: CURSOR get_trackable_csr (p_inv_item_id IN NUMBER,
4181: p_inv_org_id IN NUMBER) IS
4182: SELECT NVL(MTL.comms_nl_trackable_flag, 'N') trackable_flag
4183: FROM MTL_SYSTEM_ITEMS_KFV MTL
4184: WHERE MTL.INVENTORY_ITEM_ID= p_inv_item_id
4185: AND MTL.organization_id =p_inv_org_id;
4186: --
4187: CURSOR get_part_change_type_csr (p_part_change_id IN NUMBER) IS

Line 4545: FROM mtl_system_items_kfv

4541: IF p_disposition_rec.path_position_id IS NOT NULL THEN
4542: l_trackable_flag := 'Y';
4543: ELSIF p_disposition_rec.inventory_item_id IS NOT NULL THEN
4544: SELECT nvl(comms_nl_trackable_flag, 'N') INTO l_trackable_flag
4545: FROM mtl_system_items_kfv
4546: WHERE inventory_item_id = p_disposition_rec.inventory_item_id
4547: AND organization_id = p_disposition_rec.item_org_id;
4548: ELSIF p_disposition_rec.item_group_id IS NOT NULL THEN
4549: SELECT decode(type_code, 'TRACKED', 'Y', 'N') INTO l_trackable_flag