APPS.FII_AR_TRX_DIST_F_C dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 1047: -- For ra_customer_trx_lines_all

1043: -- --------------------------------------------
1044: IF (p_mode = 'AR INVL') THEN
1045:
1046: -- -----------------------------------------
1047: -- For ra_customer_trx_lines_all
1048: -- -----------------------------------------
1049: Insert into fii_tmp_pk(
1050: SEQ_ID,
1051: primary_key1,

Line 1058: ra_customer_trx_lines_all ctlx

1054: l_seq_id,
1055: ctlx.customer_trx_line_id,
1056: p_mode
1057: from ra_customer_trx_all ct,
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

Line 1072: from ra_customer_trx_lines_all ctlx

1068: select /*+ PARALLEL(CTLX,4) */
1069: l_seq_id,
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);