eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGR_GEN_001 dependencies on AMS_DELIV_KIT_ITEMS

Line 1617: FROM AMS_DELIV_KIT_ITEMS akit,

1613: cst_course CONSTANT VARCHAR2(7) := 'COURSE';
1614:
1615: CURSOR c_eitpi IS
1616: SELECT akit.deliverable_kit_part_id
1617: FROM AMS_DELIV_KIT_ITEMS akit,
1618: AMS_P_DELIVERABLES_V apd
1619: WHERE apd.deliverable_name = p_enquiry_information_type
1620: AND apd.deliverable_id = akit.deliverable_kit_id;
1621:

Line 1626: cp_enquiry_package_item_id AMS_DELIV_KIT_ITEMS.deliverable_kit_part_id%TYPE) IS

1622:
1623:
1624: --Check INFORMATION type packages.(Other than the parameter type)
1625: CURSOR c_eapit_eitpi(
1626: cp_enquiry_package_item_id AMS_DELIV_KIT_ITEMS.deliverable_kit_part_id%TYPE) IS
1627: SELECT 'X' FROM IGR_I_A_ITYPE eapit,
1628: AMS_DELIV_KIT_ITEMS akit,
1629: AMS_P_DELIVERABLES_V apd
1630: WHERE eapit.person_id = p_person_id AND

Line 1628: AMS_DELIV_KIT_ITEMS akit,

1624: --Check INFORMATION type packages.(Other than the parameter type)
1625: CURSOR c_eapit_eitpi(
1626: cp_enquiry_package_item_id AMS_DELIV_KIT_ITEMS.deliverable_kit_part_id%TYPE) IS
1627: SELECT 'X' FROM IGR_I_A_ITYPE eapit,
1628: AMS_DELIV_KIT_ITEMS akit,
1629: AMS_P_DELIVERABLES_V apd
1630: WHERE eapit.person_id = p_person_id AND
1631: eapit.enquiry_appl_number = p_enquiry_appl_number AND
1632: apd.deliverable_name<> p_enquiry_information_type AND

Line 1638: cp_package_item_id AMS_DELIV_KIT_ITEMS.deliverable_kit_part_id%TYPE) IS

1634: eapit.info_type_id = akit.deliverable_kit_id AND
1635: akit.deliverable_kit_part_id = cp_enquiry_package_item_id;
1636:
1637: CURSOR c_eapmpi_del(
1638: cp_package_item_id AMS_DELIV_KIT_ITEMS.deliverable_kit_part_id%TYPE) IS
1639: SELECT ROWID, eapmpi.*
1640: FROM IGR_I_A_PKGITM eapmpi
1641: WHERE eapmpi.person_id = p_person_id AND
1642: eapmpi.enquiry_appl_number = p_enquiry_appl_number AND

Line 1737: AMS_DELIV_KIT_ITEMS akit

1733: CURSOR c_eitpi IS
1734: SELECT akit.deliverable_kit_part_id
1735: FROM AMS_P_DELIVERABLES_V apd,
1736: AMS_P_DELIVERABLES_V apd1,
1737: AMS_DELIV_KIT_ITEMS akit
1738: WHERE apd.deliverable_id = akit.deliverable_kit_part_id
1739: AND apd.actual_avail_from_date <= SYSDATE
1740: AND apd.actual_avail_to_date >= SYSDATE
1741: AND akit.deliverable_kit_id = apd1.deliverable_id