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 504: ,ap_invoice_distributions AID

500: )
501: INTO V_PREPAY_APPLIED
502: FROM jg_zz_vat_trx_details JZVTD
503: ,jg_zz_vat_rep_status JZVRS
504: ,ap_invoice_distributions AID
505: WHERE JZVRS.reporting_status_id = JZVTD.reporting_status_id
506: AND JZVTD.billing_trading_partner_id = p_vendor_id
507: AND JZVTD.trx_type_mng = 'PREPAYMENT'
508: --AND JZVTD.posted_flag IN ('P','Y') /** author: brathod; Removed posted_flag checking as it is not relevent in R12 */

Line 556: ,ap_invoice_distributions AID

552: )
553: INTO V_PREPAY_APPLIED
554: FROM jg_zz_vat_trx_details JZVTD
555: ,jg_zz_vat_rep_status JZVRS
556: ,ap_invoice_distributions AID
557: ,ap_invoice_distributions PRE
558: ,hz_parties HP
559: WHERE JZVRS.reporting_status_id = JZVTD.reporting_status_id
560: AND JZVTD.billing_trading_partner_id = p_vendor_id

Line 557: ,ap_invoice_distributions PRE

553: INTO V_PREPAY_APPLIED
554: FROM jg_zz_vat_trx_details JZVTD
555: ,jg_zz_vat_rep_status JZVRS
556: ,ap_invoice_distributions AID
557: ,ap_invoice_distributions PRE
558: ,hz_parties HP
559: WHERE JZVRS.reporting_status_id = JZVTD.reporting_status_id
560: AND JZVTD.billing_trading_partner_id = p_vendor_id
561: AND JZVTD.trx_type_mng = 'PREPAYMENT'

Line 1414: , ap_invoice_distributions_all AID

1410: , ap_suppliers aps
1411: , ap_supplier_sites_all apss
1412: /**
1413: author:brathod
1414: , ap_invoice_distributions_all AID
1415: , ap_invoice_distributions_all ALC
1416: WHERE AID.invoice_distribution_id = JZVTD.trx_line_id
1417: AND ALC.invoice_distribution_id = AID.charge_applicable_to_dist_id
1418: */

Line 1415: , ap_invoice_distributions_all ALC

1411: , ap_supplier_sites_all apss
1412: /**
1413: author:brathod
1414: , ap_invoice_distributions_all AID
1415: , ap_invoice_distributions_all ALC
1416: WHERE AID.invoice_distribution_id = JZVTD.trx_line_id
1417: AND ALC.invoice_distribution_id = AID.charge_applicable_to_dist_id
1418: */
1419: WHERE JZVRS.vat_reporting_entity_id = $P_VAT_REP_ENTITY_ID$