VIEW: APPS.IEX_BKR_FILING_V

Source

View Text - Preformatted

SELECT BKR.BANKRUPTCY_ID BANKRUPTCY_ID, BKR.DELINQUENCY_ID DELINQUENCY_ID, BKR.FILE_CONTACT_ID FILE_CONTACT_ID, BKR.CHAPTER_CODE CHAPTER_CODE, BKR.BANKRUPTCY_FILE_DATE BANKRUPTCY_FILE_DATE, FIL.PARTY_NAME FILING_NAME, FIL.ADDRESS1 FILING_ADDRESS1, FIL.ADDRESS2 FILING_ADDRESS2, FIL.CITY FILING_CITY, FIL.COUNTY FILING_COUNTY, FIL.STATE FILING_STATE, FIL.POSTAL_CODE FILING_POSTAL_CODE, FIL_PHONE.PHONE_NUMBER FILING_PHONE_NUMBER, BKR.COURT_ID COURT_ID, CRT.PARTY_NAME COURT_NAME, BKR.CASE_NUMBER CASE_NUMBER, COURT_CLERK_CONTACT_ID COURT_CLERK_CONTACT_ID, CNT.PARTY_NAME COURT_CLERK_CONTACT_NAME, CRT.ADDRESS1 COURT_ADDRESS1, CRT.ADDRESS2 COURT_ADDRESS2, CRT.CITY COURT_CITY, CRT.COUNTY COURT_COUNTY, CRT.STATE COURT_STATE, CRT.POSTAL_CODE COURT_POSTAL_CODE, CRT_PHONE.PHONE_NUMBER COURT_PHONE_NUMBER, BKR.FUNDING_DATE FUNDING_DATE, BKR.COURT_ORDER_DATE COURT_ORDER_DATE, BKR.OBJECT_BAR_DATE OBJECT_BAR_DATE, BKR.REPOSSESSION_DATE REPOSSESSION_DATE, BKR.DISMISSAL_DATE DISMISSAL_DATE, BKR.DATE_341A DATE_341A, BKR.DISCHARGE_DATE DISCHARGE_DATE, BKR.WITHDRAW_DATE WITHDRAW_DATE, BKR.CLOSE_DATE CLOSE_DATE, SYSDATE TBD_DATE, BKR.FILE_PROOF_CLAIM_YN FILE_PROOF_CLAIM_YN, BKR.NOTICE_ASSIGNMENT_YN NOTICE_ASSIGNMENT_YN, BKR.REQUEST_REPURCHASE_YN REQUEST_REPURCHASE_YN, BKR.DISPOSITION_CODE DISPOSITION_CODE, LK.MEANING DISPOSITION_MEANING FROM IEX_BANKRUPTCIES BKR, HZ_PARTIES FIL, HZ_CONTACT_POINTS FIL_PHONE, HZ_PARTIES CRT, HZ_CONTACT_POINTS CRT_PHONE, IEX_LOOKUPS_V LK, HZ_RELATIONSHIPS CNT_REL, HZ_PARTIES CNT WHERE BKR.FILE_CONTACT_ID = FIL.PARTY_ID(+) AND FIL_PHONE.OWNER_TABLE_ID(+) = FIL.PARTY_ID AND FIL_PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND FIL_PHONE.CONTACT_POINT_TYPE(+) = 'PHONE' AND FIL_PHONE.STATUS(+) = 'A' AND FIL_PHONE.PRIMARY_FLAG(+) = 'Y' AND BKR.COURT_ID = CRT.PARTY_ID(+) AND CRT_PHONE.OWNER_TABLE_ID(+) = CRT.PARTY_ID AND CRT_PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND CRT_PHONE.CONTACT_POINT_TYPE(+) = 'PHONE' AND CRT_PHONE.STATUS(+) = 'A' AND CRT_PHONE.PRIMARY_FLAG(+) = 'Y' AND BKR.COURT_ID = CRT.PARTY_ID(+) AND BKR.DISPOSITION_CODE = LK.LOOKUP_CODE(+) AND LK.LOOKUP_TYPE(+) = 'IEX_BKR_DISPOSITION' AND BKR.COURT_CLERK_CONTACT_ID = CNT_REL.PARTY_ID(+) AND CNT.PARTY_ID(+) = CNT_REL.SUBJECT_ID

View Text - HTML Formatted

