[Home] [Help]
View: AR_TA_LINE_OF_BUSINESS_V
| Product: | AR - Receivables |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT APPLICATION_COLUMN_NAME
, DECODE(APPLICATION_COLUMN_NAME
, 'SEGMENT1'
, SEGMENT1
, 'SEGMENT2'
, SEGMENT2
, 'SEGMENT3'
, SEGMENT3
, 'SEGMENT4'
, SEGMENT4
, 'SEGMENT5'
, SEGMENT5
, 'SEGMENT6'
, SEGMENT6
, 'SEGMENT7'
, SEGMENT7
, 'SEGMENT8'
, SEGMENT8
, 'SEGMENT9'
, SEGMENT9
, 'SEGMENT10'
, SEGMENT10
, 'SEGMENT11'
, SEGMENT11
, 'SEGMENT12'
, SEGMENT12
, 'SEGMENT13'
, SEGMENT13
, 'SEGMENT14'
, SEGMENT14
, 'SEGMENT15'
, SEGMENT15
, NULL) LINE_OF_BUSINESS
FROM AR_TA_PROF_ASSGNT_ALL
, FND_ID_FLEX_SEGMENTS ID
WHERE APPLICATION_ID=222
AND ID_FLEX_CODE ='AR#'
AND ID_FLEX_NUM= (SELECT ID_FLEX_NUM
FROM FND_ID_FLEX_STRUCTURES
WHERE APPLICATION_ID = 222
AND ID_FLEX_CODE = 'AR#'
AND ID_FLEX_STRUCTURE_CODE = 'ARTA-RECEIPT_PROF_IDENT')
AND ID.APPLICATION_COLUMN_NAME IN (SELECT APPLICATION_COLUMN_NAME
FROM FND_SEGMENT_ATTRIBUTE_VALUES
WHERE UPPER(SEGMENT_ATTRIBUTE_TYPE)='LINE OF BUSINESS'
AND ATTRIBUTE_VALUE= 'Y'
AND ID_FLEX_CODE='AR#'
AND APPLICATION_ID=222
AND ID_FLEX_NUM= (SELECT ID_FLEX_NUM
FROM FND_ID_FLEX_STRUCTURES
WHERE APPLICATION_ID = 222
AND ID_FLEX_CODE = 'AR#'
AND ID_FLEX_STRUCTURE_CODE = 'ARTA-RECEIPT_PROF_IDENT') )
AND ID.ENABLED_FLAG='Y' GROUP BY DECODE(APPLICATION_COLUMN_NAME
, 'SEGMENT1'
, SEGMENT1
, 'SEGMENT2'
, SEGMENT2
, 'SEGMENT3'
, SEGMENT3
, 'SEGMENT4'
, SEGMENT4
, 'SEGMENT5'
, SEGMENT5
, 'SEGMENT6'
, SEGMENT6
, 'SEGMENT7'
, SEGMENT7
, 'SEGMENT8'
, SEGMENT8
, 'SEGMENT9'
, SEGMENT9
, 'SEGMENT10'
, SEGMENT10
, 'SEGMENT11'
, SEGMENT11
, 'SEGMENT12'
, SEGMENT12
, 'SEGMENT13'
, SEGMENT13
, 'SEGMENT14'
, SEGMENT14
, 'SEGMENT15'
, SEGMENT15
, NULL)
, APPLICATION_COLUMN_NAME
Columns
| Name |
| APPLICATION_COLUMN_NAME |
| LINE_OF_BUSINESS |