Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AR_BPA_ITEMS_VL |
SELECT B.ROWID ROW_ID
, B.ITEM_ID
, B.ITEM_CODE
, B.ITEM_SOURCE
, B.ITEM_TYPE
, B.DISPLAY_LEVEL
, B.DATA_SOURCE_ID
, B.DISPLAY_ENABLED_FLAG
, B.ASSIGNMENT_ENABLED_FLAG
, B.AMOUNT_ITEM_FLAG
, B.URL_ID
, B.ITEM_IMAGE_FILENAME
, B.ITEM_MESSAGE_NAME
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.DISPLAYED_MULTI_LEVEL_FLAG
, B.SEEDED_APPLICATION_ID
, B.TAX_ITEM_FLAG
, B.TOTALS_ENABLED_FLAG
, B.LINK_ENABLED_FLAG
, B.DATA_TYPE
, B.URLCFG_ENABLED_FLAG
, B.FLEXFIELD_ITEM_FLAG
, B.COLUMN_NAME
, T.ITEM_NAME
, T.ITEM_TEXT_VALUE
, T.DISPLAY_PROMPT
, T.ITEM_DESCRIPTION
FROM AR_BPA_ITEMS_TL T
, AR_BPA_ITEMS_B B
WHERE B.ITEM_ID = T.ITEM_ID
AND T.LANGUAGE = USERENV('LANG')