APPS.FII_AR_TRX_DIST_F_C dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 1062: and exists (select 1 from ra_cust_trx_line_gl_dist_all ctlgd

1058: ra_customer_trx_lines_all ctlx
1059: where ct.last_update_date between g_push_from_date and g_push_to_date
1060: and ct.complete_flag = 'Y'
1061: and ct.customer_trx_id = ctlx.customer_trx_id
1062: and exists (select 1 from ra_cust_trx_line_gl_dist_all ctlgd
1063: where ctlgd.customer_trx_line_id=ctlx.customer_trx_line_id
1064: and ctlgd.posting_control_id <> -3)
1065: --added exists clause for SLA Uptake
1066:

Line 1074: and exists (select 1 from ra_cust_trx_line_gl_dist_all ctlgd

1070: ctlx.customer_trx_line_id,
1071: p_mode
1072: from ra_customer_trx_lines_all ctlx
1073: where ctlx.last_update_date between g_push_from_date and g_push_to_date
1074: and exists (select 1 from ra_cust_trx_line_gl_dist_all ctlgd
1075: where ctlgd.customer_trx_line_id=ctlx.customer_trx_line_id
1076: and ctlgd.posting_control_id <> -3);
1077: --added exists clause for SLA Uptake
1078:

Line 1082: -- For ra_cust_trx_line_gl_dist_all

1078:
1079:
1080: ELSIF (p_mode = 'AR DL') THEN
1081: -- -----------------------------------------
1082: -- For ra_cust_trx_line_gl_dist_all
1083: -- -----------------------------------------
1084: -- --------------------------------------------------------------------------------------------------
1085: -- The variable g_acct_or_inv_date is added in the below mentioned select statement.
1086: -- The profile option stored in the global variable g_acct_or_inv_date

Line 1101: from ra_cust_trx_line_gl_dist_all ctlgd,

1097: ctlgd.cust_trx_line_gl_dist_id,
1098: p_mode,
1099: g_acct_or_inv_date,
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

Line 1114: and xdl.source_distribution_type='RA_CUST_TRX_LINE_GL_DIST_ALL'

1110: and xah.ae_header_id=xal.ae_header_id
1111: and xal.ae_line_num=xdl.ae_line_num
1112: and xal.ae_header_id=xdl.ae_header_id
1113: and xdl.SOURCE_DISTRIBUTION_ID_NUM_1=ctlgd.cust_trx_line_gl_dist_id
1114: and xdl.source_distribution_type='RA_CUST_TRX_LINE_GL_DIST_ALL'
1115: and xah.ledger_id=ctlgd.set_of_books_id
1116: and xah.balance_type_code='A'
1117:
1118: UNION

Line 1126: ra_cust_trx_line_gl_dist_all ctlgd,

1122: p_mode,
1123: g_acct_or_inv_date,
1124: xal.code_combination_id
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

Line 1140: and xdl.source_distribution_type='RA_CUST_TRX_LINE_GL_DIST_ALL'

1136: and xah.ae_header_id=xal.ae_header_id
1137: and xal.ae_line_num=xdl.ae_line_num
1138: and xal.ae_header_id=xdl.ae_header_id
1139: and xdl.SOURCE_DISTRIBUTION_ID_NUM_1=ctlgd.cust_trx_line_gl_dist_id
1140: and xdl.source_distribution_type='RA_CUST_TRX_LINE_GL_DIST_ALL'
1141: and xah.ledger_id=ctlgd.set_of_books_id
1142: and xah.balance_type_code='A'
1143: UNION
1144: select l_seq_id,