Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Form view for enquiry application mailed package items - Obsolete |
Implementation/DBA Data: | Not implemented in this database |
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