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 1169: ap_invoices_all ai,

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

Line 1191: ap_invoices_all ai,

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

Line 1212: ap_invoices_all ai,

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

Line 1234: ap_invoices_all ai,

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

Line 1255: ap_invoices_all ai,

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

Line 1274: ap_invoices_all ai,

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

Line 1293: ap_invoices_all ai,

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

Line 1312: ap_invoices_all ai,

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

Line 1331: ap_invoices_all ai,

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

Line 1350: ap_invoices_all ai,

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

Line 1369: ap_invoices_all ai,

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

Line 1388: ap_invoices_all ai,

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