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 1097: , ap_invoice_distributions_all AIP

1093: FROM mtl_uom_conversions_view UCR
1094: , po_lines_all PL
1095: , po_distributions_all PD
1096: , mtl_parameters MP
1097: , ap_invoice_distributions_all AIP
1098: WHERE NVL(AIP.posted_flag,'N') = 'Y'
1099: AND AIP.accounting_date
1100: BETWEEN NVL(I_FROM_DATE, AIP.accounting_date)
1101: AND NVL(I_TO_DATE, AIP.accounting_date)

Line 1172: FROM ap_invoice_distributions_all

1168: , accounting_date
1169: , line_type_lookup_code
1170: , matched_uom_lookup_code
1171: , po_distribution_id
1172: FROM ap_invoice_distributions_all
1173: WHERE line_type_lookup_code IN ('ITEM','ACCRUAL')
1174: UNION ALL
1175: SELECT i.base_amount
1176: , 0 --l.quantity_invoiced because tax line quantity is included in accrual or item line quantity

Line 1183: FROM ap_invoice_distributions_all i

1179: , i.accounting_date
1180: , i.line_type_lookup_code
1181: , l.matched_uom_lookup_code
1182: , i.po_distribution_id
1183: FROM ap_invoice_distributions_all i
1184: , ap_invoice_distributions_all l
1185: WHERE i.line_type_lookup_code = 'NONREC_TAX'
1186: AND i.CHARGE_APPLICABLE_TO_DIST_ID = l.invoice_distribution_id
1187: AND l.line_type_lookup_code IN ('ITEM', 'ACCRUAL')

Line 1184: , ap_invoice_distributions_all l

1180: , i.line_type_lookup_code
1181: , l.matched_uom_lookup_code
1182: , i.po_distribution_id
1183: FROM ap_invoice_distributions_all i
1184: , ap_invoice_distributions_all l
1185: WHERE i.line_type_lookup_code = 'NONREC_TAX'
1186: AND i.CHARGE_APPLICABLE_TO_DIST_ID = l.invoice_distribution_id
1187: AND l.line_type_lookup_code IN ('ITEM', 'ACCRUAL')
1188: UNION ALL

Line 1197: FROM ap_invoice_distributions_all i

1193: , i.accounting_date
1194: , i.line_type_lookup_code
1195: , l.matched_uom_lookup_code
1196: , i.po_distribution_id
1197: FROM ap_invoice_distributions_all i
1198: , ap_invoice_distributions_all l
1199: WHERE i.line_type_lookup_code = 'IPV'
1200: AND i.related_id = l.related_id
1201: AND i.invoice_id = l.invoice_id

Line 1198: , ap_invoice_distributions_all l

1194: , i.line_type_lookup_code
1195: , l.matched_uom_lookup_code
1196: , i.po_distribution_id
1197: FROM ap_invoice_distributions_all i
1198: , ap_invoice_distributions_all l
1199: WHERE i.line_type_lookup_code = 'IPV'
1200: AND i.related_id = l.related_id
1201: AND i.invoice_id = l.invoice_id
1202: AND l.line_type_lookup_code <> 'IPV') AIP