Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Information Types requested during Inquiry |
Implementation/DBA Data: | Not implemented in this database |
SELECT ITYPE. ROWID ROW_ID
, ITYPE.PERSON_ID
, ITYPE.ENQUIRY_APPL_NUMBER
, EAP.ENQUIRY_DT
, LEAD.VEHICLE_RESPONSE_CODE INQUIRY_METHOD_CODE
, LEAD.VEH_RESP_CODE_MEANING INQUIRY_METHOD
, ITYPE.INFO_TYPE_ID
, IPK.DELIVERABLE_NAME PACKAGE_ITEM
, IPK.DESCRIPTION
, IPK.ACTUAL_AVAIL_FROM_DATE
, IPK.ACTUAL_AVAIL_TO_DATE
, ITYPE.CREATED_BY
, ITYPE.CREATION_DATE
, ITYPE.LAST_UPDATED_BY
, ITYPE.LAST_UPDATE_DATE
, ITYPE.LAST_UPDATE_LOGIN
FROM IGS_RC_I_A_ITYPE ITYPE
, AMS_P_DELIVERABLES_V IPK
, IGS_RC_I_APPL_ALL EAP
, AS_SALES_LEADS_V LEAD
WHERE ITYPE.INFO_TYPE_ID = IPK.DELIVERABLE_ID
AND ITYPE.PERSON_ID = EAP.PERSON_ID
AND ITYPE.ENQUIRY_APPL_NUMBER = EAP.ENQUIRY_APPL_NUMBER
AND EAP.SALES_LEAD_ID = LEAD.SALES_LEAD_ID