DBA Data[Home] [Help]

VIEW: APPS.XLA_APPLICATIONS_XVL

Source

View Text - Preformatted

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
View Text - HTML Formatted

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