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.JE_ES_MODELO_EXT_PKG dependencies on JG_ZZ_VAT_TRX_DETAILS

Line 26: jg_zz_vat_trx_details.billing_tp_address_id (value passed in parameter p_party_site_id) is actually a

22:
23: /** author: brathod
24: Modified following cursor to refer ap_supplier_sites_all to retrieve supplier address.
25: Cursor was wrongly refering to hz_party_sites_all and hz_locations as
26: jg_zz_vat_trx_details.billing_tp_address_id (value passed in parameter p_party_site_id) is actually a
27: supplier_site_id and not party_site_id. Please refer bug#5031773
28: */
29: CURSOR c_get_address IS
30: SELECT DECODE(p_modelo,'415',DECODE(SUBSTR(assa.country, 1, 25)

Line 78: , jg_zz_vat_trx_details JZVTD

74: JZVTD.tax_amt_funcl_curr)) SUM_TAXABLE_AMT_QTR,
75: decode(to_char(JZVTD.gl_date,'MM'),'01','1T','02','1T','03','1T','04','2T','05','2T','06','2T','07','3T','08','3T','09','3T','10','4T','11','4T','12','4T') QUARTER_NUM
76:
77: FROM jg_zz_vat_rep_status JZVRS
78: , jg_zz_vat_trx_details JZVTD
79: , AP_SUPPLIER_SITES_ALL APSS, AP_SUPPLIERS APS, ZX_LINES_DET_FACTORS ZXDF ,AP_INVOICES_ALL API
80: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
81: AND JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
82: FROM jg_zz_vat_rep_status JZRS

Line 125: , jg_zz_vat_trx_details JZVTD

121: )) sum_taxable_amt_qtr,
122: decode(to_char(JZVTD.gl_date,'MM'),'01','1T','02','1T','03','1T','04','2T','05','2T','06','2T','07','3T','08','3T','09','3T','10','4T','11','4T','12','4T') QUARTER_NUM
123:
124: FROM jg_zz_vat_rep_status JZVRS
125: , jg_zz_vat_trx_details JZVTD
126: , ap_suppliers aps
127: , ap_supplier_sites_all apss
128: , zx_lines_det_factors zxdf
129: , ap_invoices_all api

Line 170: FROM jg_zz_vat_trx_details JZVTD

166: )
167: , g_cur_precision)
168: ) prepay_applied_Qtr,
169: decode(to_char(JZVTD.gl_date,'MM'),'01','1T','02','1T','03','1T','04','2T','05','2T','06','2T','07','3T','08','3T','09','3T','10','4T','11','4T','12','4T') QUARTER_NUM
170: FROM jg_zz_vat_trx_details JZVTD
171: ,jg_zz_vat_rep_status JZVRS
172: ,ap_invoice_distributions AID
173: ,ap_invoice_distributions PRE
174: ,hz_parties HP

Line 288: , jg_zz_vat_trx_details JZVTD

284: SUM(DECODE(NVL(trx.global_attribute12, 'N'),'Y', NVL(JZVTD.tax_amt_funcl_curr, 0),0)) TRANSMISSION_PROP_AMT_QTR
285:
286: ,decode(to_char(jzvtd.gl_date,'MM'),'01','1T','02','1T','03','1T','04','2T','05','2T','06','2T','07','3T','08','3T','09','3T','10','4T','11','4T','12','4T') QUARTER_NUM
287: FROM jg_zz_vat_rep_status JZVRS
288: , jg_zz_vat_trx_details JZVTD
289: , hz_cust_site_uses_all hzcsu
290: , hz_cust_acct_sites_all hzcas
291: , hz_cust_accounts hzca
292: , ra_customer_trx_all trx

Line 331: FROM jg_zz_vat_trx_details JZVTD

327: cursor arrenda_qtr is
328: select SUM(DECODE(JZVTD.TAX_LINE_NUMBER, '1', NVL(JZVTD.taxable_amt_funcl_curr, 0),0))
329: + SUM(NVL(JZVTD.tax_amt_funcl_curr, 0)) arrenda_amt_qtr
330: ,decode(to_char(jzvtd.gl_date,'MM'),'01','1T','02','1T','03','1T','04','2T','05','2T','06','2T','07','3T','08','3T','09','3T','10','4T','11','4T','12','4T') QUARTER_NUM
331: FROM jg_zz_vat_trx_details JZVTD
332: , jg_zz_vat_rep_status JZVRS
333: , hz_cust_site_uses_all HCSU
334: , zx_lines_det_factors ZXDF
335: , ra_customer_trx_all trx

Line 538: jg_zz_vat_trx_details JZVTD

534: 1)),
535: -- 4 Property located outside Spain
536: 4) property_location_code
537: FROM
538: jg_zz_vat_trx_details JZVTD
539: , hr_locations HL
540: , ra_customer_trx TRX
541: , zx_lines_det_factors ZXDF
542: where JZVTD.trx_id = p_trx_id

