[Home] [Help]
454: NVL(JZVTD.tax_amt_funcl_curr, JZVTD.tax_amt)) ACCTD_TAX_NREC_AMT
455: ,JZVTD.tax_rate_vat_trx_type_desc VAT_TRT
456: ,NVL(JZVBA.taxable_box, '99') VAT_REPORT_BOX
457: ,NVL(JZVBA.tax_box, '99') TAX_BOX
458: FROM jg_zz_vat_trx_details JZVTD
459: , jg_zz_vat_rep_status JZVRS
460: , jg_zz_vat_box_allocs JZVBA
461: , jg_zz_vat_alloc_rules jzvar
462: WHERE JZVBA.PERIOD_TYPE = 'PERIODIC'
607: -- Bug 6238170 Start
608: --,JZVTD.tax_type_code TAX_TYPE_CODE
609: ,JZVTD.reporting_code TAX_TYPE_CODE
610: -- Bug 6238170 End
611: FROM jg_zz_vat_trx_details JZVTD
612: ,jg_zz_vat_rep_status JZVRS
613: ,jg_zz_vat_registers_b JZVRB
614: ,jg_zz_vat_doc_sequences JZVDS /* Bug#5235824 */
615: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
811: ,DECODE(JZVTD.reporting_code, cp_tax_tag , '^', NULL) EXEMPT_FLAG
812: ,DECODE(JZVTD.accounting_date, NULL, '*', NULL) INV_DIST_POSTED_FLAG
813: ,JZVTD.functional_currency_code FUNCTIONAL_CURRENCY_CODE
814: ,JZVTD.reporting_code TAX_TYPE_CODE
815: FROM jg_zz_vat_trx_details JZVTD
816: ,jg_zz_vat_rep_status JZVRS
817: ,jg_zz_vat_registers_b JZVRB
818: ,jg_zz_vat_doc_sequences JZVDS /* Bug#5235824 */
819: -- ,fnd_lookup_values_vl flv /* Bug#5235824 */
1020: ,JZVTD.tax_rate_id TAX_CODE_ID
1021: ,JZVTD.offset_tax_rate_code OFFSET_TAX_CODE_ID
1022: ,JZVTD.reporting_code LINE_TYPE
1023: ,JZVTD.trx_id TRX_ID
1024: FROM jg_zz_vat_trx_details JZVTD
1025: ,jg_zz_vat_rep_status JZVRS
1026: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1027: AND JZVRS.tax_calendar_period = P_PERIOD
1028: AND (JZVTD.trx_tax_balancing_segment = P_BALANCING_SEGMENT OR P_BALANCING_SEGMENT is null)
1147: ,JZVTD.bank_account_id BANK_ACCOUNT_ID
1148: ,JZVTD.offset_flag
1149: ,JZVTD.tax_recoverable_flag
1150: ,JZVTD.tax_amt
1151: FROM jg_zz_vat_trx_details JZVTD
1152: ,jg_zz_vat_rep_status JZVRS
1153: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1154: AND JZVRS.tax_calendar_period = P_PERIOD
1155: AND ( JZVTD.trx_tax_balancing_segment = P_BALANCING_SEGMENT OR P_BALANCING_SEGMENT is NULL )
1322: ,JZVTD.merchant_party_tax_reg_number AP_TAXABLE_MERCHANT_TAX_REG_NO
1323: ,JZVTD.extract_source_ledger EXTRACT_SOURCE_LEDGER
1324: ,JZVTD.actg_event_type_code AE_EVENT_TYPE_CODE
1325: ,JZVTD.trx_line_type TAXABLE_LINE_TYPE_CODE
1326: FROM jg_zz_vat_trx_details JZVTD
1327: ,jg_zz_vat_rep_status JZVRS
1328: ,jg_zz_vat_box_allocs JZVBA
1329: WHERE JZVRS.tax_calendar_period = P_PERIOD
1330: AND JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1467: BEGIN
1468: SELECT SUM(decode(JZVTD.tax_recoverable_flag, 'Y',
1469: nvl(JZVTD.tax_amt,JZVTD.tax_amt_funcl_curr),'N', 0 )) /* Bug#5235824 JZVTD.tax_amt_funcl_curr */
1470: INTO ln_tax_amt_funcl_curr
1471: FROM jg_zz_vat_trx_details JZVTD
1472: WHERE JZVTD.TRX_ID = P_TRX_ID
1473: AND JZVTD.extract_source_ledger in ('AP') /* AND JZVTD.posted_flag = 'P' Bug#5235824 */
1474: GROUP BY JZVTD.TRX_LINE_ID;
1475:
1487: BEGIN
1488: SELECT SUM (decode(JZVTD.tax_recoverable_flag, 'Y',
1489: nvl(JZVTD.taxable_amt,JZVTD.taxable_amt_funcl_curr), 'N', 0)) /* Bug#5235824 JZVTD.taxable_amt_funcl_curr */
1490: INTO ln_taxable_amt_funcl_curr
1491: FROM jg_zz_vat_trx_details JZVTD
1492: WHERE JZVTD.TRX_ID = P_TRX_ID
1493: AND JZVTD.extract_source_ledger = 'AP' /* AND JZVTD.posted_flag ='P' Bug#5235824 */
1494: GROUP BY JZVTD.trx_line_id;
1495:
1507: SELECT SUM(decode(JZVTD.tax_recoverable_flag, 'Y', nvl(JZVTD.tax_amt,JZVTD.tax_amt_funcl_curr),'N', 0 ))
1508: + SUM (decode(JZVTD.tax_recoverable_flag, 'Y', nvl(JZVTD.taxable_amt,JZVTD.taxable_amt_funcl_curr), 'N', 0))
1509: /* Bug#5235824. SUM (JZVTD.tax_amt_funcl_curr)+ SUM (JZVTD.taxable_amt_funcl_curr) */
1510: INTO ln_taxable_amt_funcl_curr
1511: FROM jg_zz_vat_trx_details JZVTD
1512: WHERE JZVTD.TRX_ID = P_TRX_ID
1513: AND JZVTD.extract_source_ledger = 'AP' /* AND JZVTD.posted_flag = 'P' Bug#5235824 */
1514: GROUP BY JZVTD.trx_line_id;
1515: