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_REP_STATUS

Line 77: FROM jg_zz_vat_rep_status JZVRS

73: , 0, JZVTD.tax_amt,
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

Line 82: FROM jg_zz_vat_rep_status JZRS

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
83: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
84: AND JZRS.source = 'AP')
85: AND JZVTD.extract_source_ledger ='AP'
86: AND JZVRS.source = 'AP'

Line 124: FROM jg_zz_vat_rep_status JZVRS

120: JZVTD.taxable_amt_funcl_curr)
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

Line 171: ,jg_zz_vat_rep_status JZVRS

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
175: ,ap_invoices_all API

Line 287: FROM jg_zz_vat_rep_status JZVRS

283: +
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

Line 297: FROM jg_zz_vat_rep_status JZRS

293: , zx_lines_det_factors zxdf
294:
295: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
296: AND JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
297: FROM jg_zz_vat_rep_status JZRS
298: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
299: AND JZRS.source = 'AR')
300: AND JZVTD.extract_source_ledger = 'AR'
301: AND JZVRS.source = 'AR'

Line 332: , jg_zz_vat_rep_status JZVRS

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
336: WHERE nvl(JZVTD.billing_trading_partner_id,1) = nvl(p_customer_id,1)

Line 643: FROM jg_zz_vat_rep_status JZVRS

639: -- 1 Property with land registry in Spain except 2
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

Line 1053: ,jg_zz_vat_rep_status JZVRS

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
1057: AND JZVTD.trx_type_mng = 'PREPAYMENT'

Line 1078: FROM JG_ZZ_VAT_REP_STATUS RPS1,

1074: */
1075: AND ( (P_REPORT_NAME = 'JEESPMOR' AND JZVRS.tax_calendar_period --= P_TAX_PERIOD
1076: in (
1077: SELECT RPS1.tax_calendar_period
1078: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1079: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1080: min(period_start_date) period_start_date
1081: From JG_ZZ_VAT_REP_STATUS
1082: Where vat_reporting_entity_id = p_vat_rep_entity_id

Line 1081: From JG_ZZ_VAT_REP_STATUS

1077: SELECT RPS1.tax_calendar_period
1078: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1079: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1080: min(period_start_date) period_start_date
1081: From JG_ZZ_VAT_REP_STATUS
1082: Where vat_reporting_entity_id = p_vat_rep_entity_id
1083: And tax_calendar_period = p_tax_period) RPS2,
1084: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1085: min(period_end_date) period_end_date

Line 1086: From JG_ZZ_VAT_REP_STATUS

1082: Where vat_reporting_entity_id = p_vat_rep_entity_id
1083: And tax_calendar_period = p_tax_period) RPS2,
1084: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1085: min(period_end_date) period_end_date
1086: From JG_ZZ_VAT_REP_STATUS
1087: Where vat_reporting_entity_id = p_vat_rep_entity_id
1088: And tax_calendar_period = p_tax_period_to) RPS3
1089: WHERE RPS1.vat_reporting_entity_id = p_vat_rep_entity_id
1090: AND RPS2.vat_reporting_entity_id = RPS1.vat_reporting_entity_id

Line 1127: ,jg_zz_vat_rep_status JZVRS

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
1131: ,ap_invoices_all API

Line 1166: FROM JG_ZZ_VAT_REP_STATUS RPS1,

1162: */
1163: AND ( (P_REPORT_NAME = 'JEESPMOR' AND JZVRS.tax_calendar_period --= P_TAX_PERIOD
1164: in (
1165: SELECT RPS1.tax_calendar_period
1166: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1167: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1168: min(period_start_date) period_start_date
1169: From JG_ZZ_VAT_REP_STATUS
1170: Where vat_reporting_entity_id = p_vat_rep_entity_id

Line 1169: From JG_ZZ_VAT_REP_STATUS

1165: SELECT RPS1.tax_calendar_period
1166: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1167: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1168: min(period_start_date) period_start_date
1169: From JG_ZZ_VAT_REP_STATUS
1170: Where vat_reporting_entity_id = p_vat_rep_entity_id
1171: And tax_calendar_period = p_tax_period) RPS2,
1172: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1173: min(period_end_date) period_end_date

Line 1174: From JG_ZZ_VAT_REP_STATUS

1170: Where vat_reporting_entity_id = p_vat_rep_entity_id
1171: And tax_calendar_period = p_tax_period) RPS2,
1172: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1173: min(period_end_date) period_end_date
1174: From JG_ZZ_VAT_REP_STATUS
1175: Where vat_reporting_entity_id = p_vat_rep_entity_id
1176: And tax_calendar_period = p_tax_period_to) RPS3
1177: WHERE RPS1.vat_reporting_entity_id = p_vat_rep_entity_id
1178: AND RPS2.vat_reporting_entity_id = RPS1.vat_reporting_entity_id

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 1287: FROM JG_ZZ_VAT_REP_STATUS RPS1,

