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 714: ,PARTY_SITE_ID HZ_PARTY_SITES.PARTY_SITE_ID%TYPE

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

Line 715: ,PARTY_SITE_NUMBER HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE

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

Line 716: ,PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE

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

Line 4258: HZ_PARTY_SITES HPS

4254: hps.PARTY_SITE_NAME,
4255: hps.PARTY_SITE_NUMBER
4256: FROM
4257: HZ_PARTIES PRT,
4258: HZ_PARTY_SITES HPS
4259: WHERE
4260: prt.PARTY_ID = hps.PARTY_ID
4261: --start modified by abhaxen for 6689015 on 24-Jan-2008
4262: -- Added new filters to remove full table scans