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_PAYMENT_HISTORY_ALL

Line 1175: ap_payment_history_all aph

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
1178: AND aid.distribution_line_number
1179: IN (SELECT distribution_line_number

Line 1196: ap_payment_history_all aph,

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
1200: AND aid.distribution_line_number

Line 1218: ap_payment_history_all aph

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
1221: AND aid.distribution_line_number
1222: IN (SELECT distribution_line_number

Line 1239: ap_payment_history_all aph,

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
1243: AND aid.distribution_line_number

Line 1261: ap_payment_history_all aph

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
1264: -- AND aid.distribution_line_number
1265: AND aid.invoice_distribution_id = p_trx_line_id

Line 1279: ap_payment_history_all aph,

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
1283: -- AND aid.distribution_line_number

Line 1299: ap_payment_history_all aph

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
1302: -- AND aid.distribution_line_number
1303: AND aid.invoice_distribution_id = p_tax_line_id

Line 1317: ap_payment_history_all aph,

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
1321: -- AND aid.distribution_line_number

Line 1337: ap_payment_history_all aph

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
1340: -- AND aid.distribution_line_number
1341: AND aid.invoice_distribution_id = p_trx_line_id

Line 1355: ap_payment_history_all aph,

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
1359: -- AND aid.distribution_line_number

Line 1375: ap_payment_history_all aph

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
1378: -- AND aid.distribution_line_number
1379: AND aid.invoice_distribution_id = p_tax_line_id

Line 1393: ap_payment_history_all aph,

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
1397: -- AND aid.distribution_line_number