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.PA_CIP_COST_CLEARING_V

Source

View Text - Preformatted


SELECT PAL.PROJECT_ASSET_LINE_ID , PAL.DESCRIPTION , PAL.PROJECT_ASSET_ID , PAL.PROJECT_ID , PAL.TASK_ID , PAL.CIP_CCID , PAL.CURRENT_ASSET_COST , PAL.PROJECT_ASSET_LINE_DETAIL_ID , PAL.GL_DATE , PAL.FA_PERIOD_NAME , PAL.ASSET_CATEGORY_ID , PAL.ORG_ID FROM PA_PROJECT_ASSET_LINES_ALL PAL WHERE PAL.FA_PERIOD_NAME IS NOT NULL AND PAL.ORG_ID = mo_global.get_current_org_id

View Text - HTML Formatted

SELECT PAL.PROJECT_ASSET_LINE_ID
, PAL.DESCRIPTION
, PAL.PROJECT_ASSET_ID
, PAL.PROJECT_ID
, PAL.TASK_ID
, PAL.CIP_CCID
, PAL.CURRENT_ASSET_COST
, PAL.PROJECT_ASSET_LINE_DETAIL_ID
, PAL.GL_DATE
, PAL.FA_PERIOD_NAME
, PAL.ASSET_CATEGORY_ID
, PAL.ORG_ID
FROM PA_PROJECT_ASSET_LINES_ALL PAL
WHERE PAL.FA_PERIOD_NAME IS NOT NULL
AND PAL.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID