DBA Data[Home] [Help]

VIEW: APPS.IGS_AD_ENT_PKG_ITEMS_V

Source

View Text - Preformatted

SELECT EPI.RowId, EPI.Ent_Pkg_Item_Id, EPI.Inq_Entry_Stat_Id, EPI.Enquiry_Package_Item, IEP.Description, EPI.Closed_Ind, EPI.Created_By, EPI.Creation_Date, EPI.Last_Updated_By, EPI.Last_Update_Date, EPI.Last_Update_Login FROM IGS_IN_ENQ_PKG_ITEM IEP, IGS_AD_ENT_PKG_ITEMS EPI WHERE IEP.Enquiry_Package_Item = EPI.Enquiry_Package_Item
View Text - HTML Formatted

SELECT EPI.ROWID
, EPI.ENT_PKG_ITEM_ID
, EPI.INQ_ENTRY_STAT_ID
, EPI.ENQUIRY_PACKAGE_ITEM
, IEP.DESCRIPTION
, EPI.CLOSED_IND
, EPI.CREATED_BY
, EPI.CREATION_DATE
, EPI.LAST_UPDATED_BY
, EPI.LAST_UPDATE_DATE
, EPI.LAST_UPDATE_LOGIN
FROM IGS_IN_ENQ_PKG_ITEM IEP
, IGS_AD_ENT_PKG_ITEMS EPI
WHERE IEP.ENQUIRY_PACKAGE_ITEM = EPI.ENQUIRY_PACKAGE_ITEM