APPS.OKL_OPEN_INTERFACE_PVT dependencies on HZ_PARTIES

Line 706: ,PARTY_ID HZ_PARTIES.PARTY_ID%TYPE

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

Line 707: ,PARTY_NUMBER HZ_PARTIES.PARTY_NUMBER%TYPE

703: CONTRACT_NUMBER OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE
704: ,LINE_NUMBER OKL_LINES_INTERFACE.LINE_NUMBER%TYPE
705: --
706: ,PARTY_ID HZ_PARTIES.PARTY_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

Line 708: ,PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE

704: ,LINE_NUMBER OKL_LINES_INTERFACE.LINE_NUMBER%TYPE
705: --
706: ,PARTY_ID HZ_PARTIES.PARTY_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

Line 709: ,PARTY_CATEGORY_CODE HZ_PARTIES.CATEGORY_CODE%TYPE

705: --
706: ,PARTY_ID HZ_PARTIES.PARTY_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

Line 4089: HZ_PARTIES PRT,

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