VIEW: APPS.IEX_BKR_LEGAL_CNT_V

Source

View Text - Preformatted

SELECT BKR.BANKRUPTCY_ID BANKRUPTCY_ID, BKR.DELINQUENCY_ID DELINQUENCY_ID, BKR.FIRM_CONTACT_ID FIRM_CONTACT_ID, FRM.PARTY_NAME FIRM_NAME, FRM.ADDRESS1 FIRM_ADDRESS1, FRM.ADDRESS2 FIRM_ADDRESS2, FRM.CITY FIRM_CITY, FRM.COUNTY FIRM_COUNTY, FRM.STATE FIRM_STATE, FRM.POSTAL_CODE FIRM_POSTAL_CODE, FRM_PHONE.PHONE_NUMBER FIRM_PHONE_NUMBER, FRM_EMAIL.EMAIL_ADDRESS FIRM_EMAIL, FRM_FAX.TELEX_NUMBER FIRM_FAX, BKR.COUNSEL_CONTACT_ID, CNSL.PARTY_NAME COUNSIL_NAME, CNSL.ADDRESS1 COUNSIL_ADDRESS1, CNSL.ADDRESS2 COUNSIL_ADDRESS2, CNSL.CITY COUNSIL_CITY, CNSL.COUNTY COUNSIL_COUNTY, CNSL.STATE COUNSIL_STATE, CNSL.POSTAL_CODE COUNSIL_POSTAL_CODE, CNSL_PHONE.PHONE_NUMBER COUNSIL_PHONE_NUMBER, CNSL_EMAIL.EMAIL_ADDRESS COUNSIL_EMAIL, CNSL_FAX.TELEX_NUMBER COUNSIL_FAX, BKR.FEE_PAID_DATE FEE_PAID_DATE, BKR.REAFFIRMATION_DATE REAFFIRMATION_DATE, BKR.RELIEF_STAY_DATE RELIEF_STAY_DATE, BKR.TRUSTEE_CONTACT_ID, TRST.PARTY_NAME TRUSTEE_NAME, TRST.ADDRESS1 TRUSTEE_ADDRESS1, TRST.ADDRESS2 TRUSTEE_ADDRESS2, TRST.CITY TRUSTEE_CITY, TRST.COUNTY TRUSTEE_COUNTY, TRST.STATE TRUSTEE_STATE, TRST.POSTAL_CODE TRUSTEE_POSTAL_CODE, TRST_PHONE.PHONE_NUMBER TRUSTEE_PHONE_NUMBER, TRST_EMAIL.EMAIL_ADDRESS TRUSTEE_EMAIL, TRST_FAX.TELEX_NUMBER TRUSTEE_FAX, BKR.DISPOSITION_CODE DISPOSITION_CODE, LK.MEANING DISPOSITION_MEANING FROM IEX_BANKRUPTCIES BKR, HZ_PARTIES FRM, HZ_PARTIES CNSL, HZ_PARTIES TRST, HZ_CONTACT_POINTS FRM_PHONE, HZ_CONTACT_POINTS CNSL_PHONE, HZ_CONTACT_POINTS TRST_PHONE, HZ_CONTACT_POINTS FRM_FAX, HZ_CONTACT_POINTS CNSL_FAX, HZ_CONTACT_POINTS TRST_FAX, HZ_CONTACT_POINTS FRM_EMAIL, HZ_CONTACT_POINTS CNSL_EMAIL, HZ_CONTACT_POINTS TRST_EMAIL, IEX_LOOKUPS_V LK WHERE BKR.FIRM_CONTACT_ID = FRM.PARTY_ID(+) AND FRM.PARTY_ID = FRM_PHONE.OWNER_TABLE_ID(+) AND FRM_PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND FRM_PHONE.CONTACT_POINT_TYPE(+) = 'PHONE' AND FRM_PHONE.PRIMARY_FLAG(+) = 'Y' AND FRM_PHONE.STATUS(+) = 'A' AND BKR.COUNSEL_CONTACT_ID = CNSL.PARTY_ID(+) AND CNSL.PARTY_ID = CNSL_PHONE.OWNER_TABLE_ID(+) AND CNSL_PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND CNSL_PHONE.CONTACT_POINT_TYPE(+) = 'PHONE' AND CNSL_PHONE.PRIMARY_FLAG(+) = 'Y' AND CNSL_PHONE.STATUS(+) = 'A' AND BKR.TRUSTEE_CONTACT_ID = TRST.PARTY_ID(+) AND TRST.PARTY_ID = TRST_PHONE.OWNER_TABLE_ID(+) AND TRST_PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND TRST_PHONE.CONTACT_POINT_TYPE(+) = 'PHONE' AND TRST_PHONE.PRIMARY_FLAG(+) = 'Y' AND TRST_PHONE.STATUS(+) = 'A' AND FRM.PARTY_ID = FRM_FAX.OWNER_TABLE_ID(+) AND FRM_FAX.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND FRM_FAX.CONTACT_POINT_TYPE(+) = 'FAX' AND FRM_FAX.PRIMARY_FLAG(+) = 'Y' AND FRM_FAX.STATUS(+) = 'A' AND CNSL.PARTY_ID = CNSL_FAX.OWNER_TABLE_ID(+) AND CNSL_FAX.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND CNSL_FAX.CONTACT_POINT_TYPE(+) = 'FAX' AND CNSL_FAX.PRIMARY_FLAG(+) = 'Y' AND CNSL_FAX.STATUS(+) = 'A' AND TRST.PARTY_ID = TRST_FAX.OWNER_TABLE_ID(+) AND TRST_FAX.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND TRST_FAX.CONTACT_POINT_TYPE(+) = 'FAX' AND TRST_FAX.PRIMARY_FLAG(+) = 'Y' AND TRST_FAX.STATUS(+) = 'A' AND FRM.PARTY_ID = FRM_EMAIL.OWNER_TABLE_ID(+) AND FRM_EMAIL.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND FRM_EMAIL.CONTACT_POINT_TYPE(+) = 'EMAIL' AND FRM_EMAIL.PRIMARY_FLAG(+) = 'Y' AND FRM_EMAIL.STATUS(+) = 'A' AND CNSL.PARTY_ID = CNSL_EMAIL.OWNER_TABLE_ID(+) AND CNSL_EMAIL.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND CNSL_EMAIL.CONTACT_POINT_TYPE(+) = 'EMAIL' AND CNSL_EMAIL.PRIMARY_FLAG(+) = 'Y' AND CNSL_EMAIL.STATUS(+) = 'A' AND TRST.PARTY_ID = TRST_EMAIL.OWNER_TABLE_ID(+) AND TRST_EMAIL.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND TRST_EMAIL.CONTACT_POINT_TYPE(+) = 'EMAIL' AND TRST_EMAIL.PRIMARY_FLAG(+) = 'Y' AND TRST_EMAIL.STATUS(+) = 'A' AND BKR.DISPOSITION_CODE = LK.LOOKUP_CODE(+) AND LK.LOOKUP_TYPE(+) = 'IEX_BKR_DISPOSITION'

