APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on HZ_CUST_ACCOUNTS

Line 3545: l_CUSTOMER_NUM_FROM HZ_CUST_ACCOUNTS.Account_Number%TYPE;

3541: )
3542: IS
3543: l_procedure_name VARCHAR2(30) := 'export_customers';
3544:
3545: l_CUSTOMER_NUM_FROM HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3546: l_CUSTOMER_NUM_TO HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3547: l_CUSTOMER_NAME_FROM HZ_PARTIES.Party_Name%TYPE;
3548: l_CUSTOMER_NAME_TO HZ_PARTIES.Party_Name%TYPE;
3549:

Line 3546: l_CUSTOMER_NUM_TO HZ_CUST_ACCOUNTS.Account_Number%TYPE;

3542: IS
3543: l_procedure_name VARCHAR2(30) := 'export_customers';
3544:
3545: l_CUSTOMER_NUM_FROM HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3546: l_CUSTOMER_NUM_TO HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3547: l_CUSTOMER_NAME_FROM HZ_PARTIES.Party_Name%TYPE;
3548: l_CUSTOMER_NAME_TO HZ_PARTIES.Party_Name%TYPE;
3549:
3550: l_CREATION_DATE_FROM HZ_CUST_ACCOUNTS.Creation_Date%TYPE;

Line 3550: l_CREATION_DATE_FROM HZ_CUST_ACCOUNTS.Creation_Date%TYPE;

3546: l_CUSTOMER_NUM_TO HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3547: l_CUSTOMER_NAME_FROM HZ_PARTIES.Party_Name%TYPE;
3548: l_CUSTOMER_NAME_TO HZ_PARTIES.Party_Name%TYPE;
3549:
3550: l_CREATION_DATE_FROM HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3551: l_CREATION_DATE_TO HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3552:
3553: l_customer_id HZ_CUST_ACCOUNTS.Cust_Account_Id%TYPE;
3554: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;

Line 3551: l_CREATION_DATE_TO HZ_CUST_ACCOUNTS.Creation_Date%TYPE;

3547: l_CUSTOMER_NAME_FROM HZ_PARTIES.Party_Name%TYPE;
3548: l_CUSTOMER_NAME_TO HZ_PARTIES.Party_Name%TYPE;
3549:
3550: l_CREATION_DATE_FROM HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3551: l_CREATION_DATE_TO HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3552:
3553: l_customer_id HZ_CUST_ACCOUNTS.Cust_Account_Id%TYPE;
3554: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3555: l_customer_name HZ_PARTIES.Party_Name%TYPE;

Line 3553: l_customer_id HZ_CUST_ACCOUNTS.Cust_Account_Id%TYPE;

3549:
3550: l_CREATION_DATE_FROM HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3551: l_CREATION_DATE_TO HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3552:
3553: l_customer_id HZ_CUST_ACCOUNTS.Cust_Account_Id%TYPE;
3554: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3555: l_customer_name HZ_PARTIES.Party_Name%TYPE;
3556: --l_taxpayer_id HZ_PARTIES.JGZZ_FISCAL_CODE%TYPE;
3557: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;

Line 3554: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;

3550: l_CREATION_DATE_FROM HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3551: l_CREATION_DATE_TO HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3552:
3553: l_customer_id HZ_CUST_ACCOUNTS.Cust_Account_Id%TYPE;
3554: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3555: l_customer_name HZ_PARTIES.Party_Name%TYPE;
3556: --l_taxpayer_id HZ_PARTIES.JGZZ_FISCAL_CODE%TYPE;
3557: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3558: l_party_id HZ_PARTIES.PARTY_ID%TYPE;

Line 3658: HZ_CUST_ACCOUNTS CUST

3654: --, CUST_PARTY.JGZZ_FISCAL_CODE
3655: , CUST_PARTY.ORGANIZATION_NAME_PHONETIC
3656: , CUST_PARTY.PARTY_ID
3657: FROM
3658: HZ_CUST_ACCOUNTS CUST
3659: , HZ_PARTIES CUST_PARTY
3660: WHERE cust.party_id = cust_party.party_id
3661: AND cust.account_number BETWEEN p_num_from AND p_num_to
3662: --AND cust_party.party_name BETWEEN p_name_from AND p_name_to--yao zhang delete for bug 8230998

Line 3807: HZ_CUST_ACCOUNTS CUST

3803: COUNT(cust.cust_account_id)
3804: INTO
3805: l_count
3806: FROM
3807: HZ_CUST_ACCOUNTS CUST
3808: , HZ_PARTIES CUST_PARTY
3809: WHERE cust.party_id = cust_party.party_id
3810: AND cust.account_number BETWEEN l_customer_num_from AND l_customer_num_to
3811: -- AND cust_party.party_name BETWEEN l_customer_name_from AND l_customer_name_to--yao zhang delete for bug 8230998