SLA Condition check with ADR

SLA Condition check with ADR
---------------------------------------------


SELECT USER_SEQUENCE,A.VALUE_CONSTANT, A.ORGANIZATION_CODE, A.ORGANIZATION_NAME,O1.ORGANIZATION_CODE, O1.ORGANIZATION_NAME,CONDITION_ID, ou.ORGANIZATION_ID ou_id, ou.NAME ou_name,
ou.SHORT_CODE ou_short_name, gcc.segment1, gcc.CONCATENATED_SEGMENTS, a.name, EVENT_CLASS_NAME, EVENT_TYPE_NAME,  JLD_CODE,ACCOUNTING_LINE_CODE,  ADR_NAME, ADR_CODE , A.ADR_DESC
 FROM
(
SELECT seq.USER_SEQUENCE, CTN.VALUE_CONSTANT, o.ORGANIZATION_CODE, o.ORGANIZATION_NAME,CTN.CONDITION_ID, srd.VALUE_CODE_COMBINATION_ID, name, E.EVENT_CLASS_NAME, E.EVENT_TYPE_NAME, C.LINE_DEFINITION_CODE JLD_CODE,C.ACCOUNTING_LINE_CODE, SEGMENT_RULE_NAME ADR_NAME,C.SEGMENT_RULE_CODE ADR_CODE , SEGMENT_RULE_DESC ADR_DESC
FROM xla_seg_rules_b srb,xla_seg_rules_tl srl,fnd_application_tl apl,xla_seg_rule_details srd, xla_conditions ctn,XLA_SEG_RULE_DETAILS seq
, ORG_ORGANIZATION_DEFINITIONS O,xla_line_defn_adr_assgns_f_v c,xla_line_defn_jlt_assgns_f_v D, xla_prod_acct_headers_fvl e
WHERE apl.APPLICATION_ID=555 and apl.APPLICATION_ID=srb.APPLICATION_ID
AND SRB.SEGMENT_RULE_CODE= C.SEGMENT_RULE_CODE AND SRB.SEGMENT_RULE_CODE=  :rule_code
AND SRB.APPLICATION_ID=SRL.APPLICATION_ID AND SRB.SEGMENT_RULE_CODE=SRL.SEGMENT_RULE_CODE
AND  SRB.APPLICATION_ID=SRD.APPLICATION_ID AND SRB.SEGMENT_RULE_CODE=SRD.SEGMENT_RULE_CODE
AND SRD.APPLICATION_ID=CTN.APPLICATION_ID AND SRD.SEGMENT_RULE_DETAIL_ID=CTN.SEGMENT_RULE_DETAIL_ID AND CTN.SOURCE_CODE='ORGANIZATION_CODE'
AND CTN.VALUE_CONSTANT=O.ORGANIZATION_CODE and srb.APPLICATION_ID=seq.APPLICATION_ID and srb.SEGMENT_RULE_CODE=seq.SEGMENT_RULE_CODE and srd.APPLICATION_ID=seq.APPLICATION_ID
AND SRD.SEGMENT_RULE_DETAIL_ID=SEQ.SEGMENT_RULE_DETAIL_ID
AND SEQ.APPLICATION_ID=C.APPLICATION_ID AND SEQ.SEGMENT_RULE_CODE=C.SEGMENT_RULE_CODE AND SEQ.SEGMENT_RULE_TYPE_CODE =C.SEGMENT_RULE_TYPE_CODE
  AND  C.APPLICATION_ID=D.APPLICATION_ID AND c.APPLICATION_ID=555
 AND C.ACCOUNTING_LINE_CODE =D.ACCOUNTING_LINE_CODE AND C.ACCOUNTING_LINE_TYPE_CODE=D.ACCOUNTING_LINE_TYPE_CODE AND C.EVENT_CLASS_CODE=D.EVENT_CLASS_CODE
 AND C.EVENT_TYPE_CODE=D.EVENT_TYPE_CODE AND C.SEGMENT_RULE_OWNER='User'
 AND C.LINE_DEFINITION_OWNER_CODE= D.LINE_DEFINITION_OWNER_CODE
 AND d.APPLICATION_ID=555 and d.APPLICATION_ID=e.APPLICATION_ID and d.EVENT_CLASS_CODE =e.EVENT_CLASS_CODE
 AND d.EVENT_TYPE_CODE=e.EVENT_TYPE_CODE
 and PRODUCT_RULE_CODE='PRG_PROCESS_MFG_FINANCIALS' and C.LINE_DEFINITION_OWNER_CODE='C'
) A,  ORG_ORGANIZATION_DEFINITIONS O1, hr_operating_units ou, gl_code_combinations_kfv gcc
 WHERE A.ORGANIZATION_CODE(+) =O1.ORGANIZATION_CODE and O1.operating_unit=ou.ORGANIZATION_ID and VALUE_CODE_COMBINATION_ID=gcc.CODE_COMBINATION_ID
 and ou.SHORT_CODE <> gcc.segment1
order by USER_SEQUENCE