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_SUMMARY_ALL_PKG dependencies on JG_ZZ_VAT_REP_STATUS

Line 546: , jg_zz_vat_rep_status JZVRS

542: , jg_zz_vat_alloc_rules alr
543: , jg_zz_vat_trx_details JG
544: , fnd_lookup_values TLOOKUP
545: , fnd_lookup_values TBLLOOKUP
546: , jg_zz_vat_rep_status JZVRS
547: WHERE
548: NVL(AL.taxable_box, '99') = TBLLOOKUP.lookup_code
549: AND NVL(AL.tax_box, '99') = TLOOKUP.lookup_code -- brathod, Using AND condition instead of OR
550: AND TLOOKUP.lookup_type = 'JGZZ_VAT_REPORT_BOXES'

Line 586: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER

582: */
583:
584: TYPE r_box_amounts IS RECORD
585: (
586: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
587: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
588: ,tax_box jg_zz_vat_box_allocs.tax_box%type
589: ,taxable_box jg_zz_vat_box_allocs.taxable_box%type --VARCHAR2(10)
590: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)

Line 587: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)

583:
584: TYPE r_box_amounts IS RECORD
585: (
586: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
587: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
588: ,tax_box jg_zz_vat_box_allocs.tax_box%type
589: ,taxable_box jg_zz_vat_box_allocs.taxable_box%type --VARCHAR2(10)
590: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)
591: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)

Line 608: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER

604: );
605:
606: TYPE r_vatbox_amounts IS RECORD
607: (
608: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
609: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
610: ,vat_report_box jg_zz_vat_box_allocs.tax_box%type --VARCHAR2(10)
611: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)
612: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)

Line 609: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)

605:
606: TYPE r_vatbox_amounts IS RECORD
607: (
608: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
609: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
610: ,vat_report_box jg_zz_vat_box_allocs.tax_box%type --VARCHAR2(10)
611: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)
612: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
613: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)

Line 845: , jg_zz_vat_rep_status JZVRS

841: , ALLOCBOX.tax_recoverable_flag TAX_RECOVERABLE_FLAG
842: , JG.extract_source_ledger EXTRACT_SOURCE_LEDGER
843: , AllOCBOX.allocation_rule_id ALLOCATION_RULE_ID
844: FROM jg_zz_vat_trx_details JG
845: , jg_zz_vat_rep_status JZVRS
846: , jg_zz_vat_box_allocs AllOCBOX
847: , jg_zz_vat_alloc_rules ALLOCRUL
848: WHERE JZVRS.reporting_status_id = JG.reporting_status_id
849: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id

Line 1076: , jg_zz_vat_rep_status JZVRS

1072: 101,JG.prl_no) TAX_CLASS
1073: ,JG.extract_source_ledger EXTRACT_SOURCE_LEDGER
1074: ,JG.reporting_code REPORTING_CODE
1075: FROM jg_zz_vat_trx_details JG
1076: , jg_zz_vat_rep_status JZVRS
1077: , jg_zz_vat_box_allocs AL
1078: WHERE decode(JG.extract_source_ledger,'AP',NVL(JG.tax_recoverable_flag,'N'),'Y') ='Y' -- Bug 5561879
1079: AND JZVRS.reporting_status_id = JG.reporting_status_id
1080: AND AL.vat_transaction_id = JG.vat_transaction_id

Line 1221: , jg_zz_vat_rep_status JZVRS

1217: , DECODE(credit_balance_amt,NULL,0,credit_balance_amt) CREDIT_BALANCE_AMT
1218: , assessable_value ASSESSABLE_VALUE
1219: FROM
1220: jg_zz_vat_trx_details JG
1221: , jg_zz_vat_rep_status JZVRS
1222: WHERE JZVRS.reporting_status_id = JG.reporting_status_id
1223: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1224: AND JZVRS.tax_calendar_period = p_period ;
1225:

Line 1533: FROM jg_zz_vat_rep_status JZVRS

1529: SELECT
1530: JZVRS.CREDIT_BALANCE_AMT,
1531: JZVRS.FINAL_REPORTING_STATUS_FLAG,
1532: jg_zz_vat_rep_utility.get_last_processed_date(p_vat_rep_entity_id,'ALL','FINAL REPORTING') LAST_PROCESS_DATE
1533: FROM jg_zz_vat_rep_status JZVRS
1534: WHERE JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1535: AND JZVRS.tax_calendar_period = p_period
1536: AND ROWNUM = 1;
1537: Bug:8237932*/

