[Home] [Help]
673: AND NVL(p_org_id,adj.org_id) = adj.org_id
674: AND adj.status = 'A'
675: AND NOT EXISTS
676: (SELECT NULL
677: FROM xla_distribution_links lk,
678: xla_ae_lines ae
679: WHERE ard.line_id = lk.source_distribution_id_num_1
680: AND lk.application_id = 222
681: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
768: 'GUAR','GUAR','EXCLUDE'),
769: p_type) = tty.type
770: AND NOT EXISTS
771: (SELECT NULL
772: FROM xla_distribution_links lk,
773: xla_ae_lines ae
774: WHERE ctlgd.cust_trx_line_gl_dist_id = lk.source_distribution_id_num_1
775: AND lk.application_id = 222
776: AND lk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
864: 'ALL',cr.type,
865: p_type) = cr.type
866: AND NOT EXISTS
867: (SELECT NULL
868: FROM xla_distribution_links lk,
869: xla_ae_lines ae
870: WHERE ard.line_id = lk.source_distribution_id_num_1
871: AND lk.application_id = 222
872: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
960: DECODE(ra.customer_trx_id,NULL,NULL,'CMAPP'),
961: 'APP')) = p_type
962: AND NOT EXISTS
963: (SELECT NULL
964: FROM xla_distribution_links lk,
965: xla_ae_lines ae
966: WHERE ard.line_id = lk.source_distribution_id_num_1
967: AND lk.application_id = 222
968: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1047: AND th.posting_control_id = -3
1048: AND NVL(p_org_id,th.org_id) = th.org_id
1049: AND NOT EXISTS
1050: (SELECT NULL
1051: FROM xla_distribution_links lk,
1052: xla_ae_lines ae
1053: WHERE ard.line_id = lk.source_distribution_id_num_1
1054: AND lk.application_id = 222
1055: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'