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_DISTRIBUTIONS_ALL

Line 1171: FROM ap_invoice_distributions_all aid,

1167:
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

Line 1180: FROM ap_invoice_distributions_all

1176: WHERE aid.invoice_id = ai.invoice_id
1177: AND aid.invoice_id = aip.invoice_id
1178: AND aid.distribution_line_number
1179: IN (SELECT distribution_line_number
1180: FROM ap_invoice_distributions_all
1181: WHERE invoice_id = p_trx_id
1182: AND line_type_lookup_code = 'ITEM')
1183: AND aip.invoice_payment_id = aphd.invoice_payment_id
1184: AND aphd.PAY_DIST_LOOKUP_CODE = 'DISCOUNT'

Line 1193: FROM ap_invoice_distributions_all aid,

1189: SELECT xal.entered_dr - xal.entered_cr ,
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

Line 1202: FROM ap_invoice_distributions_all

1198: WHERE aid.invoice_id = ai.invoice_id
1199: AND aid.invoice_id = aip.invoice_id
1200: AND aid.distribution_line_number
1201: IN (SELECT distribution_line_number
1202: FROM ap_invoice_distributions_all
1203: WHERE invoice_id = p_trx_id
1204: AND line_type_lookup_code = 'ITEM')
1205: AND aip.invoice_payment_id = xal.Upg_Tax_Reference_ID3
1206: AND aid.old_dist_line_number = xal.Upg_Tax_Reference_ID2

Line 1214: FROM ap_invoice_distributions_all aid,

1210:
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

Line 1223: FROM ap_invoice_distributions_all

1219: WHERE aid.invoice_id = ai.invoice_id
1220: AND aid.invoice_id = aip.invoice_id
1221: AND aid.distribution_line_number
1222: IN (SELECT distribution_line_number
1223: FROM ap_invoice_distributions_all
1224: WHERE invoice_id = p_trx_id
1225: AND line_type_lookup_code = 'TAX')
1226: AND aip.invoice_payment_id = aphd.invoice_payment_id
1227: AND aphd.PAY_DIST_LOOKUP_CODE = 'DISCOUNT'

Line 1236: FROM ap_invoice_distributions_all aid,

1232: SELECT xal.entered_dr - xal.entered_cr ,
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

Line 1245: FROM ap_invoice_distributions_all

1241: WHERE aid.invoice_id = ai.invoice_id
1242: AND aid.invoice_id = aip.invoice_id
1243: AND aid.distribution_line_number
1244: IN (SELECT distribution_line_number
1245: FROM ap_invoice_distributions_all
1246: WHERE invoice_id = p_trx_id
1247: AND line_type_lookup_code = 'TAX')
1248: AND aip.invoice_payment_id = xal.Upg_Tax_Reference_ID3
1249: AND aid.old_dist_line_number = xal.Upg_Tax_Reference_ID2

Line 1257: FROM ap_invoice_distributions_all aid,

1253:
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

Line 1276: FROM ap_invoice_distributions_all aid,

1272: SELECT xal.entered_dr - xal.entered_cr ,
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

Line 1295: FROM ap_invoice_distributions_all aid,

1291:
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

Line 1314: FROM ap_invoice_distributions_all aid,

1310: SELECT xal.entered_dr - xal.entered_cr ,
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

Line 1333: FROM ap_invoice_distributions_all aid,

1329:
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

Line 1352: FROM ap_invoice_distributions_all aid,

1348: SELECT xal.entered_dr - xal.entered_cr ,
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

Line 1371: FROM ap_invoice_distributions_all aid,

1367:
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

Line 1390: FROM ap_invoice_distributions_all aid,

1386: SELECT xal.entered_dr - xal.entered_cr ,
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