UDQ-1

NVL(EXTN_ATTRIBUTE_NUMBER015/100,0) HZ_REF_ENTITIES ATTRIBUTE_CATEGORY = 'OrderBasedAdjustmentOBA_c' AND CREATION_DATE = ( SELECT MAX(e1.CREATION_DATE) FROM HZ_REF_ENTITIES e1 WHERE e1. ATTRIBUTE_CATEGORY = 'OrderBasedAdjustmentOBA_c' AND ( (:2/*Number*/ IS NULL AND e1. EXTN_ATTRIBUTE_CHAR011 =:1/*VARCHAR2*/ AND e1. EXTN_ATTRIBUTE_NUMBER007 IS NULL AND e1. EXTN_ATTRIBUTE_NUMBER008 = ( SELECT TO_NUMBER(a.HR_PRIMARY_WORKER_NUMBER) FROM CN_SRP_PARTICIPANTS_ALL a WHERE a.PARTICIPANT_ID =:3/*Number*/ AND a. ORG_ID =:4/*Number*/ ) ) OR (:2/*Number*/ IS NOT NULL AND e1. EXTN_ATTRIBUTE_CHAR011 =:1/*VARCHAR2*/ AND e1. EXTN_ATTRIBUTE_NUMBER007 =:2/*Number*/ AND e1. EXTN_ATTRIBUTE_NUMBER008 = ( SELECT TO_NUMBER(a.HR_PRIMARY_WORKER_NUMBER) FROM CN_SRP_PARTICIPANTS_ALL a WHERE a.PARTICIPANT_ID =:3/*Number*/ AND a. ORG_ID =:4/*Number*/ ) ) ) )

Comments

Popular posts from this blog

Section 15-Done

Section 16-Done

Section 13-Done