VIEW: FA.FA_MASSADD_REP_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, QUEUE_NAME QUEUE_NAME, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, PERIOD_NAME PERIOD_NAME, ENTITY_NAME ENTITY_NAME, TRANSACTION_TYPE TRANSACTION_TYPE, REPORT_DATE REPORT_DATE, MASS_ADDITION_ID MASS_ADDITION_ID, STATUS STATUS, POSTING_STATUS POSTING_STATUS, POST_BATCH_ID POST_BATCH_ID, ASSET_NUMBER ASSET_NUMBER, TAG_NUMBER TAG_NUMBER, SERIAL_NUMBER SERIAL_NUMBER, ASSET_KEY ASSET_KEY, DESCRIPTION DESCRIPTION, ASSET_CATEGORY_ID ASSET_CATEGORY_ID, CATEGORY CATEGORY, AP_COMPANY AP_COMPANY, COMPANY_NAME COMPANY_NAME, ASSET_CLEARING_ACCT ASSET_CLEARING_ACCT, ASSET_COST_ACCOUNT ASSET_COST_ACCOUNT, ASSET_COST_ACCOUNT_CCID ASSET_COST_ACCOUNT_CCID, ASSET_CLEARING_ACCT_CCID ASSET_CLEARING_ACCT_CCID, DEPRN_EXPENSE_ACCT DEPRN_EXPENSE_ACCT, DEPRN_RESERVE_ACCT DEPRN_RESERVE_ACCT, COST_CENTER COST_CENTER, EXPENSE_ACCT EXPENSE_ACCT, LOCATION_ID LOCATION_ID, LOCATION LOCATION, VENDOR_NUMBER VENDOR_NUMBER, VENDOR_NAME VENDOR_NAME, INVOICE_NUMBER INVOICE_NUMBER, INVOICE_DATE INVOICE_DATE, SOURCE_SYSTEMS SOURCE_SYSTEMS, AP_BATCH_NAME AP_BATCH_NAME, AP_DISTRIBUTION_LINE_NUMBER AP_DISTRIBUTION_LINE_NUMBER, PO_NUMBER PO_NUMBER, PAYABLES_BATCH_NAME PAYABLES_BATCH_NAME, PAYABLES_CODE_COMBINATION_ID PAYABLES_CODE_COMBINATION_ID, PAYABLES_COST PAYABLES_COST, PAYABLES_UNITS PAYABLES_UNITS, FIXED_ASSETS_COST FIXED_ASSETS_COST, FOREIGN_CURRENCY_CODE FOREIGN_CURRENCY_CODE, FOREIGN_CURRENCY_AMOUNT FOREIGN_CURRENCY_AMOUNT, REVIEWER_COMMENTS REVIEWER_COMMENTS, DEPRN_METHOD DEPRN_METHOD, LIFE_IN_MONTHS LIFE_IN_MONTHS, BASIC_RATE BASIC_RATE, ADJUSTED_RATE ADJUSTED_RATE, PRODUCTION_CAPACITY PRODUCTION_CAPACITY, UNIT_OF_MEASURE UNIT_OF_MEASURE, PRORATE_CONVENTION PRORATE_CONVENTION, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, INVENTORIAL INVENTORIAL, ASSET_TYPE ASSET_TYPE, GROUP_ASSET_NUMBER GROUP_ASSET_NUMBER, MASS_PROPERTY_FLAG MASS_PROPERTY_FLAG, WARRANTY_NUMBER WARRANTY_NUMBER, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID from "FA"."FA_MASSADD_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, QUEUE_NAME QUEUE_NAME
, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, PERIOD_NAME PERIOD_NAME
, ENTITY_NAME ENTITY_NAME
, TRANSACTION_TYPE TRANSACTION_TYPE
, REPORT_DATE REPORT_DATE
, MASS_ADDITION_ID MASS_ADDITION_ID
, STATUS STATUS
, POSTING_STATUS POSTING_STATUS
, POST_BATCH_ID POST_BATCH_ID
, ASSET_NUMBER ASSET_NUMBER
, TAG_NUMBER TAG_NUMBER
, SERIAL_NUMBER SERIAL_NUMBER
, ASSET_KEY ASSET_KEY
, DESCRIPTION DESCRIPTION
, ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, CATEGORY CATEGORY
, AP_COMPANY AP_COMPANY
, COMPANY_NAME COMPANY_NAME
, ASSET_CLEARING_ACCT ASSET_CLEARING_ACCT
, ASSET_COST_ACCOUNT ASSET_COST_ACCOUNT
, ASSET_COST_ACCOUNT_CCID ASSET_COST_ACCOUNT_CCID
, ASSET_CLEARING_ACCT_CCID ASSET_CLEARING_ACCT_CCID
, DEPRN_EXPENSE_ACCT DEPRN_EXPENSE_ACCT
, DEPRN_RESERVE_ACCT DEPRN_RESERVE_ACCT
, COST_CENTER COST_CENTER
, EXPENSE_ACCT EXPENSE_ACCT
, LOCATION_ID LOCATION_ID
, LOCATION LOCATION
, VENDOR_NUMBER VENDOR_NUMBER
, VENDOR_NAME VENDOR_NAME
, INVOICE_NUMBER INVOICE_NUMBER
, INVOICE_DATE INVOICE_DATE
, SOURCE_SYSTEMS SOURCE_SYSTEMS
, AP_BATCH_NAME AP_BATCH_NAME
, AP_DISTRIBUTION_LINE_NUMBER AP_DISTRIBUTION_LINE_NUMBER
, PO_NUMBER PO_NUMBER
, PAYABLES_BATCH_NAME PAYABLES_BATCH_NAME
, PAYABLES_CODE_COMBINATION_ID PAYABLES_CODE_COMBINATION_ID
, PAYABLES_COST PAYABLES_COST
, PAYABLES_UNITS PAYABLES_UNITS
, FIXED_ASSETS_COST FIXED_ASSETS_COST
, FOREIGN_CURRENCY_CODE FOREIGN_CURRENCY_CODE
, FOREIGN_CURRENCY_AMOUNT FOREIGN_CURRENCY_AMOUNT
, REVIEWER_COMMENTS REVIEWER_COMMENTS
, DEPRN_METHOD DEPRN_METHOD
, LIFE_IN_MONTHS LIFE_IN_MONTHS
, BASIC_RATE BASIC_RATE
, ADJUSTED_RATE ADJUSTED_RATE
, PRODUCTION_CAPACITY PRODUCTION_CAPACITY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, PRORATE_CONVENTION PRORATE_CONVENTION
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, INVENTORIAL INVENTORIAL
, ASSET_TYPE ASSET_TYPE
, GROUP_ASSET_NUMBER GROUP_ASSET_NUMBER
, MASS_PROPERTY_FLAG MASS_PROPERTY_FLAG
, WARRANTY_NUMBER WARRANTY_NUMBER
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
FROM "FA"."FA_MASSADD_REP_ITF"