APPS.FII_AR_TRX_DIST_F_C dependencies on AR_DISTRIBUTIONS_ALL

Line 1172: ar_distributions_all ad

1168: from ar_adjustments_all adj,
1169: xla_ae_headers xah,
1170: xla_ae_lines xal,
1171: xla_distribution_links xdl,
1172: ar_distributions_all ad
1173: where adj.last_update_date between g_push_from_date and g_push_to_date
1174: and nvl(adj.status, 'A') = 'A'
1175: and nvl(adj.postable,'Y') = 'Y'
1176: and adj.amount <> 0

Line 1184: and source_distribution_type='AR_DISTRIBUTIONS_ALL'

1180: and xah.ae_header_id=xal.ae_header_id
1181: and xal.ae_line_num=xdl.ae_line_num
1182: and xal.ae_header_id=xdl.ae_header_id
1183: and xdl.SOURCE_DISTRIBUTION_ID_NUM_1=ad.line_id
1184: and source_distribution_type='AR_DISTRIBUTIONS_ALL'
1185: and ad.source_id=adj.adjustment_id
1186: and ad.source_table='ADJ'
1187: and xah.ledger_id=adj.set_of_books_id
1188: and xah.balance_type_code='A'

Line 1203: ar_distributions_all ad

1199: ar_adjustments_all adj,
1200: xla_ae_headers xah,
1201: xla_ae_lines xal,
1202: xla_distribution_links xdl,
1203: ar_distributions_all ad
1204: where ct.last_update_date between g_push_from_date and g_push_to_date
1205: and ct.complete_flag = 'Y'
1206: and ct.customer_trx_id = adj.customer_trx_id
1207: and nvl(adj.status, 'A') = 'A'

Line 1217: and source_distribution_type='AR_DISTRIBUTIONS_ALL'

1213: and xah.ae_header_id=xal.ae_header_id
1214: and xal.ae_line_num=xdl.ae_line_num
1215: and xal.ae_header_id=xdl.ae_header_id
1216: and xdl.SOURCE_DISTRIBUTION_ID_NUM_1=ad.line_id
1217: and source_distribution_type='AR_DISTRIBUTIONS_ALL'
1218: and ad.source_id=adj.adjustment_id
1219: and ad.source_table='ADJ'
1220: and xah.ledger_id=adj.set_of_books_id
1221: and xah.balance_type_code='A'