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

Line 519: FROM jg_zz_vat_trx_details JZVTD

515: ORDER BY JZVTD.tax_line_id,JZVBA.allocation_rule_id,JZVTD.cancel_flag,JZVTD.taxable_item_source_id,JZVTD.taxable_amt DESC NULLS LAST)
516: PREV_AMT
517: ,DECODE(JZVTD.OFFSET_FLAG,'N',DECODE(NVL(JZVTD.taxable_amt_funcl_curr,0),0
518: ,JZVTD.taxable_amt,JZVTD.taxable_amt_funcl_curr),0) TAXABLE_AMT_FOR_LAG
519: FROM jg_zz_vat_trx_details JZVTD
520: , jg_zz_vat_rep_status JZVRS
521: , jg_zz_vat_box_allocs JZVBA
522: , jg_zz_vat_alloc_rules jzvar
523: WHERE JZVBA.PERIOD_TYPE = 'PERIODIC'

Line 728: FROM jg_zz_vat_trx_details JZVTD

724: --,JZVTD.tax_type_code TAX_TYPE_CODE
725: ,JZVTD.reporting_code TAX_TYPE_CODE
726: -- Bug 6238170 End
727: ,NVL(JZVTD.offset_tax_rate_code,'N') OFFSET_TAX_RATE_CODE
728: FROM jg_zz_vat_trx_details JZVTD
729: ,jg_zz_vat_rep_status JZVRS
730: ,jg_zz_vat_registers_b JZVRB
731: ,jg_zz_vat_doc_sequences JZVDS /* Bug#5235824 */
732: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID

Line 961: FROM jg_zz_vat_trx_details JZVTD

957: ,DECODE(JZVTD.accounting_date, NULL, '*', NULL) INV_DIST_POSTED_FLAG
958: ,JZVTD.functional_currency_code FUNCTIONAL_CURRENCY_CODE
959: ,JZVTD.reporting_code TAX_TYPE_CODE
960: ,NVL(JZVTD.offset_tax_rate_code,'N') OFFSET_TAX_RATE_CODE
961: FROM jg_zz_vat_trx_details JZVTD
962: ,jg_zz_vat_rep_status JZVRS
963: ,jg_zz_vat_registers_b JZVRB
964: ,jg_zz_vat_doc_sequences JZVDS /* Bug#5235824 */
965: -- ,fnd_lookup_values_vl flv /* Bug#5235824 */

Line 1179: FROM jg_zz_vat_trx_details JZVTD

1175: ,JZVTD.tax_rate_id TAX_CODE_ID
1176: ,JZVTD.offset_tax_rate_code OFFSET_TAX_CODE_ID
1177: ,JZVTD.reporting_code LINE_TYPE
1178: ,JZVTD.trx_id TRX_ID
1179: FROM jg_zz_vat_trx_details JZVTD
1180: ,jg_zz_vat_rep_status JZVRS
1181: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1182: -- Bug8267272 Start
1183: AND JZVRS.tax_calendar_period IN (SELECT RPS1.tax_calendar_period

Line 1327: FROM jg_zz_vat_trx_details JZVTD

1323: ,JZVTD.bank_account_id BANK_ACCOUNT_ID
1324: ,JZVTD.offset_flag
1325: ,JZVTD.tax_recoverable_flag
1326: ,nvl(JZVTD.tax_amt_funcl_curr,JZVTD.tax_amt) tax_amt
1327: FROM jg_zz_vat_trx_details JZVTD
1328: ,jg_zz_vat_rep_status JZVRS
1329: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1330: -- Bug8267272 Start
1331: AND JZVRS.tax_calendar_period IN (SELECT RPS1.tax_calendar_period

Line 1522: FROM jg_zz_vat_trx_details JZVTD

1518: ,JZVTD.merchant_party_tax_reg_number AP_TAXABLE_MERCHANT_TAX_REG_NO
1519: ,JZVTD.extract_source_ledger EXTRACT_SOURCE_LEDGER
1520: ,JZVTD.actg_event_type_code AE_EVENT_TYPE_CODE
1521: ,JZVTD.trx_line_type TAXABLE_LINE_TYPE_CODE
1522: FROM jg_zz_vat_trx_details JZVTD
1523: ,jg_zz_vat_rep_status JZVRS
1524: ,jg_zz_vat_box_allocs JZVBA
1525: WHERE JZVRS.tax_calendar_period = P_PERIOD
1526: AND JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID

Line 1667: FROM jg_zz_vat_trx_details JZVTD

1663: BEGIN
1664: SELECT SUM(decode(JZVTD.tax_recoverable_flag, 'Y',
1665: nvl(JZVTD.tax_amt,JZVTD.tax_amt_funcl_curr),'N', 0 )) /* Bug#5235824 JZVTD.tax_amt_funcl_curr */
1666: INTO ln_tax_amt_funcl_curr
1667: FROM jg_zz_vat_trx_details JZVTD
1668: WHERE JZVTD.TRX_ID = P_TRX_ID
1669: AND JZVTD.extract_source_ledger in ('AP') /* AND JZVTD.posted_flag = 'P' Bug#5235824 */
1670: GROUP BY JZVTD.TRX_LINE_ID;
1671:

Line 1687: FROM jg_zz_vat_trx_details JZVTD

1683: BEGIN
1684: SELECT SUM (decode(JZVTD.tax_recoverable_flag, 'Y',
1685: nvl(JZVTD.taxable_amt,JZVTD.taxable_amt_funcl_curr), 'N', 0)) /* Bug#5235824 JZVTD.taxable_amt_funcl_curr */
1686: INTO ln_taxable_amt_funcl_curr
1687: FROM jg_zz_vat_trx_details JZVTD
1688: WHERE JZVTD.TRX_ID = P_TRX_ID
1689: AND JZVTD.extract_source_ledger = 'AP' /* AND JZVTD.posted_flag ='P' Bug#5235824 */
1690: GROUP BY JZVTD.trx_line_id;
1691:

Line 1707: FROM jg_zz_vat_trx_details JZVTD

1703: SELECT SUM(decode(JZVTD.tax_recoverable_flag, 'Y', nvl(JZVTD.tax_amt,JZVTD.tax_amt_funcl_curr),'N', 0 ))
1704: + SUM (decode(JZVTD.tax_recoverable_flag, 'Y', nvl(JZVTD.taxable_amt,JZVTD.taxable_amt_funcl_curr), 'N', 0))
1705: /* Bug#5235824. SUM (JZVTD.tax_amt_funcl_curr)+ SUM (JZVTD.taxable_amt_funcl_curr) */
1706: INTO ln_taxable_amt_funcl_curr
1707: FROM jg_zz_vat_trx_details JZVTD
1708: WHERE JZVTD.TRX_ID = P_TRX_ID
1709: AND JZVTD.extract_source_ledger = 'AP' /* AND JZVTD.posted_flag = 'P' Bug#5235824 */
1710: GROUP BY JZVTD.trx_line_id;
1711: