DBA Data[Home] [Help]

APPS.ZX_AP_ACTG_POPULATE_PKG dependencies on AP_PAYMENT_HIST_DISTS

Line 1174: ap_payment_hist_dists aphd,

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
1176: WHERE aid.invoice_id = ai.invoice_id
1177: AND aid.invoice_id = aip.invoice_id
1178: AND aid.distribution_line_number

Line 1217: ap_payment_hist_dists aphd,

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
1219: WHERE aid.invoice_id = ai.invoice_id
1220: AND aid.invoice_id = aip.invoice_id
1221: AND aid.distribution_line_number

Line 1260: ap_payment_hist_dists aphd,

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
1262: WHERE aid.invoice_id = ai.invoice_id
1263: AND aid.invoice_id = aip.invoice_id
1264: -- AND aid.distribution_line_number

Line 1298: ap_payment_hist_dists aphd,

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
1300: WHERE aid.invoice_id = ai.invoice_id
1301: AND aid.invoice_id = aip.invoice_id
1302: -- AND aid.distribution_line_number

Line 1336: ap_payment_hist_dists aphd,

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
1338: WHERE aid.invoice_id = ai.invoice_id
1339: AND aid.invoice_id = aip.invoice_id
1340: -- AND aid.distribution_line_number

Line 1374: ap_payment_hist_dists aphd,

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
1376: WHERE aid.invoice_id = ai.invoice_id
1377: AND aid.invoice_id = aip.invoice_id
1378: -- AND aid.distribution_line_number