DBA Data[Home] [Help]

APPS.ZX_AP_ACTG_POPULATE_PKG dependencies on AP_PAYMENT_HIST_DISTS

Line 1171: ap_payment_hist_dists aphd,

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

Line 1214: ap_payment_hist_dists aphd,

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

Line 1257: ap_payment_hist_dists aphd,

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

Line 1295: ap_payment_hist_dists aphd,

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

Line 1333: ap_payment_hist_dists aphd,

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

Line 1371: ap_payment_hist_dists aphd,

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