APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_ITEM_GROUPS_B

Line 3266: SELECT 'x' FROM ahl_item_groups_b

3262:
3263: -- cursor changed by anraj
3264: -- backend validation to check that while create the Item Group given is of type NON-TRACKED
3265: CURSOR val_item_group_csr(p_item_group_id IN NUMBER) IS
3266: SELECT 'x' FROM ahl_item_groups_b
3267: WHERE item_group_id = p_item_group_id
3268: AND status_code = 'COMPLETE' AND type_code = 'NON-TRACKED';
3269:
3270:

Line 3945: SELECT item_group_id from ahl_item_groups_b

3941: SELECT instance_id from csi_item_instances
3942: WHERE instance_number = p_instance_number;
3943:
3944: CURSOR item_group_id_csr(p_item_group_name IN VARCHAR2) IS
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

Line 5010: FROM ahl_item_groups_b

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
5010: FROM ahl_item_groups_b
5011: WHERE item_group_id = p_disposition_rec.item_group_id;
5012: ELSE
5013: l_trackable_flag := 'N';
5014: END IF;