APPS.JG_ZZ_AUDIT_AR_PKG dependencies on JG_ZZ_VAT_TRX_DETAILS

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

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

Line 62: FROM jg_zz_vat_trx_details JZVTD

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

Line 102: FROM jg_zz_vat_trx_details JZVTD

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

Line 138: FROM jg_zz_vat_trx_details JZVTD

134: ,(NVL(JZVTD.taxable_amt_funcl_curr, taxable_amt)
135: +NVL(JZVTD.tax_amt_funcl_curr, tax_amt)) TOTAL_AMOUNT
136: ,NVL(JZVTD.taxable_amt_funcl_curr, taxable_amt) TAXABLE_AMOUNT
137: ,NVL(JZVTD.tax_amt_funcl_curr, tax_amt) TAX_AMOUNT
138: FROM jg_zz_vat_trx_details JZVTD
139: ,jg_zz_vat_rep_status JZVRS
140: ,hz_locations HZ
141: ,hz_party_sites HPS
142: ,ra_customer_trx_all RCTA

Line 162: lc_rep_entity_name jg_zz_vat_trx_details.rep_context_entity_name%TYPE;

158: FROM jg_zz_vat_trx_gt;
159:
160: l_rec_count NUMBER;
161: lc_curr_code VARCHAR2(50);
162: lc_rep_entity_name jg_zz_vat_trx_details.rep_context_entity_name%TYPE;
163: ln_legal_entity_id NUMBER;
164: ln_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
165: lc_company_name xle_registrations.registered_name%TYPE;
166: lc_registration_number xle_registrations.registration_number%TYPE;

Line 164: ln_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;

160: l_rec_count NUMBER;
161: lc_curr_code VARCHAR2(50);
162: lc_rep_entity_name jg_zz_vat_trx_details.rep_context_entity_name%TYPE;
163: ln_legal_entity_id NUMBER;
164: ln_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
165: lc_company_name xle_registrations.registered_name%TYPE;
166: lc_registration_number xle_registrations.registration_number%TYPE;
167: lc_country hz_locations.country%TYPE;
168: lc_address1 hz_locations.address1%TYPE;