eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.FII_LOB_ASSIGNMENTS_V

Source

View Text - Preformatted


SELECT lob.rowid row_id, lob.line_of_business line_of_business, lob.company_cost_center_org_id company_cost_center_org_id, hrcc.name company_cc_org_name, hrcc.company_code company_code, hrcc.company_vs company_vs, hrcc.cost_center_code cost_center_code, hrcc.cost_center_vs cost_center_vs, hrcc.conc_company_cc_segments description, lob.creation_date creation_date, lob.created_by created_by, lob.last_update_date last_update_date, lob.last_updated_by last_updated_by, lob.last_update_login last_update_login from fii_lob_assignments lob, hr_company_cost_centers hrcc WHERE lob.company_cost_center_org_id = hrcc.organization_id

View Text - HTML Formatted

SELECT LOB.ROWID ROW_ID
, LOB.LINE_OF_BUSINESS LINE_OF_BUSINESS
, LOB.COMPANY_COST_CENTER_ORG_ID COMPANY_COST_CENTER_ORG_ID
, HRCC.NAME COMPANY_CC_ORG_NAME
, HRCC.COMPANY_CODE COMPANY_CODE
, HRCC.COMPANY_VS COMPANY_VS
, HRCC.COST_CENTER_CODE COST_CENTER_CODE
, HRCC.COST_CENTER_VS COST_CENTER_VS
, HRCC.CONC_COMPANY_CC_SEGMENTS DESCRIPTION
, LOB.CREATION_DATE CREATION_DATE
, LOB.CREATED_BY CREATED_BY
, LOB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LOB.LAST_UPDATED_BY LAST_UPDATED_BY
, LOB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM FII_LOB_ASSIGNMENTS LOB
, HR_COMPANY_COST_CENTERS HRCC
WHERE LOB.COMPANY_COST_CENTER_ORG_ID = HRCC.ORGANIZATION_ID