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_INVOICES_ALL

Line 1172: ap_invoices_all ai,

1168: CURSOR taxable_hdr_csr IS
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

Line 1194: ap_invoices_all ai,

1190: -- discount entered amount (replace this with new xla colum names)
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

Line 1215: ap_invoices_all ai,

1211: CURSOR tax_hdr_csr IS
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

Line 1237: ap_invoices_all ai,

1233: -- discount entered amount (replace this with new xla colum names)
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

Line 1258: ap_invoices_all ai,

1254: CURSOR taxable_line_csr IS
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

Line 1277: ap_invoices_all ai,

1273: -- discount entered amount (replace this with new xla colum names)
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

Line 1296: ap_invoices_all ai,

1292: CURSOR tax_line_csr IS
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

Line 1315: ap_invoices_all ai,

1311: -- discount entered amount (replace this with new xla colum names)
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

Line 1334: ap_invoices_all ai,

1330: CURSOR taxable_dist_csr IS
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

Line 1353: ap_invoices_all ai,

1349: -- discount entered amount (replace this with new xla colum names)
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

Line 1372: ap_invoices_all ai,

1368: CURSOR tax_dist_csr IS
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

Line 1391: ap_invoices_all ai,

1387: -- discount entered amount (replace this with new xla colum names)
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