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.JE_ES_MODELO_EXT_PKG dependencies on AP_INVOICES_ALL

Line 79: , AP_SUPPLIER_SITES_ALL APSS, AP_SUPPLIERS APS, ZX_LINES_DET_FACTORS ZXDF ,AP_INVOICES_ALL API

75: decode(to_char(JZVTD.gl_date,'MM'),'01','1T','02','1T','03','1T','04','2T','05','2T','06','2T','07','3T','08','3T','09','3T','10','4T','11','4T','12','4T') QUARTER_NUM
76:
77: FROM jg_zz_vat_rep_status JZVRS
78: , jg_zz_vat_trx_details JZVTD
79: , AP_SUPPLIER_SITES_ALL APSS, AP_SUPPLIERS APS, ZX_LINES_DET_FACTORS ZXDF ,AP_INVOICES_ALL API
80: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
81: AND JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
82: FROM jg_zz_vat_rep_status JZRS
83: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID

Line 129: , ap_invoices_all api

125: , jg_zz_vat_trx_details JZVTD
126: , ap_suppliers aps
127: , ap_supplier_sites_all apss
128: , zx_lines_det_factors zxdf
129: , ap_invoices_all api
130:
131: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
132: AND JZVRS.reporting_status_id = JZVTD.reporting_status_id
133: AND JZVRS.source = 'AP'

Line 175: ,ap_invoices_all API

171: ,jg_zz_vat_rep_status JZVRS
172: ,ap_invoice_distributions AID
173: ,ap_invoice_distributions PRE
174: ,hz_parties HP
175: ,ap_invoices_all API
176: ,zx_lines_det_factors ZXDF
177:
178: WHERE JZVRS.reporting_status_id = JZVTD.reporting_status_id
179: AND JZVTD.billing_trading_partner_id = p_vendor_id

Line 1131: ,ap_invoices_all API

1127: ,jg_zz_vat_rep_status JZVRS
1128: ,ap_invoice_distributions AID
1129: ,ap_invoice_distributions PRE
1130: ,hz_parties HP
1131: ,ap_invoices_all API
1132: ,zx_lines_det_factors ZXDF
1133: WHERE JZVRS.reporting_status_id = JZVTD.reporting_status_id
1134: AND JZVTD.billing_trading_partner_id = p_vendor_id
1135: AND JZVTD.trx_type_mng = 'PREPAYMENT'

Line 2519: -- Bug 8485057 added AP_INVOICES_ALL to retrieve the actual current invoice_report_type

2515: as modelo 347 report needs to filter records based on FEDERAL_REPORTABLE_FLAG for suppliers
2516: and TAX_REPORTING_SITE_FLAG for supplier sites
2517:
2518: */
2519: -- Bug 8485057 added AP_INVOICES_ALL to retrieve the actual current invoice_report_type
2520: lc_jgzz_modelo_query :=
2521: REPLACE( lc_jgzz_modelo_query
2522: , '$MODELO_TABLE_LIST$'
2523: ,', AP_SUPPLIER_SITES_ALL APSS, AP_SUPPLIERS APS, AP_INVOICES_ALL API, ZX_LINES_DET_FACTORS ZXDF ' );

Line 2523: ,', AP_SUPPLIER_SITES_ALL APSS, AP_SUPPLIERS APS, AP_INVOICES_ALL API, ZX_LINES_DET_FACTORS ZXDF ' );

