View Creation in eis eXpress Reports
Create Database view as shown below example
CREATE OR REPLACE VIEW XXEIS_PO_ITEM_MASTER_V AS
SELECT msi.segment1 item_num
, msi.description
, msi.primary_unit_of_measure
, msi.primary_uom_code
, msi.inventory_item_status_code
, msi.purchasing_item_flag
, msi.purchasing_enabled_flag
, msi.enabled_flag item_enabled_flag
, msi.attribute1 item_attribute1
, msi.attribute2 item_attribute2
, msi.attribute3 item_attribute3
, msi.attribute4 item_attribute4
, msi.attribute5 item_attribute5
, msi.attribute6 item_attribute6
, msi.attribute7 item_attribute7
, msi.attribute8 item_attribute8
, msi.attribute9 item_attribute9
, msi.attribute10 item_attribute10
, msi.attribute11 item_attribute11
, msi.attribute12 item_attribute12
, msi.attribute13 item_attribute13
, msi.attribute14 item_attribute14
, msi.attribute15 item_attribute15
, msit.long_description
, mc.segment3||'.'||mc.segment1||'.'||mc.segment2 oracle_category
, mc.enabled_flag category_enabled_flag
, mc.summary_flag category_summary_flag
, mc.start_date_active category_start_Date
, mc.end_date_active category_end_Date
, mc.attribute1 category_attribute1
, mc.attribute2 category_attribute2
, mc.attribute3 category_attribute3
, mc.attribute4 category_attribute4
, mc.attribute5 category_attribute5
, mc.attribute6 category_attribute6
, mc.attribute7 category_attribute7
, mc.attribute8 category_attribute8
, mc.attribute9 category_attribute9
, mc.attribute10 category_attribute10
, mc.attribute11 category_attribute11
, mc.attribute12 category_attribute12
, mc.attribute13 category_attribute13
, mc.attribute14 category_attribute14
, mc.attribute15 category_attribute15
FROM mtl_system_items_b msi
, mtl_system_items_tl msit
, mtl_item_categories mic
, mtl_categories_b mc
WHERE msi.organization_id = FND_PROFILE.VALUE('ORG_ID')
AND msi.organization_id = mic.organization_id
AND msi.inventory_item_id = mic.inventory_item_id
AND mic.category_id = mc.category_id
AND msi.organization_id = msit.organization_id
AND msi.inventory_item_id = msit.inventory_item_id
AND msit.language = userenv('LANG');
If you included more fields than this in the actual view; remember “Power User” can copy the report and add columns to it as long as they are present in the view.
It should also be noted that I have not aliased the attributes with the report column name this is because attributes can have different meanings/uses across organizations and the column name can be set in the report format section, covered later in this document.
Create the view in the relevant environment for import into EiS eXpress Reports
View Import in eis:
One you have created the view it must be imported into EiS before it can be used.
Responsibility: XXEIS eXpress Developer
Path: Setup => Data Sources => Import Object
Select the apps schema, all bespoke views should be created in the apps schema.
Select the object (view) that you want to import into EiS
Select the module (Oracle Application) you want to import the view into.
Note: If you are using the view for a Purchasing and General Ledger report you will need to import it into both Modules.
If the module is not in your list see Module Security in the “Developer Setup” section.
Note: The module should be the most likely Oracle Application that the user would expect to find the report in i.e. a Purchase Order report would most likely be access by Purchasing Users and Purchasing would be the logical EiS module to put it in.
Make sure you click the “Import Objects” button before navigating away from this screen.
One you have created the view it must be imported into EiS before it can be used.
ReplyDeleteAS Casino
EVO Club
The procedure for GEPCO’s new connection is very easy. It just requires the customer to be truthful and honest. To get the process started, one needs to have access to a good internet connection and a smartphone or a laptop. To get to the GEPCO application form:
ReplyDeleteGEPCO New Connection
Open the browser.
Write “GEPCO application form.”
Open the application form.
Fill it out and then send it to GEPCO via email. You can also pay the fee online.