VIEW: APPS.FA_ASSET_INVOICES_V

Source

View Text - Preformatted

SELECT ad.asset_number, ad.tag_number, ad.description, lu.meaning ASSET_TYPE, 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, bk.deprn_method_code, bk.life_in_months, bk.salvage_value, bk.adjusted_rate, bk.production_capacity, po_vn.vendor_name, po_vn.segment1 vendor_number, ai.po_number, ai.invoice_number, ai.invoice_id, ai.invoice_line_number, ai.description INVOICE_LINE_DESCRIPTION, ai.fixed_assets_cost INVOICE_COST, ai.ap_distribution_line_number DISTRIBUTION_LINE_NUMBER, ai.prior_source_line_id, ai.invoice_distribution_id, ai.po_distribution_id FROM FA_ADDITIONS AD, FA_BOOK_CONTROLS BC, FA_BOOKS BK, FA_CATEGORIES_B CA, FA_ASSET_INVOICES AI, PO_VENDORS PO_VN, FA_LOOKUPS LU 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 ca.category_id = ad.asset_category_id and lu.lookup_type = 'ASSET TYPE' and lu.lookup_code = ad.asset_type and ai.asset_id = ad.asset_id and ai.date_ineffective is null and ai.deleted_flag = 'NO' and po_vn.vendor_id = ai.po_vendor_id

View Text - HTML Formatted

SELECT AD.ASSET_NUMBER
, AD.TAG_NUMBER
, AD.DESCRIPTION
, LU.MEANING ASSET_TYPE
, 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
, BK.DEPRN_METHOD_CODE
, BK.LIFE_IN_MONTHS
, BK.SALVAGE_VALUE
, BK.ADJUSTED_RATE
, BK.PRODUCTION_CAPACITY
, PO_VN.VENDOR_NAME
, PO_VN.SEGMENT1 VENDOR_NUMBER
, AI.PO_NUMBER
, AI.INVOICE_NUMBER
, AI.INVOICE_ID
, AI.INVOICE_LINE_NUMBER
, AI.DESCRIPTION INVOICE_LINE_DESCRIPTION
, AI.FIXED_ASSETS_COST INVOICE_COST
, AI.AP_DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, AI.PRIOR_SOURCE_LINE_ID
, AI.INVOICE_DISTRIBUTION_ID
, AI.PO_DISTRIBUTION_ID
FROM FA_ADDITIONS AD
, FA_BOOK_CONTROLS BC
, FA_BOOKS BK
, FA_CATEGORIES_B CA
, FA_ASSET_INVOICES AI
, PO_VENDORS PO_VN
, FA_LOOKUPS LU
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 CA.CATEGORY_ID = AD.ASSET_CATEGORY_ID
AND LU.LOOKUP_TYPE = 'ASSET TYPE'
AND LU.LOOKUP_CODE = AD.ASSET_TYPE
AND AI.ASSET_ID = AD.ASSET_ID
AND AI.DATE_INEFFECTIVE IS NULL
AND AI.DELETED_FLAG = 'NO'
AND PO_VN.VENDOR_ID = AI.PO_VENDOR_ID