View: XLA_APPLICATIONS_XVL

Product:	XLA - Subledger Accounting
Description:	This view returns translated information related to application set with XLA.
Implementation/DBA Data:	APPS.XLA_APPLICATIONS_XVL

View Text

SELECT F.APPLICATION_ID
, X.APPLICATION_TYPE_CODE
, F.APPLICATION_SHORT_NAME
, F.APPLICATION_NAME
, F.DESCRIPTION
FROM FND_APPLICATION_VL F
, XLA_SUBLEDGERS X
WHERE F.APPLICATION_ID = X.APPLICATION_ID UNION SELECT F.APPLICATION_ID
, 'X'
, F.APPLICATION_SHORT_NAME
, F.APPLICATION_NAME
, F.DESCRIPTION
FROM FND_APPLICATION_VL F
WHERE F.APPLICATION_ID = 602

Columns