View: FA_MASS_ADDITIONS_V

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FA_MASS_ADDITIONS_V

View Text

SELECT MA.ROWID ROW_ID
, MA.ACCOUNTING_DATE
, MA.ADD_TO_ASSET_ID
, MA.AMORTIZE_FLAG
, MA.AP_DISTRIBUTION_LINE_NUMBER
, MA.ASSET_CATEGORY_ID
, MA.ASSET_KEY_CCID
, MA.ASSET_NUMBER
, MA.ASSET_TYPE
, MA.ASSIGNED_TO
, MA.ATTRIBUTE1
, MA.ATTRIBUTE10
, MA.ATTRIBUTE11
, MA.ATTRIBUTE12
, MA.ATTRIBUTE13
, MA.ATTRIBUTE14
, MA.ATTRIBUTE15
, MA.ATTRIBUTE16
, MA.ATTRIBUTE17
, MA.ATTRIBUTE18
, MA.ATTRIBUTE19
, MA.ATTRIBUTE2
, MA.ATTRIBUTE20
, MA.ATTRIBUTE21
, MA.ATTRIBUTE22
, MA.ATTRIBUTE23
, MA.ATTRIBUTE24
, MA.ATTRIBUTE25
, MA.ATTRIBUTE26
, MA.ATTRIBUTE27
, MA.ATTRIBUTE28
, MA.ATTRIBUTE29
, MA.ATTRIBUTE3
, MA.ATTRIBUTE30
, MA.ATTRIBUTE4
, MA.ATTRIBUTE5
, MA.ATTRIBUTE6
, MA.ATTRIBUTE7
, MA.ATTRIBUTE8
, MA.ATTRIBUTE9
, MA.ATTRIBUTE_CATEGORY_CODE
, MA.BEGINNING_NBV
, MA.BOOK_TYPE_CODE
, MA.CONTEXT
, MA.CREATED_BY
, TRUNC(MA.CREATE_BATCH_DATE) CREATE_BATCH_DATE
, MA.CREATE_BATCH_ID
, MA.CREATION_DATE
, MA.DATE_PLACED_IN_SERVICE
, MA.DEPRECIATE_FLAG
, MA.DEPRN_RESERVE
, MA.DESCRIPTION
, MA.EXPENSE_CODE_COMBINATION_ID
, MA.FEEDER_SYSTEM_NAME
, MA.FIXED_ASSETS_COST
, MA.FIXED_ASSETS_UNITS
, MA.FULLY_RSVD_REVALS_COUNTER
, MA.INVOICE_CREATED_BY
, MA.INVOICE_DATE
, MA.INVOICE_ID
, MA.INVOICE_NUMBER
, MA.INVOICE_UPDATED_BY
, MA.LAST_UPDATED_BY
, MA.LAST_UPDATE_DATE
, MA.LAST_UPDATE_LOGIN
, MA.LOCATION_ID
, MA.MANUFACTURER_NAME
, MA.MASS_ADDITION_ID
, MA.MERGED_CODE
, MA.MERGE_INVOICE_NUMBER
, MA.MERGE_PARENT_MASS_ADDITIONS_ID
, MA.MERGE_VENDOR_NUMBER
, MA.MODEL_NUMBER
, MA.NEW_MASTER_FLAG
, MA.PARENT_ASSET_ID
, MA.PARENT_MASS_ADDITION_ID
, MA.PAYABLES_BATCH_NAME
, MA.PAYABLES_CODE_COMBINATION_ID
, MA.PAYABLES_COST
, MA.PAYABLES_UNITS
, MA.POSTING_STATUS
, MA.POST_BATCH_ID
, MA.PO_NUMBER
, MA.PO_VENDOR_ID
, MA.PRODUCTION_CAPACITY
, MA.QUEUE_NAME
, MA.REVAL_AMORTIZATION_BASIS
, MA.REVAL_RESERVE
, MA.REVIEWER_COMMENTS
, MA.SALVAGE_VALUE
, MA.SERIAL_NUMBER
, MA.SPLIT_CODE
, MA.SPLIT_MERGED_CODE
, MA.SPLIT_PARENT_MASS_ADDITIONS_ID
, MA.SUM_UNITS
, MA.TAG_NUMBER
, MA.UNIT_OF_MEASURE
, MA.UNREVALUED_COST
, MA.YTD_DEPRN
, MA.YTD_REVAL_DEPRN_EXPENSE
, MA.PROJECT_ASSET_LINE_ID
, MA.PROJECT_ID
, MA.TASK_ID
, MA.GLOBAL_ATTRIBUTE1
, MA.GLOBAL_ATTRIBUTE10
, MA.GLOBAL_ATTRIBUTE11
, MA.GLOBAL_ATTRIBUTE12
, MA.GLOBAL_ATTRIBUTE13
, MA.GLOBAL_ATTRIBUTE14
, MA.GLOBAL_ATTRIBUTE15
, MA.GLOBAL_ATTRIBUTE16
, MA.GLOBAL_ATTRIBUTE17
, MA.GLOBAL_ATTRIBUTE18
, MA.GLOBAL_ATTRIBUTE19
, MA.GLOBAL_ATTRIBUTE2
, MA.GLOBAL_ATTRIBUTE20
, MA.GLOBAL_ATTRIBUTE3
, MA.GLOBAL_ATTRIBUTE4
, MA.GLOBAL_ATTRIBUTE5
, MA.GLOBAL_ATTRIBUTE6
, MA.GLOBAL_ATTRIBUTE7
, MA.GLOBAL_ATTRIBUTE8
, MA.GLOBAL_ATTRIBUTE9
, MA.GLOBAL_ATTRIBUTE_CATEGORY
, FALK1.LOOKUP_CODE QUEUE_NAME_LOOKUP_CODE
, FALK1.LOOKUP_TYPE QUEUE_NAME_LOOKUP_TYPE
, FALK1.MEANING QUEUE_NAME_DISP
, FALK2.LOOKUP_CODE ASSET_TYPE_LOOKUP_CODE
, FALK2.LOOKUP_TYPE ASSET_TYPE_LOOKUP_TYPE
, FALK2.MEANING ASSET_TYPE_MEANING
, FALK3.LOOKUP_CODE DEPRECIATE_FLAG_LOOKUP_CODE
, FALK3.LOOKUP_TYPE DEPRECIATE_FLAG_LOOKUP_TYPE
, FALK3.MEANING DEPRECIATE_FLAG_MEANING
, EMP.FULL_NAME EMPLOYEE_NAME
, EMP.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PO.VENDOR_NAME VENDOR_NAME
, PO.SEGMENT1 VENDOR_NUMBER
, AD.ASSET_NUMBER PARENT_ASSET_NUMBER
, AD.DESCRIPTION PARENT_ASSET_DESCRIPTION
, MA.INVENTORIAL
, MA.GROUP_ASSET_ID
, MA.TRANSACTION_TYPE_CODE
, FALK6.MEANING TRANSACTION_TYPE_DISP
, MA.TRANSACTION_DATE
, MA.WARRANTY_ID
, MA.LEASE_ID
, LEASE.LEASE_NUMBER
, LEASE.DESCRIPTION LEASE_DESC
, MA.LESSOR_ID
, PV.VENDOR_NAME LESSOR
, MA.PROPERTY_TYPE_CODE
, FALK4.MEANING PROPERTY_TYPE_MEANING
, MA.PROPERTY_1245_1250_CODE
, FALK5.MEANING PROPERTY_1245_1250_MEANING
, MA.IN_USE_FLAG
, MA.OWNED_LEASED
, MA.NEW_USED
, MA.ASSET_ID
, DECODE(MA.WARRANTY_NUMBER
, NULL
, WAR.WARRANTY_NUMBER
, MA.WARRANTY_NUMBER ) WARRANTY_NUMBER
, GAD.ASSET_NUMBER GROUP_ASSET_NUMBER
, MA.MATERIAL_INDICATOR_FLAG
, MA.INVOICE_DISTRIBUTION_ID
, MA.INVOICE_LINE_NUMBER
, MA.DEPRN_METHOD_CODE
, MA.LIFE_IN_MONTHS
, MA.BASIC_RATE
, MA.ADJUSTED_RATE
, MA.PRORATE_CONVENTION_CODE
, MA.BONUS_RULE
, MA.SALVAGE_TYPE
, MA.PERCENT_SALVAGE_VALUE
, MA.DEPRN_LIMIT_TYPE
, MA.ALLOWED_DEPRN_LIMIT_AMOUNT
, MA.ALLOWED_DEPRN_LIMIT
, MA.PO_DISTRIBUTION_ID
FROM FA_LOOKUPS FALK1
, FA_LOOKUPS FALK2
, FA_LOOKUPS FALK3
, FA_LOOKUPS FALK4
, FA_LOOKUPS FALK5
, FA_LOOKUPS FALK6
, PO_VENDORS PO
, PER_PEOPLE_F EMP
, FA_ADDITIONS_NON_SEC_VL AD
, FA_MASS_ADDITIONS MA
, FA_LEASES LEASE
, FA_WARRANTIES WAR
, PO_VENDORS PV
, FA_ADDITIONS_B GAD
WHERE FALK1.LOOKUP_TYPE ( + ) = 'QUEUE NAME'
AND FALK2.LOOKUP_TYPE ( + ) = 'ASSET TYPE'
AND FALK3.LOOKUP_TYPE ( + ) = 'YESNO'
AND DECODE (MA.POSTING_STATUS
, 'SPLIT'
, MA.POSTING_STATUS
, DECODE ( MA.POSTING_STATUS
, 'MERGED'
, MA.POSTING_STATUS
, MA.QUEUE_NAME ) ) = FALK1.LOOKUP_CODE ( + )
AND MA.ASSET_TYPE = FALK2.LOOKUP_CODE ( + )
AND MA.DEPRECIATE_FLAG = FALK3.LOOKUP_CODE ( + )
AND MA.ASSIGNED_TO = EMP.PERSON_ID ( + )
AND TRUNC ( SYSDATE ) BETWEEN NVL ( EMP.EFFECTIVE_START_DATE
, TRUNC ( SYSDATE ) )
AND NVL ( EMP.EFFECTIVE_END_DATE
, TRUNC ( SYSDATE ) )
AND MA.PO_VENDOR_ID = PO.VENDOR_ID ( + )
AND MA.PARENT_ASSET_ID = AD.ASSET_ID ( + )
AND MA.LEASE_ID = LEASE.LEASE_ID ( + )
AND MA.PROPERTY_TYPE_CODE = FALK4.LOOKUP_CODE (+)
AND FALK4.LOOKUP_TYPE(+) = 'PROPERTY TYPE'
AND MA.PROPERTY_1245_1250_CODE = FALK5.LOOKUP_CODE (+)
AND FALK5.LOOKUP_TYPE(+) = '1245/1250 PROPERTY'
AND MA.TRANSACTION_TYPE_CODE = FALK6.LOOKUP_CODE (+)
AND FALK6.LOOKUP_TYPE(+) = 'FAXOLTRX'
AND EXISTS (SELECT 'X'
FROM FA_BOOK_CONTROLS_SEC BC
WHERE BC.BOOK_TYPE_CODE = MA.BOOK_TYPE_CODE
AND NVL ( BC.DATE_INEFFECTIVE
, SYSDATE+1 ) > SYSDATE )
AND MA.WARRANTY_ID = WAR.WARRANTY_ID (+)
AND PV.VENDOR_ID (+) = LEASE.LESSOR_ID
AND GAD.ASSET_ID (+) = MA.GROUP_ASSET_ID

Columns