DBA Data[Home] [Help]

VIEW: APPS.IGS_AD_INQ_PROG_PKG_ITEMS_V

Source

View Text - Preformatted

SELECT IPP.RowID, IPP.Inq_Prog_Pkg_Item_Id, IPP.Inq_Prog_Code_Id, IPP.Enquiry_Package_Item, IP.Description, IPP.Closed_Ind, IPP.Created_By, IPP.Creation_Date, IPP.Last_Updated_By, IPP.Last_Update_Date, IPP.Last_Update_Login FROM IGS_AD_I_PRG_PKG_ITM IPP, IGS_IN_ENQ_PKG_ITEM IP WHERE IPP.Enquiry_Package_Item = IP.Enquiry_Package_Item
View Text - HTML Formatted

SELECT IPP.ROWID
, IPP.INQ_PROG_PKG_ITEM_ID
, IPP.INQ_PROG_CODE_ID
, IPP.ENQUIRY_PACKAGE_ITEM
, IP.DESCRIPTION
, IPP.CLOSED_IND
, IPP.CREATED_BY
, IPP.CREATION_DATE
, IPP.LAST_UPDATED_BY
, IPP.LAST_UPDATE_DATE
, IPP.LAST_UPDATE_LOGIN
FROM IGS_AD_I_PRG_PKG_ITM IPP
, IGS_IN_ENQ_PKG_ITEM IP
WHERE IPP.ENQUIRY_PACKAGE_ITEM = IP.ENQUIRY_PACKAGE_ITEM