1283: AND JZVRS.reporting_status_id = JZVTD.reporting_status_id
1284: AND ( (P_REPORT_NAME = 'JEESPMOR' AND JZVRS.tax_calendar_period --= P_TAX_PERIOD
1285: in (
1286: SELECT RPS1.tax_calendar_period
1287: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1288: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1289: min(period_start_date) period_start_date
1290: From JG_ZZ_VAT_REP_STATUS
1291: Where vat_reporting_entity_id = p_vat_rep_entity_id

Line 1290: From JG_ZZ_VAT_REP_STATUS

1286: SELECT RPS1.tax_calendar_period
1287: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1288: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1289: min(period_start_date) period_start_date
1290: From JG_ZZ_VAT_REP_STATUS
1291: Where vat_reporting_entity_id = p_vat_rep_entity_id
1292: And tax_calendar_period = p_tax_period) RPS2,
1293: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1294: min(period_end_date) period_end_date

Line 1295: From JG_ZZ_VAT_REP_STATUS

1291: Where vat_reporting_entity_id = p_vat_rep_entity_id
1292: And tax_calendar_period = p_tax_period) RPS2,
1293: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1294: min(period_end_date) period_end_date
1295: From JG_ZZ_VAT_REP_STATUS
1296: Where vat_reporting_entity_id = p_vat_rep_entity_id
1297: And tax_calendar_period = p_tax_period_to) RPS3
1298: WHERE RPS1.vat_reporting_entity_id = p_vat_rep_entity_id
1299: AND RPS2.vat_reporting_entity_id = RPS1.vat_reporting_entity_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 1367: FROM JG_ZZ_VAT_REP_STATUS RPS1,

1363: AND JZVRS.source = 'AR'
1364: AND JZVRS.reporting_status_id = JZVTD.reporting_status_id
1365: AND ( (P_REPORT_NAME = 'JEESPMOR' AND JZVRS.tax_calendar_period in (
1366: SELECT RPS1.tax_calendar_period
1367: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1368: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1369: min(period_start_date) period_start_date
1370: From JG_ZZ_VAT_REP_STATUS
1371: Where vat_reporting_entity_id = p_vat_rep_entity_id

Line 1370: From JG_ZZ_VAT_REP_STATUS

1366: SELECT RPS1.tax_calendar_period
1367: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1368: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1369: min(period_start_date) period_start_date
1370: From JG_ZZ_VAT_REP_STATUS
1371: Where vat_reporting_entity_id = p_vat_rep_entity_id
1372: And tax_calendar_period = p_tax_period) RPS2,
1373: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1374: min(period_end_date) period_end_date

Line 1375: From JG_ZZ_VAT_REP_STATUS

1371: Where vat_reporting_entity_id = p_vat_rep_entity_id
1372: And tax_calendar_period = p_tax_period) RPS2,
1373: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1374: min(period_end_date) period_end_date
1375: From JG_ZZ_VAT_REP_STATUS
1376: Where vat_reporting_entity_id = p_vat_rep_entity_id
1377: And tax_calendar_period = p_tax_period_to) RPS3
1378: WHERE RPS1.vat_reporting_entity_id = p_vat_rep_entity_id
1379: AND RPS2.vat_reporting_entity_id = RPS1.vat_reporting_entity_id

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 1425: FROM JG_ZZ_VAT_REP_STATUS RPS1,

1421: AND JZVRS.source = 'AR'
1422: AND JZVRS.reporting_status_id = JZVTD.reporting_status_id
1423: AND ( (P_REPORT_NAME = 'JEESPMOR' AND JZVRS.tax_calendar_period in (
1424: SELECT RPS1.tax_calendar_period
1425: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1426: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1427: min(period_start_date) period_start_date
1428: From JG_ZZ_VAT_REP_STATUS
1429: Where vat_reporting_entity_id = p_vat_rep_entity_id

Line 1428: From JG_ZZ_VAT_REP_STATUS

1424: SELECT RPS1.tax_calendar_period
1425: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1426: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1427: min(period_start_date) period_start_date
1428: From JG_ZZ_VAT_REP_STATUS
1429: Where vat_reporting_entity_id = p_vat_rep_entity_id
1430: And tax_calendar_period = p_tax_period) RPS2,
1431: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1432: min(period_end_date) period_end_date

Line 1433: From JG_ZZ_VAT_REP_STATUS

1429: Where vat_reporting_entity_id = p_vat_rep_entity_id
1430: And tax_calendar_period = p_tax_period) RPS2,
1431: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1432: min(period_end_date) period_end_date
1433: From JG_ZZ_VAT_REP_STATUS
1434: Where vat_reporting_entity_id = p_vat_rep_entity_id
1435: And tax_calendar_period = p_tax_period_to) RPS3
1436: WHERE RPS1.vat_reporting_entity_id = p_vat_rep_entity_id
1437: AND RPS2.vat_reporting_entity_id = RPS1.vat_reporting_entity_id

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 1699: FROM jg_zz_vat_rep_status JZVRS

