DBA Data[Home] [Help]

APPS.IGR_IMP_004 dependencies on AMS_P_DELIVERABLES_V

Line 667: AMS_P_DELIVERABLES_V DELIV

663: cp_inquiry_type_id igr_i_appl_int.inquiry_type_id%TYPE,
664: cp_package_reduct_ind igr_i_appl_int.pkg_reduct_ind%TYPE) IS
665: SELECT 'X'
666: FROM IGR_I_PKG_ITEM PKGITM,
667: AMS_P_DELIVERABLES_V DELIV
668: WHERE pkgitm.package_item_id = p_inq_pkg_rec.package_item_id
669: AND PKGITM.PACKAGE_ITEM_ID = DELIV.DELIVERABLE_ID
670: AND DELIV.KIT_FLAG = 'N'
671: AND (TRUNC(DELIV.actual_avail_from_date) <= TRUNC(SYSDATE) AND