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 start_sequence_num
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 173: jg_zz_vat_rep_status vrs

169: IF l_reporting_status = 'COPY' THEN
170: SELECT last_start_sequence_num
171: INTO l_start_seq
172: FROM jg_zz_vat_final_reports vfr,
173: jg_zz_vat_rep_status vrs
174: WHERE vfr.report_name = p_report_name
175: AND vfr.vat_register_id = p_vat_register_id
176: AND vrs.reporting_status_id = vfr.reporting_status_id
177: AND vrs.tax_calendar_period = p_period;

Line 459: , jg_zz_vat_rep_status JZVRS

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

Line 612: ,jg_zz_vat_rep_status JZVRS

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

Line 754: FROM jg_zz_vat_rep_status

750: last_start_sequence_num = lv_start_seq
751: WHERE report_name = p_report_name
752: AND vat_register_id = p_vat_register_id
753: AND reporting_status_id = (SELECT reporting_status_id
754: FROM jg_zz_vat_rep_status
755: WHERE vat_reporting_entity_id = p_vat_rep_entity_id
756: AND source = 'AP'
757: AND tax_calendar_period = p_period);
758:

Line 816: ,jg_zz_vat_rep_status JZVRS

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 */
820:

Line 974: FROM jg_zz_vat_rep_status

970: last_start_sequence_num = lv_start_seq
971: WHERE report_name = p_report_name
972: AND vat_register_id = p_vat_register_id
973: AND reporting_status_id = (SELECT reporting_status_id
974: FROM jg_zz_vat_rep_status
975: WHERE vat_reporting_entity_id = p_vat_rep_entity_id
976: AND source = 'AP'
977: AND tax_calendar_period = p_period);
978:

Line 1025: ,jg_zz_vat_rep_status JZVRS

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)
1029: AND (JZVTD.reporting_code = P_TAX_TYPE OR P_TAX_TYPE is null)

Line 1032: FROM jg_zz_vat_rep_status JZRS

1028: AND (JZVTD.trx_tax_balancing_segment = P_BALANCING_SEGMENT OR P_BALANCING_SEGMENT is null)
1029: AND (JZVTD.reporting_code = P_TAX_TYPE OR P_TAX_TYPE is null)
1030: AND JZVRS.source = 'AP'
1031: AND JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
1032: FROM jg_zz_vat_rep_status JZRS
1033: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1034: AND JZRS.source = 'AP')
1035: AND JZVTD.gl_date BETWEEN JZVRS.period_start_date and JZVRS.period_end_date;
1036: -- AND JZVTD.reporting_status_id = JZVRS.reporting_status_id ;

Line 1152: ,jg_zz_vat_rep_status JZVRS

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 )
1156: -- AND JZVTD.tax_type_code = P_TAX_TYPE -- Bug 6238170

Line 1160: FROM jg_zz_vat_rep_status JZRS

1156: -- AND JZVTD.tax_type_code = P_TAX_TYPE -- Bug 6238170
1157: AND JZVTD.reporting_code = P_TAX_TYPE
1158: AND JZVRS.source = 'AP'
1159: AND JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
1160: FROM jg_zz_vat_rep_status JZRS
1161: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1162: AND JZRS.source = 'AP')
1163: AND JZVTD.gl_date BETWEEN JZVRS.period_start_date and JZVRS.period_end_date
1164: -- AND JZVTD.tax_amt <> 0

Line 1327: ,jg_zz_vat_rep_status JZVRS

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