Line 644: , jg_zz_vat_trx_details JZVTD

640: 1)),
641: -- 4 Property located outside Spain
642: 4) property_location_code
643: FROM jg_zz_vat_rep_status JZVRS
644: , jg_zz_vat_trx_details JZVTD
645: , hz_cust_acct_sites_all HCAS
646: , hz_party_sites HPS
647: , hr_locations HL
648: -- , fnd_territories FT -- Bug 8485057: not necessary

Line 1052: FROM jg_zz_vat_trx_details JZVTD

1048: ))
1049: - NVL(AID.prepay_amount_remaining, 0 )* -1
1050: )
1051: INTO V_PREPAY_APPLIED
1052: FROM jg_zz_vat_trx_details JZVTD
1053: ,jg_zz_vat_rep_status JZVRS
1054: ,ap_invoice_distributions AID
1055: WHERE JZVRS.reporting_status_id = JZVTD.reporting_status_id
1056: AND JZVTD.billing_trading_partner_id = p_vendor_id

Line 1126: FROM jg_zz_vat_trx_details JZVTD

1122: )
1123: , g_cur_precision)
1124: )
1125: INTO V_PREPAY_APPLIED
1126: FROM jg_zz_vat_trx_details JZVTD
1127: ,jg_zz_vat_rep_status JZVRS
1128: ,ap_invoice_distributions AID
1129: ,ap_invoice_distributions PRE
1130: ,hz_parties HP

Line 1250: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS

1246: the total transaction amount only once, not for each tax line */
1247: SUM(DECODE(JZVTD.TAX_LINE_NUMBER, '1', NVL(JZVTD.taxable_amt_funcl_curr, 0),0))
1248: + SUM(NVL(JZVTD.tax_amt_funcl_curr, 0))
1249: INTO v_arrenda_amount
1250: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS
1251: , hz_cust_site_uses_all HCSU
1252: , zx_lines_det_factors ZXDF -- Bug 8485057
1253: , ra_customer_trx_all trx
1254: WHERE JZVTD.billing_trading_partner_id = p_customer_id

Line 1337: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS

1333: SELECT SUM(NVL(DECODE(CR.type,'MISC', 0
1334: ,DECODE(RA.status,'APP',RA.AMOUNT_APPLIED,0)),0))
1335: / COUNT(JZVTD.trx_id)
1336: INTO v_cash_received_amount
1337: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS
1338: , hz_cust_site_uses_all HCSU
1339: , zx_lines_det_factors ZXDF
1340: , ar_receivable_applications_all RA
1341: , ar_cash_receipts_all CR

Line 1395: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS

1391: SELECT SUM(NVL(DECODE(CR.type,'MISC', 0
1392: ,DECODE(RA.status,'APP',RA.AMOUNT_APPLIED,0)),0))
1393: / COUNT(JZVTD.trx_id)
1394: INTO v_cash_received_amount
1395: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS
1396: , hz_cust_site_uses_all HCSU
1397: , zx_lines_det_factors ZXDF
1398: , ar_receivable_applications_all RA
1399: , ar_cash_receipts_all CR

Line 1474: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS

1470: SELECT SUM(NVL(DECODE(CR.type,'MISC', 0
1471: ,DECODE(RA.status,'APP',RA.AMOUNT_APPLIED,0)),0))
1472: / COUNT(JZVTD.trx_id)
1473: INTO v_cash_received_amount
1474: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS
1475: , hz_cust_site_uses_all HCSU
1476: , zx_lines_det_factors ZXDF
1477: , ar_receivable_applications_all RA
1478: , ar_cash_receipts_all CR

Line 1700: , jg_zz_vat_trx_details JZVTD

1696: $TRANS_CODE_SEL_COL$
1697: $TRANSMISSION_PROPERTY_AMT$
1698: $YEAR_OF_AMTS_RECEIVED_CASH$
1699: FROM jg_zz_vat_rep_status JZVRS
1700: , jg_zz_vat_trx_details JZVTD
1701: $MODELO_TABLE_LIST$
1702: WHERE JZVRS.vat_reporting_entity_id = $P_VAT_REP_ENTITY_ID$
1703: --AND JZVRS.reporting_status_id = JZVTD.reporting_status_id
1704: AND JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS

Line 1906: lc_taxpayer_id jg_zz_vat_trx_details.billing_tp_taxpayer_id%TYPE;

1902: lc_prev_vat_code VARCHAR2(400) :='';
1903: lc_count NUMBER := 0;
1904: lc_reporting_mode VARCHAR2(240);
1905: --
1906: lc_taxpayer_id jg_zz_vat_trx_details.billing_tp_taxpayer_id%TYPE;
1907: lc_company_name xle_registrations.registered_name%TYPE;
1908: lc_registration_number xle_registrations.registration_number%TYPE;
1909: lc_country hr_locations.country%TYPE;
1910: lc_address1 hr_locations.address_line_1%TYPE;

