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_REPORTS_PKG dependencies on HZ_PARTIES

Line 251: , Hz_Parties RAC_BILL_PARTY

247: Ra_Customer_Trx_all ract
248: , ra_batches_all bat
249: , Ra_Cust_Trx_Types_all ctt
250: , Hz_Cust_Accounts RAC_BILL
251: , Hz_Parties RAC_BILL_PARTY
252:
253: WHERE Customer_Trx_Id = P_Ar_Trx_Header_Id
254: AND ract.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
255: AND ract.org_id = ctt.org_id

Line 285: , Hz_Parties RAC_BILL_PARTY

281: Ra_Customer_Trx_all ract
282: , ra_batches_all bat
283: , Ra_Cust_Trx_Types_all ctt
284: , Hz_Cust_Accounts RAC_BILL
285: , Hz_Parties RAC_BILL_PARTY
286:
287: WHERE Customer_Trx_Id = P_Ar_Trx_Header_Id
288: AND ract.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
289: AND ract.org_id = ctt.org_id

Line 794: l_ar_customer_name hz_parties.party_name%TYPE;

790: l_ar_amount_disp VARCHAR2(50);
791: l_ar_taxamount NUMBER;
792: l_ar_taxamount_disp VARCHAR2(50);
793: l_ar_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
794: l_ar_customer_name hz_parties.party_name%TYPE;
795: l_ar_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;
796: l_ar_customer_bank_account VARCHAR2(360);
797: l_ar_customer_address VARCHAR2(4000);
798: l_ar_customer_address_phone VARCHAR2(4000);

Line 795: l_ar_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;

791: l_ar_taxamount NUMBER;
792: l_ar_taxamount_disp VARCHAR2(50);
793: l_ar_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
794: l_ar_customer_name hz_parties.party_name%TYPE;
795: l_ar_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;
796: l_ar_customer_bank_account VARCHAR2(360);
797: l_ar_customer_address VARCHAR2(4000);
798: l_ar_customer_address_phone VARCHAR2(4000);
799: l_ar_customer_phone hz_contact_points.phone_number%TYPE;

Line 897: ,hz_parties rac_bill_party

893: )
894: ) customer_address
895: FROM
896: ra_customer_trx_all rct
897: ,hz_parties rac_bill_party
898: ,hz_cust_accounts rac_bill
899: --,ap_bank_accounts apba
900: --,ap_bank_branches apb
901: ,hz_cust_site_uses_all su_bill

Line 3655: l_customer_name hz_parties.party_name%TYPE;

3651: , x_output OUT NOCOPY XMLTYPE
3652: )
3653: IS
3654: l_operating_unit hr_operating_units.name%TYPE;
3655: l_customer_name hz_parties.party_name%TYPE;
3656: l_primary_sales_name ra_salesreps_all.name%TYPE;
3657: l_customer_id hz_cust_accounts.cust_account_id%TYPE
3658: :=p_cust_name_id;
3659: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE;

Line 3751: ,hz_parties hp

3747: SELECT
3748: hp.party_name
3749: FROM
3750: hz_cust_accounts hca
3751: ,hz_parties hp
3752: WHERE hca.cust_account_id=l_customer_id
3753: AND hp.party_id=hca.party_id;
3754:
3755: CURSOR c_primary_salesrep_name IS

Line 4482: l_ar_customer_name hz_parties.party_name%TYPE;

4478: l_has_unmatched BOOLEAN;
4479: l_xml_output XMLTYPE;
4480: l_ar_trx_number ra_customer_trx_all.trx_number%TYPE;
4481: l_ar_trx_date ra_customer_trx_all.trx_date%TYPE;
4482: l_ar_customer_name hz_parties.party_name%TYPE;
4483: l_ar_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
4484: l_missing_artrx_seq NUMBER;
4485: l_gta_trx_number_missing VARCHAR2(2000);
4486: l_gt_invoice_number_missing VARCHAR2(2000);

Line 4516: ,hz_parties rac_bill_party

4512: FROM
4513: jmf_gta_trx_headers gta
4514: ,ra_customer_trx_all ct
4515: ,hz_cust_accounts rac_bill
4516: ,hz_parties rac_bill_party
4517: ,ra_cust_trx_line_gl_dist_all gd
4518: ,ra_batches_all rb
4519: WHERE gta.ra_trx_id=ct.customer_trx_id(+)
4520: AND rb.batch_id(+)=ct.batch_id