DBA Data[Home] [Help]

VIEW: APPS.IGS_AD_I_UST_PKG_ITM_V

Source

View Text - Preformatted

SELECT IUP.RowID, IUP.Inq_U_Set_Pkg_Item_Id, IUP.Inq_Unit_Set_Code_Id, IUP.Enquiry_Package_Item, IP.Description, IUP.Closed_Ind, IUP.Created_By, IUP.Creation_Date, IUP.Last_Updated_By, IUP.Last_Update_Date, IUP.Last_Update_Login FROM IGS_AD_I_UST_PKG_ITM IUP, IGS_IN_ENQ_PKG_ITEM IP WHERE IUP.Enquiry_Package_Item = IP.Enquiry_Package_Item
View Text - HTML Formatted

SELECT IUP.ROWID
, IUP.INQ_U_SET_PKG_ITEM_ID
, IUP.INQ_UNIT_SET_CODE_ID
, IUP.ENQUIRY_PACKAGE_ITEM
, IP.DESCRIPTION
, IUP.CLOSED_IND
, IUP.CREATED_BY
, IUP.CREATION_DATE
, IUP.LAST_UPDATED_BY
, IUP.LAST_UPDATE_DATE
, IUP.LAST_UPDATE_LOGIN
FROM IGS_AD_I_UST_PKG_ITM IUP
, IGS_IN_ENQ_PKG_ITEM IP
WHERE IUP.ENQUIRY_PACKAGE_ITEM = IP.ENQUIRY_PACKAGE_ITEM