Line 1550: jg_zz_vat_rep_status JZVRS

1546: SELECT
1547: max(JZVRS.period_end_date)
1548:
1549: FROM
1550: jg_zz_vat_rep_status JZVRS
1551: WHERE
1552: JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1553: AND JZVRS.period_end_date <
1554: (SELECT max(JZVRS1.period_end_date)

Line 1555: FROM jg_zz_vat_rep_status JZVRS1

1551: WHERE
1552: JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1553: AND JZVRS.period_end_date <
1554: (SELECT max(JZVRS1.period_end_date)
1555: FROM jg_zz_vat_rep_status JZVRS1
1556: WHERE JZVRS1.tax_calendar_period = p_period
1557: AND JZVRS1.vat_reporting_entity_id = p_vat_rep_entity_id
1558: AND JZVRS1.final_reporting_status_flag = 'S'
1559: )

Line 1566: FROM jg_zz_vat_rep_status JZVRS

1562:
1563: CURSOR c_get_balance ( pn_last_process_date DATE) IS
1564: SELECT
1565: JZVRS.CREDIT_BALANCE_AMT
1566: FROM jg_zz_vat_rep_status JZVRS
1567: WHERE JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1568: AND JZVRS.tax_calendar_period =( SELECT JZVRS1.tax_calendar_period
1569: FROM jg_zz_vat_rep_status JZVRS1
1570: WHERE

Line 1569: FROM jg_zz_vat_rep_status JZVRS1

1565: JZVRS.CREDIT_BALANCE_AMT
1566: FROM jg_zz_vat_rep_status JZVRS
1567: WHERE JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1568: AND JZVRS.tax_calendar_period =( SELECT JZVRS1.tax_calendar_period
1569: FROM jg_zz_vat_rep_status JZVRS1
1570: WHERE
1571: JZVRS1.vat_reporting_entity_id = p_vat_rep_entity_id
1572: AND TRUNC(JZVRS1.period_end_date) = pn_last_process_date
1573: AND ROWNUM =1)

Line 1579: FROM jg_zz_vat_rep_status JZVRS

1575:
1576: CURSOR c_get_flag IS
1577: SELECT
1578: JZVRS.FINAL_REPORTING_STATUS_FLAG
1579: FROM jg_zz_vat_rep_status JZVRS
1580: WHERE JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1581: AND JZVRS.tax_calendar_period = p_period
1582: AND ROWNUM = 1;
1583:

Line 1651: UPDATE jg_zz_vat_rep_status SET CREDIT_BALANCE_AMT=CARRY_OVER

1647: END IF;
1648:
1649: IF TEMP_FLAG = 0 THEN
1650:
1651: UPDATE jg_zz_vat_rep_status SET CREDIT_BALANCE_AMT=CARRY_OVER
1652: WHERE vat_reporting_entity_id = p_vat_rep_entity_id
1653: AND tax_calendar_period = p_period;
1654:
1655: TEMP_FLAG := 1;

Line 1683: FROM jg_zz_vat_rep_status JZVRS

1679: --LOG_MESSAGE VARCHAR2(240);
1680: CURSOR c_get_details IS
1681: SELECT
1682: JZVRS.FINAL_REPORTING_STATUS_FLAG
1683: FROM jg_zz_vat_rep_status JZVRS
1684: WHERE JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1685: AND JZVRS.tax_calendar_period = p_period
1686: AND ROWNUM = 1;
1687: BEGIN

Line 1703: UPDATE jg_zz_vat_rep_status SET CREDIT_BALANCE_AMT=CARRY_OVER

1699: END IF;
1700:
1701: IF TEMP_FLAG = 0 THEN
1702:
1703: UPDATE jg_zz_vat_rep_status SET CREDIT_BALANCE_AMT=CARRY_OVER
1704: WHERE vat_reporting_entity_id = p_vat_rep_entity_id
1705: AND tax_calendar_period = p_period;
1706:
1707: TEMP_FLAG := 1;