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.OKL_OPEN_INTERFACE_PVT dependencies on HZ_PARTY_SITES

Line 711: ,PARTY_SITE_ID HZ_PARTY_SITES.PARTY_SITE_ID%TYPE

707: ,PARTY_NUMBER HZ_PARTIES.PARTY_NUMBER%TYPE
708: ,PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE
709: ,PARTY_CATEGORY_CODE HZ_PARTIES.CATEGORY_CODE%TYPE
710: --
711: ,PARTY_SITE_ID HZ_PARTY_SITES.PARTY_SITE_ID%TYPE
712: ,PARTY_SITE_NUMBER HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE
713: ,PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE
714: --
715: ,INTF_PARTY_ID VARCHAR2(150)

Line 712: ,PARTY_SITE_NUMBER HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE

708: ,PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE
709: ,PARTY_CATEGORY_CODE HZ_PARTIES.CATEGORY_CODE%TYPE
710: --
711: ,PARTY_SITE_ID HZ_PARTY_SITES.PARTY_SITE_ID%TYPE
712: ,PARTY_SITE_NUMBER HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE
713: ,PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE
714: --
715: ,INTF_PARTY_ID VARCHAR2(150)
716: ,INTF_PARTY_NUMBER VARCHAR2(150)

Line 713: ,PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE

709: ,PARTY_CATEGORY_CODE HZ_PARTIES.CATEGORY_CODE%TYPE
710: --
711: ,PARTY_SITE_ID HZ_PARTY_SITES.PARTY_SITE_ID%TYPE
712: ,PARTY_SITE_NUMBER HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE
713: ,PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE
714: --
715: ,INTF_PARTY_ID VARCHAR2(150)
716: ,INTF_PARTY_NUMBER VARCHAR2(150)
717: ,INTF_PARTY_NAME VARCHAR2(150)

Line 4090: HZ_PARTY_SITES HPS

4086: hps.PARTY_SITE_NAME,
4087: hps.PARTY_SITE_NUMBER
4088: FROM
4089: HZ_PARTIES PRT,
4090: HZ_PARTY_SITES HPS
4091: WHERE
4092: prt.PARTY_ID = hps.PARTY_ID
4093: --start modified by abhaxen for 6689015 on 24-Jan-2008
4094: -- Added new filters to remove full table scans