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.CSTPMECS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1024: , ap_invoice_distributions_all AIP

1020: FROM mtl_uom_conversions_view UCR
1021: , po_lines_all PL
1022: , po_distributions_all PD
1023: , mtl_parameters MP
1024: , ap_invoice_distributions_all AIP
1025: WHERE AIP.posted_flag = 'Y'
1026: AND (I_FROM_DATE IS NULL OR (I_FROM_DATE IS NOT NULL and AIP.accounting_date >= I_FROM_DATE))
1027: AND (I_TO_DATE IS NULL OR (I_TO_DATE IS NOT NULL and AIP.accounting_date <= I_TO_DATE))
1028: AND PD.po_distribution_id = AIP.po_distribution_id

Line 1056: , ap_invoice_distributions_all AIP

1052: FROM mtl_uom_conversions_view UCR
1053: , po_lines_all PL
1054: , po_distributions_all PD
1055: , mtl_parameters MP
1056: , ap_invoice_distributions_all AIP
1057: WHERE NVL(AIP.posted_flag,'N') = 'Y'
1058: AND AIP.accounting_date
1059: BETWEEN NVL(I_FROM_DATE, AIP.accounting_date)
1060: AND NVL(I_TO_DATE, AIP.accounting_date)

Line 1128: , ap_invoice_distributions_all AIP

1124: FROM mtl_uom_conversions_view UCR
1125: , po_lines_all PL
1126: , po_distributions_all PD
1127: , mtl_parameters MP
1128: , ap_invoice_distributions_all AIP
1129: WHERE AIP.posted_flag = 'Y'
1130: AND (I_FROM_DATE IS NULL OR (I_FROM_DATE IS NOT NULL and AIP.accounting_date >= I_FROM_DATE))
1131: AND (I_TO_DATE IS NULL OR (I_TO_DATE IS NOT NULL and AIP.accounting_date <= I_TO_DATE))
1132: -- AND AIP.line_type_lookup_code = 'ITEM' -- added for bug 1893507