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 1173: ap_invoice_payments_all aip,

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

Line 1195: ap_invoice_payments_all aip,

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

Line 1216: ap_invoice_payments_all aip,

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

Line 1238: ap_invoice_payments_all aip,

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

Line 1259: ap_invoice_payments_all aip,

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

Line 1278: ap_invoice_payments_all aip,

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

Line 1297: ap_invoice_payments_all aip,

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

Line 1316: ap_invoice_payments_all aip,

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

Line 1335: ap_invoice_payments_all aip,

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

Line 1354: ap_invoice_payments_all aip,

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

Line 1373: ap_invoice_payments_all aip,

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

Line 1392: ap_invoice_payments_all aip,

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