2519: -- Bug 8485057 added AP_INVOICES_ALL to retrieve the actual current invoice_report_type
2520: lc_jgzz_modelo_query :=
2521: REPLACE( lc_jgzz_modelo_query
2522: , '$MODELO_TABLE_LIST$'
2523: ,', AP_SUPPLIER_SITES_ALL APSS, AP_SUPPLIERS APS, AP_INVOICES_ALL API, ZX_LINES_DET_FACTORS ZXDF ' );
2524:
2525: lc_jgzz_modelo_query :=
2526: REPLACE( lc_jgzz_modelo_query
2527: , '$ADDRESS_ID$'

Line 2666: , ap_invoices_all API

2662: FROM jg_zz_vat_rep_status JZVRS
2663: , jg_zz_vat_trx_details JZVTD
2664: , ap_suppliers aps
2665: , ap_supplier_sites_all apss
2666: , ap_invoices_all API
2667: , zx_lines_det_factors zxdf
2668: /**
2669: author:brathod
2670: , ap_invoice_distributions_all AID

Line 2811: -- FH Added AP_INVOICES_ALL to table list for Modelo project

2807: /** author: brathod
2808: $MODELO_TABLE_LIST$ will have value ", AP_SUPPLIER_SITES APSS" [please note comma (,)at begining]
2809: as modelo 415 report needs to filter records based on TAX_REPORTING_SITE_FLAG for supplier sites only
2810: */
2811: -- FH Added AP_INVOICES_ALL to table list for Modelo project
2812: lc_jgzz_modelo_query :=
2813: REPLACE( lc_jgzz_modelo_query
2814: , '$MODELO_TABLE_LIST$'
2815: ,', AP_SUPPLIER_SITES_ALL APSS, AP_INVOICES_ALL API, ZX_LINES_DET_FACTORS ZXDF' );

Line 2815: ,', AP_SUPPLIER_SITES_ALL APSS, AP_INVOICES_ALL API, ZX_LINES_DET_FACTORS ZXDF' );

2811: -- FH Added AP_INVOICES_ALL to table list for Modelo project
2812: lc_jgzz_modelo_query :=
2813: REPLACE( lc_jgzz_modelo_query
2814: , '$MODELO_TABLE_LIST$'
2815: ,', AP_SUPPLIER_SITES_ALL APSS, AP_INVOICES_ALL API, ZX_LINES_DET_FACTORS ZXDF' );
2816:
2817: -- FH: Added Transaction Code for modelo project --
2818: lc_jgzz_modelo_query :=
2819: REPLACE( lc_jgzz_modelo_query

Line 4407: , AP_SUPPLIER_SITES_ALL APSS, AP_SUPPLIERS APS, AP_INVOICES_ALL API,

4403: nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt ))) DEDUCTABLE_AMOUNT,
4404: jzvtd.tax_rate TAX_RATE,
4405: APSS.VENDOR_SITE_ID
4406: FROM jg_zz_vat_trx_details jzvtd, jg_zz_vat_rep_status jzvrs
4407: , AP_SUPPLIER_SITES_ALL APSS, AP_SUPPLIERS APS, AP_INVOICES_ALL API,
4408: zx_lines_det_factors zxdf
4409: WHERE (substr(zxdf.trx_business_category,(instr(zxdf.trx_business_category,''MOD'',1,1)+3),3) in (''347'',''349'',''415'')
4410: OR substr(jzvtd.document_sub_type,1,6) = ''MOD340'')
4411: AND nvl(jzvtd.document_sub_type,''X'') <> ''MOD340_EXCL''

Line 4512: , AP_SUPPLIER_SITES_ALL APSS, AP_SUPPLIERS APS, AP_INVOICES_ALL API,

4508: nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt ))) DEDUCTABLE_AMOUNT,
4509: jzvtd.tax_rate TAX_RATE,
4510: APSS.VENDOR_SITE_ID
4511: FROM jg_zz_vat_trx_details jzvtd, jg_zz_vat_rep_status jzvrs
4512: , AP_SUPPLIER_SITES_ALL APSS, AP_SUPPLIERS APS, AP_INVOICES_ALL API,
4513: zx_lines_det_factors zxdf
4514: WHERE (substr(zxdf.trx_business_category,(instr(zxdf.trx_business_category,''MOD'',1,1)+3),3) in (''347'',''349'',''415'')
4515: OR substr(jzvtd.document_sub_type,1,6) = ''MOD340'')
4516: AND nvl(jzvtd.document_sub_type,''X'') <> ''MOD340_EXCL''