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_REP_STATUS

Line 22: jg_zz_vat_rep_status vrs

18: BEGIN
19: SELECT max(vrs.period_start_date)
20: INTO l_period_start_date
21: FROM jg_zz_vat_final_reports vfr,
22: jg_zz_vat_rep_status vrs
23: WHERE vfr.report_name = p_report_name
24: AND vfr.vat_register_id = p_vat_register_id
25: AND vrs.reporting_status_id = vfr.reporting_status_id;
26:

Line 30: jg_zz_vat_rep_status vrs

26:
27: SELECT nvl(start_sequence_num,0)
28: INTO l_start_seq
29: FROM jg_zz_vat_final_reports vfr,
30: jg_zz_vat_rep_status vrs
31: WHERE vfr.report_name = p_report_name
32: AND vfr.vat_register_id = p_vat_register_id
33: AND vrs.reporting_status_id = vfr.reporting_status_id
34: AND vrs.period_start_date = l_period_start_date;

Line 198: jg_zz_vat_rep_status vrs

194: IF l_reporting_status = 'COPY' THEN
195: SELECT last_start_sequence_num
196: INTO l_start_seq
197: FROM jg_zz_vat_final_reports vfr,
198: jg_zz_vat_rep_status vrs
199: WHERE vfr.report_name = p_report_name
200: AND vfr.vat_register_id = p_vat_register_id
201: AND vrs.reporting_status_id = vfr.reporting_status_id
202: AND vrs.tax_calendar_period = p_period;

Line 520: , jg_zz_vat_rep_status JZVRS

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'
524: AND JZVRS.source = 'AP'

Line 729: ,jg_zz_vat_rep_status JZVRS

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
733: AND JZVRS.tax_calendar_period = P_PERIOD

Line 874: FROM jg_zz_vat_rep_status

870: last_start_sequence_num = lv_start_seq
871: WHERE report_name = p_report_name
872: AND vat_register_id = p_vat_register_id
873: AND reporting_status_id = (SELECT reporting_status_id
874: FROM jg_zz_vat_rep_status
875: WHERE vat_reporting_entity_id = p_vat_rep_entity_id
876: AND source = 'AP'
877: AND tax_calendar_period = p_period);
878:

Line 962: ,jg_zz_vat_rep_status JZVRS

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 */
966: ,zx_lines ZX

Line 1128: FROM jg_zz_vat_rep_status

1124: last_start_sequence_num = lv_start_seq
1125: WHERE report_name = p_report_name
1126: AND vat_register_id = p_vat_register_id
1127: AND reporting_status_id = (SELECT reporting_status_id
1128: FROM jg_zz_vat_rep_status
1129: WHERE vat_reporting_entity_id = p_vat_rep_entity_id
1130: AND source = 'AP'
1131: AND tax_calendar_period = p_period);
1132:

Line 1180: ,jg_zz_vat_rep_status JZVRS

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

Line 1184: FROM JG_ZZ_VAT_REP_STATUS RPS1,

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
1184: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1185: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1186: min(period_start_date) period_start_date
1187: From JG_ZZ_VAT_REP_STATUS
1188: Where vat_reporting_entity_id = p_vat_rep_entity_id

Line 1187: From JG_ZZ_VAT_REP_STATUS

1183: AND JZVRS.tax_calendar_period IN (SELECT RPS1.tax_calendar_period
1184: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1185: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1186: min(period_start_date) period_start_date
1187: From JG_ZZ_VAT_REP_STATUS
1188: Where vat_reporting_entity_id = p_vat_rep_entity_id
1189: And tax_calendar_period =p_period) RPS2,
1190: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1191: min(period_end_date) period_end_date

Line 1192: From JG_ZZ_VAT_REP_STATUS

1188: Where vat_reporting_entity_id = p_vat_rep_entity_id
1189: And tax_calendar_period =p_period) RPS2,
1190: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1191: min(period_end_date) period_end_date
1192: From JG_ZZ_VAT_REP_STATUS
1193: Where vat_reporting_entity_id = p_vat_rep_entity_id
1194: And tax_calendar_period = p_period_to) RPS3
1195: WHERE RPS1.vat_reporting_entity_id = p_vat_rep_entity_id
1196: AND RPS2.vat_reporting_entity_id = RPS1.vat_reporting_entity_id

Line 1207: FROM jg_zz_vat_rep_status JZRS

1203: AND (JZVTD.trx_tax_balancing_segment = P_BALANCING_SEGMENT OR P_BALANCING_SEGMENT is null)
1204: AND (JZVTD.reporting_code = P_TAX_TYPE OR P_TAX_TYPE is null)
1205: AND JZVRS.source = 'AP'
1206: AND JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
1207: FROM jg_zz_vat_rep_status JZRS
1208: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1209: AND JZRS.source = 'AP')
1210: AND JZVTD.gl_date BETWEEN JZVRS.period_start_date and JZVRS.period_end_date;
1211: -- AND JZVTD.reporting_status_id = JZVRS.reporting_status_id ;

Line 1328: ,jg_zz_vat_rep_status JZVRS

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

Line 1332: FROM JG_ZZ_VAT_REP_STATUS RPS1,

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
1332: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1333: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1334: min(period_start_date) period_start_date
1335: From JG_ZZ_VAT_REP_STATUS
1336: Where vat_reporting_entity_id = p_vat_rep_entity_id

Line 1335: From JG_ZZ_VAT_REP_STATUS

1331: AND JZVRS.tax_calendar_period IN (SELECT RPS1.tax_calendar_period
1332: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1333: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1334: min(period_start_date) period_start_date
1335: From JG_ZZ_VAT_REP_STATUS
1336: Where vat_reporting_entity_id = p_vat_rep_entity_id
1337: And tax_calendar_period =p_period) RPS2,
1338: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1339: min(period_end_date) period_end_date

Line 1340: From JG_ZZ_VAT_REP_STATUS

1336: Where vat_reporting_entity_id = p_vat_rep_entity_id
1337: And tax_calendar_period =p_period) RPS2,
1338: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1339: min(period_end_date) period_end_date
1340: From JG_ZZ_VAT_REP_STATUS
1341: Where vat_reporting_entity_id = p_vat_rep_entity_id
1342: And tax_calendar_period = p_period_to) RPS3
1343: WHERE RPS1.vat_reporting_entity_id = p_vat_rep_entity_id
1344: AND RPS2.vat_reporting_entity_id = RPS1.vat_reporting_entity_id

Line 1356: FROM jg_zz_vat_rep_status JZRS

1352: -- AND JZVTD.tax_type_code = P_TAX_TYPE -- Bug 6238170
1353: AND JZVTD.reporting_code = P_TAX_TYPE
1354: AND JZVRS.source = 'AP'
1355: AND JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
1356: FROM jg_zz_vat_rep_status JZRS
1357: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1358: AND JZRS.source = 'AP')
1359: AND JZVTD.gl_date BETWEEN JZVRS.period_start_date and JZVRS.period_end_date
1360: -- AND JZVTD.tax_amt <> 0

Line 1523: ,jg_zz_vat_rep_status JZVRS

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
1527: AND JZVRS.source = 'AP'