1695: $PROPERTY_FLAG_SEL_COL$
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

Line 1705: FROM jg_zz_vat_rep_status JZRS

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
1705: FROM jg_zz_vat_rep_status JZRS
1706: WHERE JZRS.vat_reporting_entity_id = $P_VAT_REP_ENTITY_ID$
1707: AND JZRS.source IN ( ''AP'', ''AR'' ))
1708: AND JZVTD.extract_source_ledger IN ( ''AP'', ''AR'' )
1709: AND JZVRS.source IN ( ''AP'', ''AR'' )

Line 2036: FROM jg_zz_vat_rep_status JZVRS

2032: c_modelo_340_artax c_modelo_340_artax_type;
2033:
2034: Cursor C_End_Date(cp_tax_registration varchar2) Is
2035: Select max(JZVRS.period_end_date) period_end_date
2036: FROM jg_zz_vat_rep_status JZVRS
2037: WHERE JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
2038: AND JZVRS.tax_registration_number = cp_tax_registration
2039: AND JZVRS.tax_calendar_period = p_tax_period_to
2040: Group by JZVRS.tax_registration_number;

Line 2044: FROM JG_ZZ_VAT_REP_STATUS RPS1,

2040: Group by JZVRS.tax_registration_number;
2041:
2042: Cursor C_TAX_PERIODS Is
2043: SELECT RPS1.tax_calendar_period tax_calendar_period
2044: FROM JG_ZZ_VAT_REP_STATUS RPS1,
2045: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
2046: min(period_start_date) period_start_date
2047: From JG_ZZ_VAT_REP_STATUS
2048: Where vat_reporting_entity_id = p_vat_rep_entity_id

Line 2047: From JG_ZZ_VAT_REP_STATUS

2043: SELECT RPS1.tax_calendar_period tax_calendar_period
2044: FROM JG_ZZ_VAT_REP_STATUS RPS1,
2045: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
2046: min(period_start_date) period_start_date
2047: From JG_ZZ_VAT_REP_STATUS
2048: Where vat_reporting_entity_id = p_vat_rep_entity_id
2049: And tax_calendar_period = p_tax_period) RPS2,
2050: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
2051: min(period_end_date) period_end_date

Line 2052: From JG_ZZ_VAT_REP_STATUS

2048: Where vat_reporting_entity_id = p_vat_rep_entity_id
2049: And tax_calendar_period = p_tax_period) RPS2,
2050: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
2051: min(period_end_date) period_end_date
2052: From JG_ZZ_VAT_REP_STATUS
2053: Where vat_reporting_entity_id = p_vat_rep_entity_id
2054: And tax_calendar_period = p_tax_period_to) RPS3
2055: WHERE RPS1.vat_reporting_entity_id = p_vat_rep_entity_id
2056: AND RPS2.vat_reporting_entity_id = RPS1.vat_reporting_entity_id

Line 2662: FROM jg_zz_vat_rep_status JZVRS

2658: , DECODE( INSTR(zxdf.trx_business_category,''/'',1,3),0,''A'',
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

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 4414: FROM jg_zz_vat_rep_status JZRS

4410: OR substr(jzvtd.document_sub_type,1,6) = ''MOD340'')
4411: AND nvl(jzvtd.document_sub_type,''X'') <> ''MOD340_EXCL''
4412: AND JZVRS.vat_reporting_entity_id = $P_VAT_REP_ENTITY_ID$
4413: AND JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
4414: FROM jg_zz_vat_rep_status JZRS
4415: WHERE JZRS.vat_reporting_entity_id = $P_VAT_REP_ENTITY_ID$
4416: AND JZRS.source = ''AP'' )
4417: AND $FILTER_KEY$ $FILTER_OPER$ $FILTER_VALUE$
4418: $340_PERIOD_KEY$ $340_PERIOD_KEY_FROM$ $340_PERIOD_OPER$ $340_PERIOD_KEY_TO$

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 4888: FROM jg_zz_vat_rep_status JZRS

4884: OR substr(zxdf.document_sub_type,1,6) = ''MOD340'')
4885: AND nvl(zxdf.document_sub_type,''X'') <> ''MOD340_EXCL''
4886: AND JZVRS.vat_reporting_entity_id = $P_VAT_REP_ENTITY_ID$
4887: AND JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
4888: FROM jg_zz_vat_rep_status JZRS
4889: WHERE JZRS.vat_reporting_entity_id = $P_VAT_REP_ENTITY_ID$
4890: AND JZRS.source = ''AR'' )
4891: AND $FILTER_KEY$ $FILTER_OPER$ $FILTER_VALUE$
4892: $340_PERIOD_KEY$ $340_PERIOD_KEY_FROM$ $340_PERIOD_OPER$ $340_PERIOD_KEY_TO$