VIEW: APPS.IGS_OR_INST_ORG_BASE_V

Source

View Text - Preformatted

SELECT P.ROWID ROW_ID , P.PARTY_ID PARTY_ID , P.PARTY_NUMBER TCA_PARTY_NUMBER , PP.OSS_ORG_UNIT_CD PARTY_NUMBER, P.PARTY_NAME PARTY_NAME, PP.OU_START_DT START_DATE , PP.OU_END_DT END_DATE , PP.INST_ORG_IND INST_ORG_IND, PP.OI_INSTITUTION_STATUS INSTITUTION_STATUS, PP.OU_ORG_STATUS ORG_STATUS, PP.INSTITUTION_CD OU_INSTITUTION_CD, PP.OI_LOCAL_INSTITUTION_IND , PP.OI_GOVT_INSTITUTION_CD , PP.OI_INST_CONTROL_TYPE , PP.OI_INSTITUTION_TYPE , PP.OU_MEMBER_TYPE , PP.OU_ORG_TYPE FROM HZ_PARTIES P, IGS_PE_HZ_PARTIES PP WHERE P.PARTY_ID = PP.PARTY_ID AND P.STATUS = 'A' AND PP.INST_ORG_IND IS NOT NULL

View Text - HTML Formatted

SELECT P.ROWID ROW_ID
, P.PARTY_ID PARTY_ID
, P.PARTY_NUMBER TCA_PARTY_NUMBER
, PP.OSS_ORG_UNIT_CD PARTY_NUMBER
, P.PARTY_NAME PARTY_NAME
, PP.OU_START_DT START_DATE
, PP.OU_END_DT END_DATE
, PP.INST_ORG_IND INST_ORG_IND
, PP.OI_INSTITUTION_STATUS INSTITUTION_STATUS
, PP.OU_ORG_STATUS ORG_STATUS
, PP.INSTITUTION_CD OU_INSTITUTION_CD
, PP.OI_LOCAL_INSTITUTION_IND
, PP.OI_GOVT_INSTITUTION_CD
, PP.OI_INST_CONTROL_TYPE
, PP.OI_INSTITUTION_TYPE
, PP.OU_MEMBER_TYPE
, PP.OU_ORG_TYPE
FROM HZ_PARTIES P
, IGS_PE_HZ_PARTIES PP
WHERE P.PARTY_ID = PP.PARTY_ID
AND P.STATUS = 'A'
AND PP.INST_ORG_IND IS NOT NULL