SELECT BKR.BANKRUPTCY_ID BANKRUPTCY_ID
, BKR.DELINQUENCY_ID DELINQUENCY_ID
, BKR.FILE_CONTACT_ID FILE_CONTACT_ID
, BKR.CHAPTER_CODE CHAPTER_CODE
, BKR.BANKRUPTCY_FILE_DATE BANKRUPTCY_FILE_DATE
, FIL.PARTY_NAME FILING_NAME
, FIL.ADDRESS1 FILING_ADDRESS1
, FIL.ADDRESS2 FILING_ADDRESS2
, FIL.CITY FILING_CITY
, FIL.COUNTY FILING_COUNTY
, FIL.STATE FILING_STATE
, FIL.POSTAL_CODE FILING_POSTAL_CODE
, FIL_PHONE.PHONE_NUMBER FILING_PHONE_NUMBER
, BKR.COURT_ID COURT_ID
, CRT.PARTY_NAME COURT_NAME
, BKR.CASE_NUMBER CASE_NUMBER
, COURT_CLERK_CONTACT_ID COURT_CLERK_CONTACT_ID
, CNT.PARTY_NAME COURT_CLERK_CONTACT_NAME
, CRT.ADDRESS1 COURT_ADDRESS1
, CRT.ADDRESS2 COURT_ADDRESS2
, CRT.CITY COURT_CITY
, CRT.COUNTY COURT_COUNTY
, CRT.STATE COURT_STATE
, CRT.POSTAL_CODE COURT_POSTAL_CODE
, CRT_PHONE.PHONE_NUMBER COURT_PHONE_NUMBER
, BKR.FUNDING_DATE FUNDING_DATE
, BKR.COURT_ORDER_DATE COURT_ORDER_DATE
, BKR.OBJECT_BAR_DATE OBJECT_BAR_DATE
, BKR.REPOSSESSION_DATE REPOSSESSION_DATE
, BKR.DISMISSAL_DATE DISMISSAL_DATE
, BKR.DATE_341A DATE_341A
, BKR.DISCHARGE_DATE DISCHARGE_DATE
, BKR.WITHDRAW_DATE WITHDRAW_DATE
, BKR.CLOSE_DATE CLOSE_DATE
, SYSDATE TBD_DATE
, BKR.FILE_PROOF_CLAIM_YN FILE_PROOF_CLAIM_YN
, BKR.NOTICE_ASSIGNMENT_YN NOTICE_ASSIGNMENT_YN
, BKR.REQUEST_REPURCHASE_YN REQUEST_REPURCHASE_YN
, BKR.DISPOSITION_CODE DISPOSITION_CODE
, LK.MEANING DISPOSITION_MEANING
FROM IEX_BANKRUPTCIES BKR
, HZ_PARTIES FIL
, HZ_CONTACT_POINTS FIL_PHONE
, HZ_PARTIES CRT
, HZ_CONTACT_POINTS CRT_PHONE
, IEX_LOOKUPS_V LK
, HZ_RELATIONSHIPS CNT_REL
, HZ_PARTIES CNT
WHERE BKR.FILE_CONTACT_ID = FIL.PARTY_ID(+)
AND FIL_PHONE.OWNER_TABLE_ID(+) = FIL.PARTY_ID
AND FIL_PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND FIL_PHONE.CONTACT_POINT_TYPE(+) = 'PHONE'
AND FIL_PHONE.STATUS(+) = 'A'
AND FIL_PHONE.PRIMARY_FLAG(+) = 'Y'
AND BKR.COURT_ID = CRT.PARTY_ID(+)
AND CRT_PHONE.OWNER_TABLE_ID(+) = CRT.PARTY_ID
AND CRT_PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CRT_PHONE.CONTACT_POINT_TYPE(+) = 'PHONE'
AND CRT_PHONE.STATUS(+) = 'A'
AND CRT_PHONE.PRIMARY_FLAG(+) = 'Y'
AND BKR.COURT_ID = CRT.PARTY_ID(+)
AND BKR.DISPOSITION_CODE = LK.LOOKUP_CODE(+)
AND LK.LOOKUP_TYPE(+) = 'IEX_BKR_DISPOSITION'
AND BKR.COURT_CLERK_CONTACT_ID = CNT_REL.PARTY_ID(+)
AND CNT.PARTY_ID(+) = CNT_REL.SUBJECT_ID