VIEW: APPS.IGS_IN_APPLML_PKGITM_V

Source

View Text - Preformatted

SELECT PKM.ROWID, PKM.PERSON_ID, PKM.ENQUIRY_APPL_NUMBER, EAP.ENQUIRY_DT, EAP.ENQUIRY_SOURCE_TYPE, PKM.ENQUIRY_PACKAGE_ITEM, IPK.DESCRIPTION, PKM.DONOT_MAIL_IND, PKM.MAILED_DT, IPK.AVAILABLE_DT, IPK.AVAILABLE_IND, PKM.REQUEST_ID, PKM.PROGRAM_APPLICATION_ID, PKM.PROGRAM_ID, PKM.PROGRAM_UPDATE_DATE, PKM.CREATED_BY, PKM.CREATION_DATE, PKM.LAST_UPDATED_BY, PKM.LAST_UPDATE_DATE, PKM.LAST_UPDATE_LOGIN FROM IGS_IN_APPLML_PKGITM PKM, IGS_IN_ENQ_PKG_ITEM IPK, IGS_IN_ENQUIRY_APPL EAP WHERE PKM.ENQUIRY_PACKAGE_ITEM = IPK.ENQUIRY_PACKAGE_ITEM AND PKM.PERSON_ID = EAP.PERSON_ID AND PKM.ENQUIRY_APPL_NUMBER = EAP.ENQUIRY_APPL_NUMBER

View Text - HTML Formatted

SELECT PKM.ROWID
, PKM.PERSON_ID
, PKM.ENQUIRY_APPL_NUMBER
, EAP.ENQUIRY_DT
, EAP.ENQUIRY_SOURCE_TYPE
, PKM.ENQUIRY_PACKAGE_ITEM
, IPK.DESCRIPTION
, PKM.DONOT_MAIL_IND
, PKM.MAILED_DT
, IPK.AVAILABLE_DT
, IPK.AVAILABLE_IND
, PKM.REQUEST_ID
, PKM.PROGRAM_APPLICATION_ID
, PKM.PROGRAM_ID
, PKM.PROGRAM_UPDATE_DATE
, PKM.CREATED_BY
, PKM.CREATION_DATE
, PKM.LAST_UPDATED_BY
, PKM.LAST_UPDATE_DATE
, PKM.LAST_UPDATE_LOGIN
FROM IGS_IN_APPLML_PKGITM PKM
, IGS_IN_ENQ_PKG_ITEM IPK
, IGS_IN_ENQUIRY_APPL EAP
WHERE PKM.ENQUIRY_PACKAGE_ITEM = IPK.ENQUIRY_PACKAGE_ITEM
AND PKM.PERSON_ID = EAP.PERSON_ID
AND PKM.ENQUIRY_APPL_NUMBER = EAP.ENQUIRY_APPL_NUMBER