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.JMF_GTA_TXT_OPERATOR_PROC dependencies on HZ_PARTIES

Line 3282: l_CUSTOMER_NAME_FROM HZ_PARTIES.Party_Name%TYPE;

3278: l_procedure_name VARCHAR2(30) := 'export_customers';
3279:
3280: l_CUSTOMER_NUM_FROM HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3281: l_CUSTOMER_NUM_TO HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3282: l_CUSTOMER_NAME_FROM HZ_PARTIES.Party_Name%TYPE;
3283: l_CUSTOMER_NAME_TO HZ_PARTIES.Party_Name%TYPE;
3284:
3285: l_CREATION_DATE_FROM HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3286: l_CREATION_DATE_TO HZ_CUST_ACCOUNTS.Creation_Date%TYPE;

Line 3283: l_CUSTOMER_NAME_TO HZ_PARTIES.Party_Name%TYPE;

3279:
3280: l_CUSTOMER_NUM_FROM HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3281: l_CUSTOMER_NUM_TO HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3282: l_CUSTOMER_NAME_FROM HZ_PARTIES.Party_Name%TYPE;
3283: l_CUSTOMER_NAME_TO HZ_PARTIES.Party_Name%TYPE;
3284:
3285: l_CREATION_DATE_FROM HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3286: l_CREATION_DATE_TO HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3287:

Line 3290: l_customer_name HZ_PARTIES.Party_Name%TYPE;

3286: l_CREATION_DATE_TO HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3287:
3288: l_customer_id HZ_CUST_ACCOUNTS.Cust_Account_Id%TYPE;
3289: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3290: l_customer_name HZ_PARTIES.Party_Name%TYPE;
3291: --l_taxpayer_id HZ_PARTIES.JGZZ_FISCAL_CODE%TYPE;
3292: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3293: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
3294: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;

Line 3291: --l_taxpayer_id HZ_PARTIES.JGZZ_FISCAL_CODE%TYPE;

3287:
3288: l_customer_id HZ_CUST_ACCOUNTS.Cust_Account_Id%TYPE;
3289: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3290: l_customer_name HZ_PARTIES.Party_Name%TYPE;
3291: --l_taxpayer_id HZ_PARTIES.JGZZ_FISCAL_CODE%TYPE;
3292: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3293: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
3294: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3295:

Line 3292: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;

3288: l_customer_id HZ_CUST_ACCOUNTS.Cust_Account_Id%TYPE;
3289: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3290: l_customer_name HZ_PARTIES.Party_Name%TYPE;
3291: --l_taxpayer_id HZ_PARTIES.JGZZ_FISCAL_CODE%TYPE;
3292: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3293: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
3294: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3295:
3296: l_phone_num Hz_Contact_Points.Phone_Number%TYPE;

Line 3293: l_party_id HZ_PARTIES.PARTY_ID%TYPE;

3289: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3290: l_customer_name HZ_PARTIES.Party_Name%TYPE;
3291: --l_taxpayer_id HZ_PARTIES.JGZZ_FISCAL_CODE%TYPE;
3292: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3293: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
3294: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3295:
3296: l_phone_num Hz_Contact_Points.Phone_Number%TYPE;
3297: l_currency_code JMF_GTA_SYSTEM_PARAMETERS_ALL.Gt_Currency_Code%TYPE;

Line 3294: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;

3290: l_customer_name HZ_PARTIES.Party_Name%TYPE;
3291: --l_taxpayer_id HZ_PARTIES.JGZZ_FISCAL_CODE%TYPE;
3292: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3293: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
3294: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3295:
3296: l_phone_num Hz_Contact_Points.Phone_Number%TYPE;
3297: l_currency_code JMF_GTA_SYSTEM_PARAMETERS_ALL.Gt_Currency_Code%TYPE;
3298: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE;

Line 3357: , HZ_PARTIES CUST_PARTY

3353: , CUST_PARTY.ORGANIZATION_NAME_PHONETIC
3354: , CUST_PARTY.PARTY_ID
3355: FROM
3356: HZ_CUST_ACCOUNTS CUST
3357: , HZ_PARTIES CUST_PARTY
3358: WHERE cust.party_id = cust_party.party_id
3359: AND cust.account_number BETWEEN p_num_from AND p_num_to
3360: AND cust_party.party_name BETWEEN p_name_from AND p_name_to
3361: AND cust.creation_date BETWEEN p_create_from AND p_create_to

Line 3433: , HZ_PARTIES CUST_PARTY

3429: INTO
3430: l_count
3431: FROM
3432: HZ_CUST_ACCOUNTS CUST
3433: , HZ_PARTIES CUST_PARTY
3434: WHERE cust.party_id = cust_party.party_id
3435: AND cust.account_number BETWEEN l_customer_num_from AND l_customer_num_to
3436: AND cust_party.party_name BETWEEN l_customer_name_from AND l_customer_name_to
3437: AND cust.creation_date BETWEEN l_creation_date_from AND l_creation_date_to