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 ZX_LINES_DET_FACTORS

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 128: , zx_lines_det_factors zxdf

124: FROM jg_zz_vat_rep_status JZVRS
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

Line 176: ,zx_lines_det_factors ZXDF

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
180: AND JZVTD.trx_type_mng = 'PREPAYMENT'

Line 293: , zx_lines_det_factors zxdf

289: , hz_cust_site_uses_all hzcsu
290: , hz_cust_acct_sites_all hzcas
291: , hz_cust_accounts hzca
292: , ra_customer_trx_all trx
293: , zx_lines_det_factors zxdf
294:
295: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
296: AND JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
297: FROM jg_zz_vat_rep_status JZRS

Line 334: , zx_lines_det_factors ZXDF

330: ,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
331: FROM jg_zz_vat_trx_details JZVTD
332: , jg_zz_vat_rep_status JZVRS
333: , hz_cust_site_uses_all HCSU
334: , zx_lines_det_factors ZXDF
335: , ra_customer_trx_all trx
336: WHERE nvl(JZVTD.billing_trading_partner_id,1) = nvl(p_customer_id,1)
337: AND HCSU.cust_acct_site_id = JZVTD.billing_tp_address_id
338: AND UPPER(HCSU.site_use_code) = 'LEGAL'

Line 541: , zx_lines_det_factors ZXDF

537: FROM
538: jg_zz_vat_trx_details JZVTD
539: , hr_locations HL
540: , ra_customer_trx TRX
541: , zx_lines_det_factors ZXDF
542: where JZVTD.trx_id = p_trx_id
543: AND JZVTD.trx_id = TRX.customer_trx_id
544: AND HL.location_id = TO_NUMBER(TRX.global_attribute2)
545: AND (SUBSTR(ZXDF.trx_business_category, INSTR(zxdf.trx_business_category,'MOD')+3,

Line 650: , zx_lines_det_factors ZXDF

646: , hz_party_sites HPS
647: , hr_locations HL
648: -- , fnd_territories FT -- Bug 8485057: not necessary
649: , hz_cust_site_uses_all HCSU
650: , zx_lines_det_factors ZXDF
651: , ra_customer_trx TRX
652: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
653: AND JZVRS.reporting_status_id = JZVTD.reporting_status_id
654: AND JZVTD.extract_source_ledger = 'AR'

Line 1132: ,zx_lines_det_factors ZXDF

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'
1136: --AND JZVTD.posted_flag IN ('P','Y') /** author:brathod; Removed posted_flag checking as it is not relevent in R12 */

Line 1252: , zx_lines_det_factors ZXDF -- Bug 8485057

1248: + SUM(NVL(JZVTD.tax_amt_funcl_curr, 0))
1249: INTO v_arrenda_amount
1250: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS
1251: , hz_cust_site_uses_all HCSU
1252: , zx_lines_det_factors ZXDF -- Bug 8485057
1253: , ra_customer_trx_all trx
1254: WHERE JZVTD.billing_trading_partner_id = p_customer_id
1255: AND HCSU.cust_acct_site_id = JZVTD.billing_tp_address_id
1256: AND UPPER(HCSU.site_use_code) = 'LEGAL'

Line 1339: , zx_lines_det_factors ZXDF

1335: / COUNT(JZVTD.trx_id)
1336: INTO v_cash_received_amount
1337: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS
1338: , hz_cust_site_uses_all HCSU
1339: , zx_lines_det_factors ZXDF
1340: , ar_receivable_applications_all RA
1341: , ar_cash_receipts_all CR
1342: , ra_customer_trx_all trx
1343: WHERE JZVTD.billing_trading_partner_id = p_customer_id

Line 1397: , zx_lines_det_factors ZXDF

1393: / COUNT(JZVTD.trx_id)
1394: INTO v_cash_received_amount
1395: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS
1396: , hz_cust_site_uses_all HCSU
1397: , zx_lines_det_factors ZXDF
1398: , ar_receivable_applications_all RA
1399: , ar_cash_receipts_all CR
1400: , ra_customer_trx_all trx
1401: WHERE JZVTD.billing_trading_partner_id = p_customer_id

Line 1476: , zx_lines_det_factors ZXDF

1472: / COUNT(JZVTD.trx_id)
1473: INTO v_cash_received_amount
1474: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS
1475: , hz_cust_site_uses_all HCSU
1476: , zx_lines_det_factors ZXDF
1477: , ar_receivable_applications_all RA
1478: , ar_cash_receipts_all CR
1479: , ra_customer_trx_all trx
1480: WHERE JZVTD.billing_tp_taxpayer_id = p_declared_nif

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 2667: , zx_lines_det_factors zxdf

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
2671: , ap_invoice_distributions_all ALC

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 3489: ,' , hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca, ra_customer_trx_all trx, zx_lines_det_factors zxdf ');

3485:
3486: lc_jgzz_modelo_query :=
3487: REPLACE( lc_jgzz_modelo_query
3488: , '$MODELO_TABLE_LIST$'
3489: ,' , hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca, ra_customer_trx_all trx, zx_lines_det_factors zxdf ');
3490:
3491: lc_jgzz_modelo_query :=
3492: REPLACE( lc_jgzz_modelo_query
3493: ,'$ADDRESS_ID$'

Line 3606: ,' , hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca, ZX_LINES_DET_FACTORS zxdf ' );

3602: -- FH: Added ZX table for modelo project
3603: lc_jgzz_modelo_query :=
3604: REPLACE( lc_jgzz_modelo_query
3605: , '$MODELO_TABLE_LIST$'
3606: ,' , hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca, ZX_LINES_DET_FACTORS zxdf ' );
3607:
3608: G_LINENO := '2.3.3';
3609: lc_jgzz_modelo_query :=
3610: REPLACE( lc_jgzz_modelo_query

Line 4408: zx_lines_det_factors zxdf

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''
4412: AND JZVRS.vat_reporting_entity_id = $P_VAT_REP_ENTITY_ID$

Line 4513: zx_lines_det_factors zxdf

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''
4517: AND JZVRS.vat_reporting_entity_id = $P_VAT_REP_ENTITY_ID$

Line 4882: , ZX_LINES_DET_FACTORS zxdf, ra_customer_trx_all trx

4878: $YEAR_AMT_RECEIVED_CASH$
4879: $TRANSMISSION_PROPERTY$
4880: FROM jg_zz_vat_trx_details jzvtd, jg_zz_vat_rep_status jzvrs
4881: , hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca
4882: , ZX_LINES_DET_FACTORS zxdf, ra_customer_trx_all trx
4883: WHERE (substr(zxdf.trx_business_category,(instr(zxdf.trx_business_category,''MOD'',1,1)+3),3) in (''347'',''349'',''415'')
4884: OR substr(zxdf.document_sub_type,1,6) = ''MOD340'')
4885: AND nvl(zxdf.document_sub_type,''X'') <> ''MOD340_EXCL''
4886: AND JZVRS.vat_reporting_entity_id = $P_VAT_REP_ENTITY_ID$