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_INVOICE_DISTRIBUTIONS

Line 172: ,ap_invoice_distributions AID

168: ) prepay_applied_Qtr,
169: 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
170: FROM jg_zz_vat_trx_details JZVTD
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

Line 173: ,ap_invoice_distributions PRE

169: 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
170: FROM jg_zz_vat_trx_details JZVTD
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:

Line 1054: ,ap_invoice_distributions AID

1050: )
1051: INTO V_PREPAY_APPLIED
1052: FROM jg_zz_vat_trx_details JZVTD
1053: ,jg_zz_vat_rep_status JZVRS
1054: ,ap_invoice_distributions AID
1055: WHERE JZVRS.reporting_status_id = JZVTD.reporting_status_id
1056: AND JZVTD.billing_trading_partner_id = p_vendor_id
1057: AND JZVTD.trx_type_mng = 'PREPAYMENT'
1058: --AND JZVTD.posted_flag IN ('P','Y') /** author: brathod; Removed posted_flag checking as it is not relevent in R12 */

Line 1128: ,ap_invoice_distributions AID

1124: )
1125: INTO V_PREPAY_APPLIED
1126: FROM jg_zz_vat_trx_details JZVTD
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

Line 1129: ,ap_invoice_distributions PRE

1125: INTO V_PREPAY_APPLIED
1126: FROM jg_zz_vat_trx_details JZVTD
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

Line 2670: , ap_invoice_distributions_all AID

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
2672: WHERE AID.invoice_distribution_id = JZVTD.trx_line_id
2673: AND ALC.invoice_distribution_id = AID.charge_applicable_to_dist_id
2674: */

Line 2671: , ap_invoice_distributions_all ALC

2667: , zx_lines_det_factors zxdf
2668: /**
2669: author:brathod
2670: , ap_invoice_distributions_all AID
2671: , ap_invoice_distributions_all ALC
2672: WHERE AID.invoice_distribution_id = JZVTD.trx_line_id
2673: AND ALC.invoice_distribution_id = AID.charge_applicable_to_dist_id
2674: */
2675: WHERE JZVRS.vat_reporting_entity_id = $P_VAT_REP_ENTITY_ID$