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_CUST_ACCOUNTS

Line 3280: l_CUSTOMER_NUM_FROM HZ_CUST_ACCOUNTS.Account_Number%TYPE;

3276: )
3277: IS
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:

Line 3281: l_CUSTOMER_NUM_TO HZ_CUST_ACCOUNTS.Account_Number%TYPE;

3277: IS
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;

Line 3285: l_CREATION_DATE_FROM HZ_CUST_ACCOUNTS.Creation_Date%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:
3288: l_customer_id HZ_CUST_ACCOUNTS.Cust_Account_Id%TYPE;
3289: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;

Line 3286: l_CREATION_DATE_TO HZ_CUST_ACCOUNTS.Creation_Date%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:
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;

Line 3288: l_customer_id HZ_CUST_ACCOUNTS.Cust_Account_Id%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:
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;

Line 3289: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;

3285: l_CREATION_DATE_FROM HZ_CUST_ACCOUNTS.Creation_Date%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;

Line 3356: HZ_CUST_ACCOUNTS CUST

3352: --, CUST_PARTY.JGZZ_FISCAL_CODE
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

Line 3432: HZ_CUST_ACCOUNTS CUST

3428: COUNT(cust.cust_account_id)
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