APPS.AHL_PRD_DISPOSITION_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 205: FROM mtl_system_items_kfv

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

Line 3353: FROM MTL_SYSTEM_ITEMS_KFV MTL

3349: -- Added the following for fixing Bug#:4059944
3350: -- To find whether the Item is IB Trackable
3351: CURSOR item_is_ib_trackable(p_inventory_item_id IN NUMBER) IS
3352: SELECT NVL(MTL.comms_nl_trackable_flag, 'N') trackable_flag
3353: FROM MTL_SYSTEM_ITEMS_KFV MTL
3354: WHERE MTL.INVENTORY_ITEM_ID= p_inventory_item_id;
3355:
3356: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 13-Dec-2007
3357: -- Cursor to check whether the disposition item is serialized or not.

Line 3949: SELECT inventory_item_id FROM MTL_SYSTEM_ITEMS_KFV

3945: SELECT item_group_id from ahl_item_groups_b
3946: WHERE name = p_item_group_name AND status_code = 'COMPLETE';
3947:
3948: CURSOR item_id_csr(p_item_number IN VARCHAR2) IS
3949: SELECT inventory_item_id FROM MTL_SYSTEM_ITEMS_KFV
3950: WHERE concatenated_segments = p_item_number;
3951:
3952: CURSOR condition_id_csr(p_condition_meaning IN VARCHAR2) IS
3953: SELECT status_id FROM mtl_material_statuses_vl

Line 4207: SELECT 'x' FROM mtl_system_items_kfv

4203: WHERE wo.workorder_id = p_workorder_id
4204: AND wo.visit_id = vi.visit_id;
4205:
4206: CURSOR val_item_csr(p_item_id NUMBER, p_organization_id NUMBER) IS
4207: SELECT 'x' FROM mtl_system_items_kfv
4208: WHERE inventory_item_id = p_inventory_item_id
4209: AND organization_id = p_organization_id;
4210:
4211:

Line 4262: FROM MTL_SYSTEM_ITEMS_KFV

4258:
4259:
4260: CURSOR item_control_csr(p_item_id IN NUMBER, p_org_id IN NUMBER) IS
4261: SELECT serial_number_control_code, revision_qty_control_code, lot_control_code
4262: FROM MTL_SYSTEM_ITEMS_KFV
4263: WHERE inventory_item_id = p_item_id
4264: AND organization_id = p_org_id;
4265:
4266: l_item_crl_rec item_control_csr%ROWTYPE;

Line 4643: FROM MTL_SYSTEM_ITEMS_KFV MTL

4639: --
4640: CURSOR get_trackable_csr (p_inv_item_id IN NUMBER,
4641: p_inv_org_id IN NUMBER) IS
4642: SELECT NVL(MTL.comms_nl_trackable_flag, 'N') trackable_flag
4643: FROM MTL_SYSTEM_ITEMS_KFV MTL
4644: WHERE MTL.INVENTORY_ITEM_ID= p_inv_item_id
4645: AND MTL.organization_id =p_inv_org_id;
4646: --
4647: CURSOR get_part_change_type_csr (p_part_change_id IN NUMBER) IS

Line 5005: FROM mtl_system_items_kfv

5001: IF p_disposition_rec.path_position_id IS NOT NULL THEN
5002: l_trackable_flag := 'Y';
5003: ELSIF p_disposition_rec.inventory_item_id IS NOT NULL THEN
5004: SELECT nvl(comms_nl_trackable_flag, 'N') INTO l_trackable_flag
5005: FROM mtl_system_items_kfv
5006: WHERE inventory_item_id = p_disposition_rec.inventory_item_id
5007: AND organization_id = p_disposition_rec.item_org_id;
5008: ELSIF p_disposition_rec.item_group_id IS NOT NULL THEN
5009: SELECT decode(type_code, 'TRACKED', 'Y', 'N') INTO l_trackable_flag