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 1168: FROM ap_invoice_distributions_all aid,

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

Line 1177: FROM ap_invoice_distributions_all

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

Line 1190: FROM ap_invoice_distributions_all aid,

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

Line 1199: FROM ap_invoice_distributions_all

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

Line 1211: FROM ap_invoice_distributions_all aid,

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

Line 1220: FROM ap_invoice_distributions_all

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

Line 1233: FROM ap_invoice_distributions_all aid,

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

Line 1242: FROM ap_invoice_distributions_all

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

Line 1254: FROM ap_invoice_distributions_all aid,

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

Line 1273: FROM ap_invoice_distributions_all aid,

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

Line 1292: FROM ap_invoice_distributions_all aid,

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

Line 1311: FROM ap_invoice_distributions_all aid,

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

Line 1330: FROM ap_invoice_distributions_all aid,

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

Line 1349: FROM ap_invoice_distributions_all aid,

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

Line 1368: FROM ap_invoice_distributions_all aid,

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

Line 1387: FROM ap_invoice_distributions_all aid,

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