DBA Data[Home] [Help]

APPS.FII_AR_TRX_DIST_F_C dependencies on XLA_DISTRIBUTION_LINKS

Line 1104: xla_distribution_links xdl

1100: xal.code_combination_id
1101: from ra_cust_trx_line_gl_dist_all ctlgd,
1102: xla_ae_headers xah,
1103: xla_ae_lines xal,
1104: xla_distribution_links xdl
1105: where ctlgd.last_update_date between g_push_from_date and g_push_to_date
1106: and ctlgd.account_set_flag = 'N'
1107: and xah.application_id=222
1108: and xal.application_id=222

Line 1129: xla_distribution_links xdl

1125: from fii_tmp_pk ftr,
1126: ra_cust_trx_line_gl_dist_all ctlgd,
1127: xla_ae_headers xah,
1128: xla_ae_lines xal,
1129: xla_distribution_links xdl
1130: where ftr.seq_id = p_parent_seq_id
1131: and ftr.primary_key1 = ctlgd.customer_trx_line_id
1132: and ctlgd.account_set_flag = 'N'
1133: and xah.application_id=222

Line 1171: xla_distribution_links xdl,

1167: xal.code_combination_id
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'

Line 1202: xla_distribution_links xdl,

1198: from ra_customer_trx_all ct,
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