APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_ITEM_GROUPS_B

Line 2843: SELECT 'x' FROM ahl_item_groups_b

2839:
2840: -- cursor changed by anraj
2841: -- backend validation to check that while create the Item Group given is of type NON-TRACKED
2842: CURSOR val_item_group_csr(p_item_group_id IN NUMBER) IS
2843: SELECT 'x' FROM ahl_item_groups_b
2844: WHERE item_group_id = p_item_group_id
2845: AND status_code = 'COMPLETE' AND type_code = 'NON-TRACKED';
2846:
2847:

Line 3512: SELECT item_group_id from ahl_item_groups_b

3508: SELECT instance_id from csi_item_instances
3509: WHERE instance_number = p_instance_number;
3510:
3511: CURSOR item_group_id_csr(p_item_group_name IN VARCHAR2) IS
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

Line 4550: FROM ahl_item_groups_b

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
4550: FROM ahl_item_groups_b
4551: WHERE item_group_id = p_disposition_rec.item_group_id;
4552: ELSE
4553: l_trackable_flag := 'N';
4554: END IF;