View Text - HTML Formatted

SELECT BKR.BANKRUPTCY_ID BANKRUPTCY_ID
, BKR.DELINQUENCY_ID DELINQUENCY_ID
, BKR.FIRM_CONTACT_ID FIRM_CONTACT_ID
, FRM.PARTY_NAME FIRM_NAME
, FRM.ADDRESS1 FIRM_ADDRESS1
, FRM.ADDRESS2 FIRM_ADDRESS2
, FRM.CITY FIRM_CITY
, FRM.COUNTY FIRM_COUNTY
, FRM.STATE FIRM_STATE
, FRM.POSTAL_CODE FIRM_POSTAL_CODE
, FRM_PHONE.PHONE_NUMBER FIRM_PHONE_NUMBER
, FRM_EMAIL.EMAIL_ADDRESS FIRM_EMAIL
, FRM_FAX.TELEX_NUMBER FIRM_FAX
, BKR.COUNSEL_CONTACT_ID
, CNSL.PARTY_NAME COUNSIL_NAME
, CNSL.ADDRESS1 COUNSIL_ADDRESS1
, CNSL.ADDRESS2 COUNSIL_ADDRESS2
, CNSL.CITY COUNSIL_CITY
, CNSL.COUNTY COUNSIL_COUNTY
, CNSL.STATE COUNSIL_STATE
, CNSL.POSTAL_CODE COUNSIL_POSTAL_CODE
, CNSL_PHONE.PHONE_NUMBER COUNSIL_PHONE_NUMBER
, CNSL_EMAIL.EMAIL_ADDRESS COUNSIL_EMAIL
, CNSL_FAX.TELEX_NUMBER COUNSIL_FAX
, BKR.FEE_PAID_DATE FEE_PAID_DATE
, BKR.REAFFIRMATION_DATE REAFFIRMATION_DATE
, BKR.RELIEF_STAY_DATE RELIEF_STAY_DATE
, BKR.TRUSTEE_CONTACT_ID
, TRST.PARTY_NAME TRUSTEE_NAME
, TRST.ADDRESS1 TRUSTEE_ADDRESS1
, TRST.ADDRESS2 TRUSTEE_ADDRESS2
, TRST.CITY TRUSTEE_CITY
, TRST.COUNTY TRUSTEE_COUNTY
, TRST.STATE TRUSTEE_STATE
, TRST.POSTAL_CODE TRUSTEE_POSTAL_CODE
, TRST_PHONE.PHONE_NUMBER TRUSTEE_PHONE_NUMBER
, TRST_EMAIL.EMAIL_ADDRESS TRUSTEE_EMAIL
, TRST_FAX.TELEX_NUMBER TRUSTEE_FAX
, BKR.DISPOSITION_CODE DISPOSITION_CODE
, LK.MEANING DISPOSITION_MEANING
FROM IEX_BANKRUPTCIES BKR
, HZ_PARTIES FRM
, HZ_PARTIES CNSL
, HZ_PARTIES TRST
, HZ_CONTACT_POINTS FRM_PHONE
, HZ_CONTACT_POINTS CNSL_PHONE
, HZ_CONTACT_POINTS TRST_PHONE
, HZ_CONTACT_POINTS FRM_FAX
, HZ_CONTACT_POINTS CNSL_FAX
, HZ_CONTACT_POINTS TRST_FAX
, HZ_CONTACT_POINTS FRM_EMAIL
, HZ_CONTACT_POINTS CNSL_EMAIL
, HZ_CONTACT_POINTS TRST_EMAIL
, IEX_LOOKUPS_V LK
WHERE BKR.FIRM_CONTACT_ID = FRM.PARTY_ID(+)
AND FRM.PARTY_ID = FRM_PHONE.OWNER_TABLE_ID(+)
AND FRM_PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND FRM_PHONE.CONTACT_POINT_TYPE(+) = 'PHONE'
AND FRM_PHONE.PRIMARY_FLAG(+) = 'Y'
AND FRM_PHONE.STATUS(+) = 'A'
AND BKR.COUNSEL_CONTACT_ID = CNSL.PARTY_ID(+)
AND CNSL.PARTY_ID = CNSL_PHONE.OWNER_TABLE_ID(+)
AND CNSL_PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CNSL_PHONE.CONTACT_POINT_TYPE(+) = 'PHONE'
AND CNSL_PHONE.PRIMARY_FLAG(+) = 'Y'
AND CNSL_PHONE.STATUS(+) = 'A'
AND BKR.TRUSTEE_CONTACT_ID = TRST.PARTY_ID(+)
AND TRST.PARTY_ID = TRST_PHONE.OWNER_TABLE_ID(+)
AND TRST_PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND TRST_PHONE.CONTACT_POINT_TYPE(+) = 'PHONE'
AND TRST_PHONE.PRIMARY_FLAG(+) = 'Y'
AND TRST_PHONE.STATUS(+) = 'A'
AND FRM.PARTY_ID = FRM_FAX.OWNER_TABLE_ID(+)
AND FRM_FAX.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND FRM_FAX.CONTACT_POINT_TYPE(+) = 'FAX'
AND FRM_FAX.PRIMARY_FLAG(+) = 'Y'
AND FRM_FAX.STATUS(+) = 'A'
AND CNSL.PARTY_ID = CNSL_FAX.OWNER_TABLE_ID(+)
AND CNSL_FAX.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CNSL_FAX.CONTACT_POINT_TYPE(+) = 'FAX'
AND CNSL_FAX.PRIMARY_FLAG(+) = 'Y'
AND CNSL_FAX.STATUS(+) = 'A'
AND TRST.PARTY_ID = TRST_FAX.OWNER_TABLE_ID(+)
AND TRST_FAX.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND TRST_FAX.CONTACT_POINT_TYPE(+) = 'FAX'
AND TRST_FAX.PRIMARY_FLAG(+) = 'Y'
AND TRST_FAX.STATUS(+) = 'A'
AND FRM.PARTY_ID = FRM_EMAIL.OWNER_TABLE_ID(+)
AND FRM_EMAIL.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND FRM_EMAIL.CONTACT_POINT_TYPE(+) = 'EMAIL'
AND FRM_EMAIL.PRIMARY_FLAG(+) = 'Y'
AND FRM_EMAIL.STATUS(+) = 'A'
AND CNSL.PARTY_ID = CNSL_EMAIL.OWNER_TABLE_ID(+)
AND CNSL_EMAIL.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CNSL_EMAIL.CONTACT_POINT_TYPE(+) = 'EMAIL'
AND CNSL_EMAIL.PRIMARY_FLAG(+) = 'Y'
AND CNSL_EMAIL.STATUS(+) = 'A'
AND TRST.PARTY_ID = TRST_EMAIL.OWNER_TABLE_ID(+)
AND TRST_EMAIL.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND TRST_EMAIL.CONTACT_POINT_TYPE(+) = 'EMAIL'
AND TRST_EMAIL.PRIMARY_FLAG(+) = 'Y'
AND TRST_EMAIL.STATUS(+) = 'A'
AND BKR.DISPOSITION_CODE = LK.LOOKUP_CODE(+)
AND LK.LOOKUP_TYPE(+) = 'IEX_BKR_DISPOSITION'