VIEW: APPS.IEX_REPOS_OBJECTS_UV

Source

View Text - Preformatted

SELECT iro.repos_object_id, irep.delinquency_id, iro.repossession_id, iro.asset_id, iro.rna_id, pv.vendor_name, iro.rna_site_id, ovs.name site_name, ovs.description site_description, iro.art_id, decode(oar.ars_code, 'SCHEDULED', 'Y', 'N') active_yn, oar.relocate_asset_yn, oalv.asset_number, oalv.name asset_name, oalv.item_description asset_description, oalv.dnz_chr_id, oalv.serial_number, oar.art1_code, oar.ars_code, flv.meaning return_status, oar.kle_id, oar.date_repossession_required, oar.date_repossession_actual, oar.date_hold_until, oar.date_returned, oar.creation_date, oar.last_update_date, oar.last_updated_by FROM iex_repossessions irep, iex_repos_objects iro, po_vendors pv, okx_vendor_sites_v ovs, okx_asset_lines_v oalv, okl_asset_returns_b oar, fnd_lookup_values flv WHERE irep.repossession_id = iro.repossession_id AND iro.rna_id = pv.vendor_id AND iro.rna_site_id = ovs.id1(+) AND iro.asset_id = oalv.asset_id(+) AND oar.ars_code = flv.lookup_code(+) AND flv.lookup_type(+) = 'OKL_ASSET_RETURN_STATUS' AND flv.LANGUAGE(+) = userenv('LANG') AND oar.kle_id(+) = oalv.parent_line_id

View Text - HTML Formatted

SELECT IRO.REPOS_OBJECT_ID
, IREP.DELINQUENCY_ID
, IRO.REPOSSESSION_ID
, IRO.ASSET_ID
, IRO.RNA_ID
, PV.VENDOR_NAME
, IRO.RNA_SITE_ID
, OVS.NAME SITE_NAME
, OVS.DESCRIPTION SITE_DESCRIPTION
, IRO.ART_ID
, DECODE(OAR.ARS_CODE
, 'SCHEDULED'
, 'Y'
, 'N') ACTIVE_YN
, OAR.RELOCATE_ASSET_YN
, OALV.ASSET_NUMBER
, OALV.NAME ASSET_NAME
, OALV.ITEM_DESCRIPTION ASSET_DESCRIPTION
, OALV.DNZ_CHR_ID
, OALV.SERIAL_NUMBER
, OAR.ART1_CODE
, OAR.ARS_CODE
, FLV.MEANING RETURN_STATUS
, OAR.KLE_ID
, OAR.DATE_REPOSSESSION_REQUIRED
, OAR.DATE_REPOSSESSION_ACTUAL
, OAR.DATE_HOLD_UNTIL
, OAR.DATE_RETURNED
, OAR.CREATION_DATE
, OAR.LAST_UPDATE_DATE
, OAR.LAST_UPDATED_BY
FROM IEX_REPOSSESSIONS IREP
, IEX_REPOS_OBJECTS IRO
, PO_VENDORS PV
, OKX_VENDOR_SITES_V OVS
, OKX_ASSET_LINES_V OALV
, OKL_ASSET_RETURNS_B OAR
, FND_LOOKUP_VALUES FLV
WHERE IREP.REPOSSESSION_ID = IRO.REPOSSESSION_ID
AND IRO.RNA_ID = PV.VENDOR_ID
AND IRO.RNA_SITE_ID = OVS.ID1(+)
AND IRO.ASSET_ID = OALV.ASSET_ID(+)
AND OAR.ARS_CODE = FLV.LOOKUP_CODE(+)
AND FLV.LOOKUP_TYPE(+) = 'OKL_ASSET_RETURN_STATUS'
AND FLV.LANGUAGE(+) = USERENV('LANG')
AND OAR.KLE_ID(+) = OALV.PARENT_LINE_ID