DBA Data[Home] [Help]

APPS.OKE_DELIVERABLE_UTILS_PUB dependencies on OKE_SYSTEM_ITEMS_V

Line 355: FROM oke_system_items_v

351: RETURN VARCHAR2 IS
352:
353: CURSOR c IS
354: SELECT NVL(shippable_item_flag, 'N')
355: FROM oke_system_items_v
356: WHERE id1 = (
357: SELECT item_id
358: FROM oke_deliverables_b
359: WHERE source_code = 'PA'

Line 404: FROM oke_system_items_v

400: RETURN VARCHAR2 IS
401:
402: CURSOR c IS
403: SELECT NVL(invoiceable_item_flag, 'N')
404: FROM oke_system_items_v
405: WHERE id1 = (
406: SELECT item_id
407: FROM oke_deliverables_b
408: WHERE source_code = 'PA'

Line 452: FROM oke_system_items_v

448: RETURN VARCHAR2 IS
449:
450: CURSOR c IS
451: SELECT NVL(purchasing_enabled_flag, 'N')
452: FROM oke_system_items_v
453: WHERE id1 = (
454: SELECT item_id
455: FROM oke_deliverables_b
456: WHERE source_code = 'PA'