APPS.OKE_ACTION_VALIDATIONS_PKG dependencies on OKE_SYSTEM_ITEMS_V

Line 149: FROM oke_system_items_v

145: WHERE b.deliverable_id = p_deliverable_id;
146:
147: CURSOR c2 IS
148: SELECT '!'
149: FROM oke_system_items_v
150: WHERE id1 = l_item_id
151: AND organization_id = l_org_id
152: AND NVL(shippable_item_flag, 'N') = 'Y';
153:

Line 289: FROM oke_system_items_v

285: AND b.source_code = 'PA';
286:
287: CURSOR c2 IS
288: SELECT 'x'
289: FROM oke_system_items_v
290: WHERE id1 = l_item_id
291: AND organization_id = l_org_id
292: AND NVL(shippable_item_flag, 'N') = 'Y';
293:

Line 461: FROM oke_system_items_v

457: AND b.source_code = 'PA' ;
458:
459: CURSOR c2 IS
460: SELECT 'x'
461: FROM oke_system_items_v
462: WHERE id1 = l_item_id
463: AND organization_id = l_org_id
464: AND NVL(purchasing_enabled_flag, 'N') = 'Y';
465: