DBA Data[Home] [Help]

APPS.IGR_IMP_004 dependencies on AMS_P_DELIV_KIT_ITEMS_V

Line 676: FROM ams_p_deliv_kit_items_v kitems,igr_i_inquiry_types inq

672: TRUNC(DELIV.actual_avail_to_date) >= TRUNC(SYSDATE) )
673: AND (
674: -- Validate Package item against Inquiry Type => Associated with Information Type/Deliverable Kit => With Package items in it.
675: EXISTS ( SELECT 1
676: FROM ams_p_deliv_kit_items_v kitems,igr_i_inquiry_types inq
677: WHERE kitems.deliverable_kit_part_id = pkgitm.package_item_id
678: AND kitems.deliverable_kit_id = inq.info_type_id
679: AND inq.inquiry_type_id = cp_inquiry_type_id
680: )