VIEW: APPS.FA_ASSET_DISTRIBUTION_V

Source

View Text - Preformatted

SELECT ad.asset_number, ad.tag_number, ad.description, ad.manufacturer_name, ad.serial_number, ad.model_number, ca.segment1 "MAJOR_CATEGORY", /* customize */ ca.segment2 "SUB_CATEGORY", /* customize */ bk.book_type_code, bk.date_placed_in_service "DATE_IN", round (bk.cost * dh.units_assigned / ad.current_units, 2) cost, emp.employee_number, emp.name employee_name, loc.segment1 "STATE", /* customize */ loc.segment2 "CITY", /* customize */ loc.segment3 "SITE", /* customize */ loc.segment4 "LOCATOR", /* customize */ expense_cc.segment1 "COMPANY", /* customize */ expense_cc.segment2 "REGION", /* customize */ expense_cc.segment3 "COST_CENTER", /* customize */ expense_cc.segment4 "EXPENSE_ACCOUNT", /* customize */ expense_cc.segment5 "PRODUCT", /* customize */ expense_cc.segment6 "SUB_ACCOUNT", /* customize */ cb.asset_cost_acct "ASSET_ACCOUNT" FROM FA_ADDITIONS AD,FA_BOOK_CONTROLS BC,FA_BOOKS BK,FA_CATEGORIES_B CA,FA_CATEGORY_BOOKS CB,FA_DISTRIBUTION_HISTORY DH,GL_CODE_COMBINATIONS EXPENSE_CC,FA_EMPLOYEES EMP,FA_LOCATIONS LOC WHERE bc.book_class = 'CORPORATE' and bk.book_type_code = bc.book_type_code and bk.asset_id = ad.asset_id and bk.period_counter_fully_retired is null and bk.date_ineffective is null and dh.book_type_code = bk.book_type_code and dh.asset_id = ad.asset_id and dh.date_ineffective is null and ca.category_id = ad.asset_category_id and cb.book_type_code = bk.book_type_code and cb.category_id = ad.asset_category_id and expense_cc.code_combination_id = dh.code_combination_id and emp.employee_id = dh.assigned_to and loc.location_id = dh.location_id

View Text - HTML Formatted

SELECT AD.ASSET_NUMBER
, AD.TAG_NUMBER
, AD.DESCRIPTION
, AD.MANUFACTURER_NAME
, AD.SERIAL_NUMBER
, AD.MODEL_NUMBER
, CA.SEGMENT1 "MAJOR_CATEGORY"
, /* CUSTOMIZE */ CA.SEGMENT2 "SUB_CATEGORY"
, /* CUSTOMIZE */ BK.BOOK_TYPE_CODE
, BK.DATE_PLACED_IN_SERVICE "DATE_IN"
, ROUND (BK.COST * DH.UNITS_ASSIGNED / AD.CURRENT_UNITS
, 2) COST
, EMP.EMPLOYEE_NUMBER
, EMP.NAME EMPLOYEE_NAME
, LOC.SEGMENT1 "STATE"
, /* CUSTOMIZE */ LOC.SEGMENT2 "CITY"
, /* CUSTOMIZE */ LOC.SEGMENT3 "SITE"
, /* CUSTOMIZE */ LOC.SEGMENT4 "LOCATOR"
, /* CUSTOMIZE */ EXPENSE_CC.SEGMENT1 "COMPANY"
, /* CUSTOMIZE */ EXPENSE_CC.SEGMENT2 "REGION"
, /* CUSTOMIZE */ EXPENSE_CC.SEGMENT3 "COST_CENTER"
, /* CUSTOMIZE */ EXPENSE_CC.SEGMENT4 "EXPENSE_ACCOUNT"
, /* CUSTOMIZE */ EXPENSE_CC.SEGMENT5 "PRODUCT"
, /* CUSTOMIZE */ EXPENSE_CC.SEGMENT6 "SUB_ACCOUNT"
, /* CUSTOMIZE */ CB.ASSET_COST_ACCT "ASSET_ACCOUNT"
FROM FA_ADDITIONS AD
, FA_BOOK_CONTROLS BC
, FA_BOOKS BK
, FA_CATEGORIES_B CA
, FA_CATEGORY_BOOKS CB
, FA_DISTRIBUTION_HISTORY DH
, GL_CODE_COMBINATIONS EXPENSE_CC
, FA_EMPLOYEES EMP
, FA_LOCATIONS LOC
WHERE BC.BOOK_CLASS = 'CORPORATE'
AND BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BK.ASSET_ID = AD.ASSET_ID
AND BK.PERIOD_COUNTER_FULLY_RETIRED IS NULL
AND BK.DATE_INEFFECTIVE IS NULL
AND DH.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE
AND DH.ASSET_ID = AD.ASSET_ID
AND DH.DATE_INEFFECTIVE IS NULL
AND CA.CATEGORY_ID = AD.ASSET_CATEGORY_ID
AND CB.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE
AND CB.CATEGORY_ID = AD.ASSET_CATEGORY_ID
AND EXPENSE_CC.CODE_COMBINATION_ID = DH.CODE_COMBINATION_ID
AND EMP.EMPLOYEE_ID = DH.ASSIGNED_TO
AND LOC.LOCATION_ID = DH.LOCATION_ID