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.ZX_AP_ACTG_POPULATE_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 1170: ap_invoice_payments_all aip,

1166: SELECT sum(aphd.amount), -- discount amount (entered)
1167: sum(aphd.paid_base_amount) -- discount amount (accounted)
1168: FROM ap_invoice_distributions_all aid,
1169: ap_invoices_all ai,
1170: ap_invoice_payments_all aip,
1171: ap_payment_hist_dists aphd,
1172: ap_payment_history_all aph
1173: WHERE aid.invoice_id = ai.invoice_id
1174: AND aid.invoice_id = aip.invoice_id

Line 1192: ap_invoice_payments_all aip,

1188: xal.accounted_dr -xal.entered_cr
1189: -- discount entered amount (replace this with new xla colum names)
1190: FROM ap_invoice_distributions_all aid,
1191: ap_invoices_all ai,
1192: ap_invoice_payments_all aip,
1193: ap_payment_history_all aph,
1194: xla_ae_lines xal
1195: WHERE aid.invoice_id = ai.invoice_id
1196: AND aid.invoice_id = aip.invoice_id

Line 1213: ap_invoice_payments_all aip,

1209: SELECT sum(aphd.amount), -- discount amount (entered)
1210: sum(aphd.paid_base_amount) -- discount amount (accounted)
1211: FROM ap_invoice_distributions_all aid,
1212: ap_invoices_all ai,
1213: ap_invoice_payments_all aip,
1214: ap_payment_hist_dists aphd,
1215: ap_payment_history_all aph
1216: WHERE aid.invoice_id = ai.invoice_id
1217: AND aid.invoice_id = aip.invoice_id

Line 1235: ap_invoice_payments_all aip,

1231: xal.accounted_dr -xal.entered_cr
1232: -- discount entered amount (replace this with new xla colum names)
1233: FROM ap_invoice_distributions_all aid,
1234: ap_invoices_all ai,
1235: ap_invoice_payments_all aip,
1236: ap_payment_history_all aph,
1237: xla_ae_lines xal
1238: WHERE aid.invoice_id = ai.invoice_id
1239: AND aid.invoice_id = aip.invoice_id

Line 1256: ap_invoice_payments_all aip,

1252: SELECT sum(aphd.amount), -- discount amount (entered)
1253: sum(aphd.paid_base_amount) -- discount amount (accounted)
1254: FROM ap_invoice_distributions_all aid,
1255: ap_invoices_all ai,
1256: ap_invoice_payments_all aip,
1257: ap_payment_hist_dists aphd,
1258: ap_payment_history_all aph
1259: WHERE aid.invoice_id = ai.invoice_id
1260: AND aid.invoice_id = aip.invoice_id

Line 1275: ap_invoice_payments_all aip,

1271: xal.accounted_dr -xal.entered_cr
1272: -- discount entered amount (replace this with new xla colum names)
1273: FROM ap_invoice_distributions_all aid,
1274: ap_invoices_all ai,
1275: ap_invoice_payments_all aip,
1276: ap_payment_history_all aph,
1277: xla_ae_lines xal
1278: WHERE aid.invoice_id = ai.invoice_id
1279: AND aid.invoice_id = aip.invoice_id

Line 1294: ap_invoice_payments_all aip,

1290: SELECT sum(aphd.amount), -- discount amount (entered)
1291: sum(aphd.paid_base_amount) -- discount amount (accounted)
1292: FROM ap_invoice_distributions_all aid,
1293: ap_invoices_all ai,
1294: ap_invoice_payments_all aip,
1295: ap_payment_hist_dists aphd,
1296: ap_payment_history_all aph
1297: WHERE aid.invoice_id = ai.invoice_id
1298: AND aid.invoice_id = aip.invoice_id

Line 1313: ap_invoice_payments_all aip,

1309: xal.accounted_dr -xal.entered_cr
1310: -- discount entered amount (replace this with new xla colum names)
1311: FROM ap_invoice_distributions_all aid,
1312: ap_invoices_all ai,
1313: ap_invoice_payments_all aip,
1314: ap_payment_history_all aph,
1315: xla_ae_lines xal
1316: WHERE aid.invoice_id = ai.invoice_id
1317: AND aid.invoice_id = aip.invoice_id

Line 1332: ap_invoice_payments_all aip,

1328: SELECT sum(aphd.amount), -- discount amount (entered)
1329: sum(aphd.paid_base_amount) -- discount amount (accounted)
1330: FROM ap_invoice_distributions_all aid,
1331: ap_invoices_all ai,
1332: ap_invoice_payments_all aip,
1333: ap_payment_hist_dists aphd,
1334: ap_payment_history_all aph
1335: WHERE aid.invoice_id = ai.invoice_id
1336: AND aid.invoice_id = aip.invoice_id

Line 1351: ap_invoice_payments_all aip,

1347: xal.accounted_dr -xal.entered_cr
1348: -- discount entered amount (replace this with new xla colum names)
1349: FROM ap_invoice_distributions_all aid,
1350: ap_invoices_all ai,
1351: ap_invoice_payments_all aip,
1352: ap_payment_history_all aph,
1353: xla_ae_lines xal
1354: WHERE aid.invoice_id = ai.invoice_id
1355: AND aid.invoice_id = aip.invoice_id

Line 1370: ap_invoice_payments_all aip,

1366: SELECT sum(aphd.amount), -- discount amount (entered)
1367: sum(aphd.paid_base_amount) -- discount amount (accounted)
1368: FROM ap_invoice_distributions_all aid,
1369: ap_invoices_all ai,
1370: ap_invoice_payments_all aip,
1371: ap_payment_hist_dists aphd,
1372: ap_payment_history_all aph
1373: WHERE aid.invoice_id = ai.invoice_id
1374: AND aid.invoice_id = aip.invoice_id

Line 1389: ap_invoice_payments_all aip,

1385: xal.accounted_dr -xal.entered_cr
1386: -- discount entered amount (replace this with new xla colum names)
1387: FROM ap_invoice_distributions_all aid,
1388: ap_invoices_all ai,
1389: ap_invoice_payments_all aip,
1390: ap_payment_history_all aph,
1391: xla_ae_lines xal
1392: WHERE aid.invoice_id = ai.invoice_id
1393: AND aid.invoice_id = aip.invoice_id