APPS.JG_ZZ_AUDIT_AR_PKG dependencies on JG_ZZ_VAT_TRX_DETAILS

Line 45: Directly using jg_zz_vat_trx_details.billing_tp_site_id to joing with hps.party_site_id

41: l_precision NUMBER := 0;
42:
43: --JEBEVA17 Annual VAT Audit Report
44: /* Brathod, Updated the cursor to remove usage of hz_cust_account_sites by removing outer join.
45: Directly using jg_zz_vat_trx_details.billing_tp_site_id to joing with hps.party_site_id
46: */
47: CURSOR c_jgbevat IS
48: SELECT JZVTD.doc_seq_value BE_DOC_SEQ_VALUE
49: ,SUBSTR(JZVTD.billing_tp_name,1,25) CUSTOMER_NAME

Line 64: FROM jg_zz_vat_trx_details JZVTD

60: ,ROUND(NVL(JZVTD.taxable_amt_funcl_curr, taxable_amt)
61: +NVL(JZVTD.tax_amt_funcl_curr, tax_amt), l_precision) TOTAL_AMOUNT
62: ,ROUND(NVL(JZVTD.taxable_amt_funcl_curr, taxable_amt), l_precision) TAXABLE_AMOUNT
63: ,ROUND(NVL(JZVTD.tax_amt_funcl_curr, tax_amt), l_precision) TAX_AMOUNT
64: FROM jg_zz_vat_trx_details JZVTD
65: ,jg_zz_vat_rep_status JZVRS
66: ,hz_cust_acct_sites_all HZCAS
67: ,hz_party_sites HPS
68: ,hz_locations HZL

Line 104: FROM jg_zz_vat_trx_details JZVTD

100: ,JZVTD.trx_number DOC_NUMBER
101: ,JZVTD.tax_invoice_date TAX_DATE
102: ,JZVTD.accounting_date GL_DATE
103: ,NVL(JZVTD.taxable_amt_funcl_curr,taxable_amt) TAXABLE_AMOUNT
104: FROM jg_zz_vat_trx_details JZVTD
105: ,jg_zz_vat_rep_status JZVRS
106: ,ra_customer_trx_all RCTA
107: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
108: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id

Line 143: FROM jg_zz_vat_trx_details JZVTD

139: ,(NVL(JZVTD.taxable_amt_funcl_curr, taxable_amt)
140: +NVL(JZVTD.tax_amt_funcl_curr, tax_amt)) TOTAL_AMOUNT
141: ,NVL(JZVTD.taxable_amt_funcl_curr, taxable_amt) TAXABLE_AMOUNT
142: ,NVL(JZVTD.tax_amt_funcl_curr, tax_amt) TAX_AMOUNT
143: FROM jg_zz_vat_trx_details JZVTD
144: ,jg_zz_vat_rep_status JZVRS
145: ,hz_locations HZ
146: ,hz_party_sites HPS
147: ,ra_customer_trx_all RCTA

Line 167: lc_rep_entity_name jg_zz_vat_trx_details.rep_context_entity_name%TYPE;

163: FROM jg_zz_vat_trx_gt;
164:
165: l_rec_count NUMBER;
166: lc_curr_code VARCHAR2(50);
167: lc_rep_entity_name jg_zz_vat_trx_details.rep_context_entity_name%TYPE;
168: ln_legal_entity_id NUMBER;
169: ln_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
170: lc_company_name xle_registrations.registered_name%TYPE;
171: lc_registration_number xle_registrations.registration_number%TYPE;

Line 169: ln_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;

165: l_rec_count NUMBER;
166: lc_curr_code VARCHAR2(50);
167: lc_rep_entity_name jg_zz_vat_trx_details.rep_context_entity_name%TYPE;
168: ln_legal_entity_id NUMBER;
169: ln_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
170: lc_company_name xle_registrations.registered_name%TYPE;
171: lc_registration_number xle_registrations.registration_number%TYPE;
172: lc_country hz_locations.country%TYPE;
173: lc_address1 hz_locations.address1%TYPE;