[Home] [Help]
277: -- , ra_batches_all bat
278: ,RA_BATCH_SOURCES_ALL bas
279: , Ra_Cust_Trx_Types_all ctt
280: , Hz_Cust_Accounts RAC_BILL
281: , Hz_Parties RAC_BILL_PARTY
282: -- added by Allen Yang 24-Sep-2009 for bug 8920326
283: ----------------------------------------------------
284: , AR_LOOKUPS al
285: ----------------------------------------------------
332: -- , ra_batches_all bat
333: ,RA_BATCH_SOURCES_ALL bas
334: , Ra_Cust_Trx_Types_all ctt
335: , Hz_Cust_Accounts RAC_BILL
336: , Hz_Parties RAC_BILL_PARTY
337: -- added by Allen Yang 24-Sep-2009 for bug 8920326
338: -----------------------------------------------------
339: , AR_LOOKUPS al
340: -----------------------------------------------------
856: l_ar_amount_disp VARCHAR2(50);
857: l_ar_taxamount NUMBER;
858: l_ar_taxamount_disp VARCHAR2(50);
859: l_ar_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
860: l_ar_customer_name hz_parties.party_name%TYPE;
861: l_ar_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;
862: l_ar_customer_bank_account VARCHAR2(360);
863: l_ar_customer_address VARCHAR2(4000);
864: l_ar_customer_address_phone VARCHAR2(4000);
857: l_ar_taxamount NUMBER;
858: l_ar_taxamount_disp VARCHAR2(50);
859: l_ar_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
860: l_ar_customer_name hz_parties.party_name%TYPE;
861: l_ar_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;
862: l_ar_customer_bank_account VARCHAR2(360);
863: l_ar_customer_address VARCHAR2(4000);
864: l_ar_customer_address_phone VARCHAR2(4000);
865: l_ar_customer_phone hz_contact_points.phone_number%TYPE;
965: FT_BILL.TERRITORY_SHORT_NAME),
966: RAA_BILL_LOC.Address_Lines_Phonetic)) customer_address
967: FROM
968: ra_customer_trx_all rct
969: ,hz_parties rac_bill_party
970: ,hz_cust_accounts rac_bill
971: --,ap_bank_accounts apba
972: --,ap_bank_branches apb
973: ,hz_cust_site_uses_all su_bill
3830: , x_output OUT NOCOPY XMLTYPE
3831: )
3832: IS
3833: l_operating_unit hr_operating_units.name%TYPE;
3834: l_customer_name hz_parties.party_name%TYPE;
3835: l_primary_sales_name ra_salesreps_all.name%TYPE;
3836: l_customer_id hz_cust_accounts.cust_account_id%TYPE
3837: :=p_cust_name_id;
3838: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3930: SELECT
3931: hp.party_name
3932: FROM
3933: hz_cust_accounts hca
3934: ,hz_parties hp
3935: WHERE hca.cust_account_id=l_customer_id
3936: AND hp.party_id=hca.party_id;
3937:
3938: CURSOR c_primary_salesrep_name IS
4682: l_has_unmatched BOOLEAN;
4683: l_xml_output XMLTYPE;
4684: l_ar_trx_number ra_customer_trx_all.trx_number%TYPE;
4685: l_ar_trx_date ra_customer_trx_all.trx_date%TYPE;
4686: l_ar_customer_name hz_parties.party_name%TYPE;
4687: l_ar_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
4688: l_missing_artrx_seq NUMBER;
4689: l_gta_trx_number_missing VARCHAR2(2000);
4690: l_gt_invoice_number_missing VARCHAR2(2000);
4717: FROM
4718: ar_gta_trx_headers gta
4719: ,ra_customer_trx_all ct
4720: ,hz_cust_accounts rac_bill
4721: ,hz_parties rac_bill_party
4722: ,ra_cust_trx_line_gl_dist_all gd
4723: ,ra_batches_all rb
4724: WHERE gta.ra_trx_id=ct.customer_trx_id(+)
4725: AND rb.batch_id(+)=ct.batch_id