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