[Home] [Help]
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
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
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)
337: AND HCSU.cust_acct_site_id = JZVTD.billing_tp_address_id
338: AND UPPER(HCSU.site_use_code) = 'LEGAL'
339: AND JZVTD.extract_source_ledger = 'AR'
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
543: AND JZVTD.trx_id = TRX.customer_trx_id
544: AND HL.location_id = TO_NUMBER(TRX.global_attribute2)
647: , hr_locations HL
648: -- , fnd_territories FT -- Bug 8485057: not necessary
649: , hz_cust_site_uses_all HCSU
650: , zx_lines_det_factors ZXDF
651: , ra_customer_trx TRX
652: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
653: AND JZVRS.reporting_status_id = JZVTD.reporting_status_id
654: AND JZVTD.extract_source_ledger = 'AR'
655: AND JZVRS.source = 'AR'
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
1255: AND HCSU.cust_acct_site_id = JZVTD.billing_tp_address_id
1256: AND UPPER(HCSU.site_use_code) = 'LEGAL'
1257: AND JZVTD.extract_source_ledger = 'AR'
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
1342: , ra_customer_trx_all trx
1343: WHERE JZVTD.billing_trading_partner_id = p_customer_id
1344: AND HCSU.cust_acct_site_id = JZVTD.billing_tp_address_id
1345: AND UPPER(HCSU.site_use_code) = 'LEGAL'
1346: AND JZVTD.extract_source_ledger = 'AR'
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
1400: , ra_customer_trx_all trx
1401: WHERE JZVTD.billing_trading_partner_id = p_customer_id
1402: AND HCSU.cust_acct_site_id = JZVTD.billing_tp_address_id
1403: AND UPPER(HCSU.site_use_code) = 'LEGAL'
1404: AND JZVTD.extract_source_ledger = 'AR'
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
1479: , ra_customer_trx_all trx
1480: WHERE JZVTD.billing_tp_taxpayer_id = p_declared_nif
1481: AND HCSU.cust_acct_site_id = JZVTD.billing_tp_address_id
1482: AND UPPER(HCSU.site_use_code) = 'LEGAL'
1483: AND JZVTD.extract_source_ledger = 'AR'
3485:
3486: lc_jgzz_modelo_query :=
3487: REPLACE( lc_jgzz_modelo_query
3488: , '$MODELO_TABLE_LIST$'
3489: ,' , hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca, ra_customer_trx_all trx, zx_lines_det_factors zxdf ');
3490:
3491: lc_jgzz_modelo_query :=
3492: REPLACE( lc_jgzz_modelo_query
3493: ,'$ADDRESS_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'')
4885: AND nvl(zxdf.document_sub_type,''X'') <> ''MOD340_EXCL''
4886: AND JZVRS.vat_reporting_entity_id = $P_VAT_REP_ENTITY_ID$