Obtain All FOB Information.sql

-- The following SQL can be used to identify the FOB information that has been created.
SELECT
	mslt.lookup_code
  , mslt.meaning
  , mslt.description
  , mslb.start_date_active
  , mslb.end_date_Active
  , mslb.enabled_flag
FROM
	fusion.MSC_SR_LOOKUP_VALUES_B  mslb
  , fusion.MSC_SR_LOOKUP_VALUES_tl mslt
WHERE
	mslb.lookup_code     = mslt.lookup_code
	AND mslb.lookup_type = 'FOB'
	AND mslt.language    = userenv('LANG')
-- Cross reference data can be reviewed by running the following SQL:
SELECT
	mai.instance_code
  , mxm.ENTITY_NAME
  , mxm.ATTRIBUTE_NAME
  , mxm.SOURCE_VALUE
  , mxm.TARGET_VALUe
FROM
	fusion.MSC_XREF_MAPPING   MXM
  , Fusion.MSC_APPs_INSTANCEs Mai
WHERE
	mxm.SR_INSTANCE_ID = MAI.instance_id
	AND entity_name LIKE 'FOB'
ORDER BY
	mai.instance_code
  , mxm.ATTRIBUTE_NAME
  , mxm.SOURCE_VALUE
  , mxm.TARGET_VALUe