VIEW: APPS.GHG_ASSETS_V

Source

View Text - Preformatted

SELECT xna.rowid row_id, xna.GHG_ASSET_ID, xna.asset_id, xna.GHG_ORGANIZATION_ID, xna.asset_type_lookup_code, xna.book_type_code, fa.asset_number, nvl(xna.description, fa.description), DECODE(fb.period_counter_fully_retired, NULL, 'N', 'Y'), fbc.segment1 ||'-' ||fbc.segment2, fa.tag_number, fa.serial_number, fl.GHG_ORGANIZATION_CODE, xna.transport_type_lookup_code, xna.vendor_id, pv.vendor_name, xna.vendor_site_id, pvs.vendor_site_code, pv.vat_registration_num, xna.start_date, xna.end_date, xna.created_by, xna.creation_date, xna.last_updated_by, xna.last_update_date, xna.last_update_login FROM GHG_ASSETS xna, fa_additions fa, fa_books fb, fa_categories_b fbc, fa_distribution_history fdh, GHG_ORGANIZATIONS_V fl, po_vendors pv, po_vendor_sites_all pvs WHERE xna.asset_type_lookup_code = 'INTERNAL' AND fa.asset_id = xna.asset_id AND fb.asset_id = xna.asset_id AND fb.book_type_code = xna.book_type_code AND fb.date_ineffective IS NULL AND fbc.category_id = fa.asset_category_id AND fdh.asset_id = xna.asset_id and fdh.date_ineffective is null AND fl.GHG_ORGANIZATION_ID(+) = xna.GHG_ORGANIZATION_ID AND pv.vendor_id(+) = xna.vendor_id AND pvs.vendor_site_id(+) = xna.vendor_site_id UNION SELECT xna.rowid row_id, xna.GHG_ASSET_ID, xna.asset_id, xna.GHG_ORGANIZATION_ID, xna.asset_type_lookup_code, NULL, xna.asset_number, xna.description, 'N', NULL, xna.tag_number, xna.serial_number, fl.GHG_ORGANIZATION_CODE, xna.transport_type_lookup_code, xna.vendor_id, pv.vendor_name, xna.vendor_site_id, pvs.vendor_site_code, pv.vat_registration_num, xna.start_date, xna.end_date, xna.created_by, xna.creation_date, xna.last_updated_by, xna.last_update_date, xna.last_update_login FROM GHG_ASSETS xna, po_vendors pv, po_vendor_sites_all pvs, GHG_ORGANIZATIONS_V fl WHERE xna.asset_type_lookup_code = 'EXTERNAL' and pv.vendor_id(+) = xna.vendor_id and pvs.vendor_site_id(+) = xna.vendor_site_id AND fl.GHG_ORGANIZATION_ID(+) = xna.GHG_ORGANIZATION_ID

View Text - HTML Formatted

SELECT XNA.ROWID ROW_ID
, XNA.GHG_ASSET_ID
, XNA.ASSET_ID
, XNA.GHG_ORGANIZATION_ID
, XNA.ASSET_TYPE_LOOKUP_CODE
, XNA.BOOK_TYPE_CODE
, FA.ASSET_NUMBER
, NVL(XNA.DESCRIPTION
, FA.DESCRIPTION)
, DECODE(FB.PERIOD_COUNTER_FULLY_RETIRED
, NULL
, 'N'
, 'Y')
, FBC.SEGMENT1 ||'-' ||FBC.SEGMENT2
, FA.TAG_NUMBER
, FA.SERIAL_NUMBER
, FL.GHG_ORGANIZATION_CODE
, XNA.TRANSPORT_TYPE_LOOKUP_CODE
, XNA.VENDOR_ID
, PV.VENDOR_NAME
, XNA.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, PV.VAT_REGISTRATION_NUM
, XNA.START_DATE
, XNA.END_DATE
, XNA.CREATED_BY
, XNA.CREATION_DATE
, XNA.LAST_UPDATED_BY
, XNA.LAST_UPDATE_DATE
, XNA.LAST_UPDATE_LOGIN
FROM GHG_ASSETS XNA
, FA_ADDITIONS FA
, FA_BOOKS FB
, FA_CATEGORIES_B FBC
, FA_DISTRIBUTION_HISTORY FDH
, GHG_ORGANIZATIONS_V FL
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
WHERE XNA.ASSET_TYPE_LOOKUP_CODE = 'INTERNAL'
AND FA.ASSET_ID = XNA.ASSET_ID
AND FB.ASSET_ID = XNA.ASSET_ID
AND FB.BOOK_TYPE_CODE = XNA.BOOK_TYPE_CODE
AND FB.DATE_INEFFECTIVE IS NULL
AND FBC.CATEGORY_ID = FA.ASSET_CATEGORY_ID
AND FDH.ASSET_ID = XNA.ASSET_ID
AND FDH.DATE_INEFFECTIVE IS NULL
AND FL.GHG_ORGANIZATION_ID(+) = XNA.GHG_ORGANIZATION_ID
AND PV.VENDOR_ID(+) = XNA.VENDOR_ID
AND PVS.VENDOR_SITE_ID(+) = XNA.VENDOR_SITE_ID UNION SELECT XNA.ROWID ROW_ID
, XNA.GHG_ASSET_ID
, XNA.ASSET_ID
, XNA.GHG_ORGANIZATION_ID
, XNA.ASSET_TYPE_LOOKUP_CODE
, NULL
, XNA.ASSET_NUMBER
, XNA.DESCRIPTION
, 'N'
, NULL
, XNA.TAG_NUMBER
, XNA.SERIAL_NUMBER
, FL.GHG_ORGANIZATION_CODE
, XNA.TRANSPORT_TYPE_LOOKUP_CODE
, XNA.VENDOR_ID
, PV.VENDOR_NAME
, XNA.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, PV.VAT_REGISTRATION_NUM
, XNA.START_DATE
, XNA.END_DATE
, XNA.CREATED_BY
, XNA.CREATION_DATE
, XNA.LAST_UPDATED_BY
, XNA.LAST_UPDATE_DATE
, XNA.LAST_UPDATE_LOGIN
FROM GHG_ASSETS XNA
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, GHG_ORGANIZATIONS_V FL
WHERE XNA.ASSET_TYPE_LOOKUP_CODE = 'EXTERNAL'
AND PV.VENDOR_ID(+) = XNA.VENDOR_ID
AND PVS.VENDOR_SITE_ID(+) = XNA.VENDOR_SITE_ID
AND FL.GHG_ORGANIZATION_ID(+) = XNA.GHG_ORGANIZATION_ID