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 1172: ap_payment_history_all aph

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
1174: AND aid.invoice_id = aip.invoice_id
1175: AND aid.distribution_line_number
1176: IN (SELECT distribution_line_number

Line 1193: ap_payment_history_all aph,

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
1196: AND aid.invoice_id = aip.invoice_id
1197: AND aid.distribution_line_number

Line 1215: ap_payment_history_all aph

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
1217: AND aid.invoice_id = aip.invoice_id
1218: AND aid.distribution_line_number
1219: IN (SELECT distribution_line_number

Line 1236: ap_payment_history_all aph,

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
1239: AND aid.invoice_id = aip.invoice_id
1240: AND aid.distribution_line_number

Line 1258: ap_payment_history_all aph

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
1260: AND aid.invoice_id = aip.invoice_id
1261: -- AND aid.distribution_line_number
1262: AND aid.invoice_distribution_id = p_trx_line_id

Line 1276: ap_payment_history_all aph,

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
1279: AND aid.invoice_id = aip.invoice_id
1280: -- AND aid.distribution_line_number

Line 1296: ap_payment_history_all aph

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
1298: AND aid.invoice_id = aip.invoice_id
1299: -- AND aid.distribution_line_number
1300: AND aid.invoice_distribution_id = p_tax_line_id

Line 1314: ap_payment_history_all aph,

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
1317: AND aid.invoice_id = aip.invoice_id
1318: -- AND aid.distribution_line_number

Line 1334: ap_payment_history_all aph

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
1336: AND aid.invoice_id = aip.invoice_id
1337: -- AND aid.distribution_line_number
1338: AND aid.invoice_distribution_id = p_trx_line_id

Line 1352: ap_payment_history_all aph,

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
1355: AND aid.invoice_id = aip.invoice_id
1356: -- AND aid.distribution_line_number

Line 1372: ap_payment_history_all aph

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
1374: AND aid.invoice_id = aip.invoice_id
1375: -- AND aid.distribution_line_number
1376: AND aid.invoice_distribution_id = p_tax_line_id

Line 1390: ap_payment_history_all aph,

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
1393: AND aid.invoice_id = aip.invoice_id
1394: -- AND aid.distribution_line_number