Line 1995: lc_foreign_taxpayer_id jg_zz_vat_trx_details.billing_tp_taxpayer_id%TYPE;

1991: ln_transmission_prop_amt_q4 NUMBER;
1992: ln_cash_received_amount NUMBER;
1993: -- Added for Modelo 340
1994: lc_key_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1995: lc_foreign_taxpayer_id jg_zz_vat_trx_details.billing_tp_taxpayer_id%TYPE;
1996: lc_book_type VARCHAR2(1);
1997: lc_transaction_code VARCHAR2(1);
1998: ld_invoice_date JG_ZZ_VAT_TRX_GT.jg_info_d1%TYPE;
1999: ld_trx_date JG_ZZ_VAT_TRX_GT.jg_info_d1%TYPE;

Line 2663: , jg_zz_vat_trx_details JZVTD

2659: substr(zxdf.trx_business_category,length(zxdf.trx_business_category),1)) TIPO
2660: , NULL TRANSMISSION_PROPERTY_AMT
2661: , NULL YEAR_OF_AMTS_RECEIVED_CASH
2662: FROM jg_zz_vat_rep_status JZVRS
2663: , jg_zz_vat_trx_details JZVTD
2664: , ap_suppliers aps
2665: , ap_supplier_sites_all apss
2666: , ap_invoices_all API
2667: , zx_lines_det_factors zxdf

Line 4406: FROM jg_zz_vat_trx_details jzvtd, jg_zz_vat_rep_status jzvrs

4402: SUM(decode(jzvtd.tax_recoverable_flag, ''Y'',
4403: nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt ))) DEDUCTABLE_AMOUNT,
4404: jzvtd.tax_rate TAX_RATE,
4405: APSS.VENDOR_SITE_ID
4406: FROM jg_zz_vat_trx_details jzvtd, jg_zz_vat_rep_status jzvrs
4407: , AP_SUPPLIER_SITES_ALL APSS, AP_SUPPLIERS APS, AP_INVOICES_ALL API,
4408: zx_lines_det_factors zxdf
4409: WHERE (substr(zxdf.trx_business_category,(instr(zxdf.trx_business_category,''MOD'',1,1)+3),3) in (''347'',''349'',''415'')
4410: OR substr(jzvtd.document_sub_type,1,6) = ''MOD340'')

Line 4511: FROM jg_zz_vat_trx_details jzvtd, jg_zz_vat_rep_status jzvrs

4507: SUM(decode(jzvtd.tax_recoverable_flag, ''Y'',
4508: nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt ))) DEDUCTABLE_AMOUNT,
4509: jzvtd.tax_rate TAX_RATE,
4510: APSS.VENDOR_SITE_ID
4511: FROM jg_zz_vat_trx_details jzvtd, jg_zz_vat_rep_status jzvrs
4512: , AP_SUPPLIER_SITES_ALL APSS, AP_SUPPLIERS APS, AP_INVOICES_ALL API,
4513: zx_lines_det_factors zxdf
4514: WHERE (substr(zxdf.trx_business_category,(instr(zxdf.trx_business_category,''MOD'',1,1)+3),3) in (''347'',''349'',''415'')
4515: OR substr(jzvtd.document_sub_type,1,6) = ''MOD340'')

Line 4880: FROM jg_zz_vat_trx_details jzvtd, jg_zz_vat_rep_status jzvrs

4876: , jzvtd.taxable_amt_funcl_curr) TAXABLE_AMOUNT,
4877: hzcsu.cust_acct_site_id
4878: $YEAR_AMT_RECEIVED_CASH$
4879: $TRANSMISSION_PROPERTY$
4880: FROM jg_zz_vat_trx_details jzvtd, jg_zz_vat_rep_status jzvrs
4881: , hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca
4882: , ZX_LINES_DET_FACTORS zxdf, ra_customer_trx_all trx
4883: WHERE (substr(zxdf.trx_business_category,(instr(zxdf.trx_business_category,''MOD'',1,1)+3),3) in (''347'',''349'',''415'')
4884: OR substr(zxdf.document_sub_type,1,6) = ''MOD340'')

Line 4948: FROM jg_zz_vat_trx_details

4944: 0, tax_amt ,
4945: NULL, tax_amt,
4946: tax_amt_funcl_curr), 0)) TAX_AMOUNT,
4947: tax_rate
4948: FROM jg_zz_vat_trx_details
4949: WHERE trx_line_id = :p_trx_line_id
4950: AND trx_id = :p_trx_id
4951: AND extract_source_ledger = ''AR''
4952: AND reporting_status_id = :p_reporting_status_id