APPS.OKL_OPEN_INTERFACE_PVT dependencies on HZ_PARTIES

Line 709: ,PARTY_ID HZ_PARTIES.PARTY_ID%TYPE

705: TYPE intf_party_rec_type IS RECORD (
706: CONTRACT_NUMBER OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE
707: ,LINE_NUMBER OKL_LINES_INTERFACE.LINE_NUMBER%TYPE
708: --
709: ,PARTY_ID HZ_PARTIES.PARTY_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: --

Line 710: ,PARTY_NUMBER HZ_PARTIES.PARTY_NUMBER%TYPE

706: CONTRACT_NUMBER OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE
707: ,LINE_NUMBER OKL_LINES_INTERFACE.LINE_NUMBER%TYPE
708: --
709: ,PARTY_ID HZ_PARTIES.PARTY_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

Line 711: ,PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE

707: ,LINE_NUMBER OKL_LINES_INTERFACE.LINE_NUMBER%TYPE
708: --
709: ,PARTY_ID HZ_PARTIES.PARTY_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

Line 712: ,PARTY_CATEGORY_CODE HZ_PARTIES.CATEGORY_CODE%TYPE

708: --
709: ,PARTY_ID HZ_PARTIES.PARTY_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

Line 4257: HZ_PARTIES PRT,

4253: hps.PARTY_SITE_ID,
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