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.

[Home] [Help]

View: JAI_CMN_RG_BALANCES_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_CMN_RG_BALANCES_V

View Text

SELECT JA1.ROWID ROW_ID
, JA1.ORG_UNIT_ID
, JA1.ORGANIZATION_ID
, JA1.LOCATION_ID
, JA1.PLA_BALANCE
, JA1.RG23A_BALANCE
, JA1.RG23C_BALANCE
, JA1.CREATION_DATE
, JA1.CREATED_BY
, JA1.LAST_UPDATED_BY
, JA1.LAST_UPDATE_LOGIN
, JA1.LAST_UPDATE_DATE
, ORG.ORGANIZATION_NAME
, LOC.LOCATION_CODE
, CUR.CURRENCY_CODE
, JA1.BASIC_PLA_BALANCE
, JA1.ADDITIONAL_PLA_BALANCE
, JA1.OTHER_PLA_BALANCE
FROM ORG_ORGANIZATION_DEFINITIONS ORG
, JAI_CMN_RG_BALANCES JA1
, HR_LOCATIONS LOC
, FND_CURRENCIES CUR
, GL_SETS_OF_BOOKS GL
, JAI_CMN_INVENTORY_ORGS HOU
WHERE JA1.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND LOC.LOCATION_ID (+)= JA1.LOCATION_ID
AND CUR.CURRENCY_CODE = GL.CURRENCY_CODE
AND GL.SET_OF_BOOKS_ID = ORG.SET_OF_BOOKS_ID AND JA1.ORG_UNIT_ID = HOU.ORG_UNIT_ID
AND NVL(HOU.TRADING
, 'N') <> 'Y'

Columns

Name
ROW_ID
ORG_UNIT_ID
ORGANIZATION_ID
LOCATION_ID
PLA_BALANCE
RG23A_BALANCE
RG23C_BALANCE
CREATION_DATE
CREATED_BY
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE
ORGANIZATION_NAME
LOCATION_CODE
CURRENCY_CODE
BASIC_PLA_BALANCE
ADDITIONAL_PLA_BALANCE
OTHER_PLA_BALANCE