VIEW: APPS.FA_INV_INTERFACE_V

Source

View Text - Preformatted

SELECT ITF.INVENTORY_NAME , ITF.ASSET_ID , ITF.ASSET_NUMBER , ITF.TAG_NUMBER , ITF.DESCRIPTION , ITF.MODEL_NUMBER , ITF.SERIAL_NUMBER , ITF.MANUFACTURER_NAME , ITF.UNITS , LU.MEANING STATUS , LU2.MEANING UNIT_RECONCILE_MTH , LU3.MEANING LOC_RECONCILE_MTH , ITF.DISTRIBUTION_ID , ITF.INVENTORY_ID , ITF.RECONCILIATION_ID , LOC.SEGMENT1 LOC_SEGMENT1 , LOC.SEGMENT2 LOC_SEGMENT2 , LOC.SEGMENT3 LOC_SEGMENT3 , LOC.SEGMENT4 LOC_SEGMENT4 , LOC.SEGMENT5 LOC_SEGMENT5 , LOC.SEGMENT6 LOC_SEGMENT6 , LOC.SEGMENT7 LOC_SEGMENT7 , CAT.SEGMENT1 CAT_SEGMENT1 , CAT.SEGMENT2 CAT_SEGMENT2 , CAT.SEGMENT3 CAT_SEGMENT3 , CAT.SEGMENT4 CAT_SEGMENT4 , CAT.SEGMENT5 CAT_SEGMENT5 , CAT.SEGMENT6 CAT_SEGMENT6 , CAT.SEGMENT7 CAT_SEGMENT7 , KEY.SEGMENT1 KEY_SEGMENT1 , KEY.SEGMENT2 KEY_SEGMENT2 , KEY.SEGMENT3 KEY_SEGMENT3 , KEY.SEGMENT4 KEY_SEGMENT4 , KEY.SEGMENT5 KEY_SEGMENT5 , KEY.SEGMENT6 KEY_SEGMENT6 , KEY.SEGMENT7 KEY_SEGMENT7 , KEY.SEGMENT8 KEY_SEGMENT8 , KEY.SEGMENT9 KEY_SEGMENT9 FROM FA_INV_INTERFACE ITF, FA_DISTRIBUTION_HISTORY DH, FA_LOOKUPS LU, FA_LOOKUPS LU2, FA_LOOKUPS LU3, FA_CATEGORIES CAT, FA_LOCATIONS LOC, FA_ASSET_KEYWORDS KEY WHERE ITF.ASSET_ID = DH.ASSET_ID(+) AND ITF.DISTRIBUTION_ID = DH.DISTRIBUTION_ID(+) AND ITF.STATUS = LU.LOOKUP_CODE(+) AND LU.LOOKUP_TYPE(+) = 'INVENTORY STATUS' AND ITF.UNIT_RECONCILE_MTH = LU2.LOOKUP_CODE(+) AND LU2.LOOKUP_TYPE(+) LIKE 'INVENTORY UNIT METHOD%' AND LU3.LOOKUP_TYPE(+) LIKE 'INVENTORY LOCATION METHOD' AND ITF.LOC_RECONCILE_MTH = LU3.LOOKUP_CODE(+) AND ITF.ASSET_CATEGORY_ID = CAT.CATEGORY_ID(+) AND ITF.LOCATION_ID = LOC.LOCATION_ID(+) AND ITF.ASSET_KEY_CCID = KEY.CODE_COMBINATION_ID(+)

View Text - HTML Formatted

SELECT ITF.INVENTORY_NAME
, ITF.ASSET_ID
, ITF.ASSET_NUMBER
, ITF.TAG_NUMBER
, ITF.DESCRIPTION
, ITF.MODEL_NUMBER
, ITF.SERIAL_NUMBER
, ITF.MANUFACTURER_NAME
, ITF.UNITS
, LU.MEANING STATUS
, LU2.MEANING UNIT_RECONCILE_MTH
, LU3.MEANING LOC_RECONCILE_MTH
, ITF.DISTRIBUTION_ID
, ITF.INVENTORY_ID
, ITF.RECONCILIATION_ID
, LOC.SEGMENT1 LOC_SEGMENT1
, LOC.SEGMENT2 LOC_SEGMENT2
, LOC.SEGMENT3 LOC_SEGMENT3
, LOC.SEGMENT4 LOC_SEGMENT4
, LOC.SEGMENT5 LOC_SEGMENT5
, LOC.SEGMENT6 LOC_SEGMENT6
, LOC.SEGMENT7 LOC_SEGMENT7
, CAT.SEGMENT1 CAT_SEGMENT1
, CAT.SEGMENT2 CAT_SEGMENT2
, CAT.SEGMENT3 CAT_SEGMENT3
, CAT.SEGMENT4 CAT_SEGMENT4
, CAT.SEGMENT5 CAT_SEGMENT5
, CAT.SEGMENT6 CAT_SEGMENT6
, CAT.SEGMENT7 CAT_SEGMENT7
, KEY.SEGMENT1 KEY_SEGMENT1
, KEY.SEGMENT2 KEY_SEGMENT2
, KEY.SEGMENT3 KEY_SEGMENT3
, KEY.SEGMENT4 KEY_SEGMENT4
, KEY.SEGMENT5 KEY_SEGMENT5
, KEY.SEGMENT6 KEY_SEGMENT6
, KEY.SEGMENT7 KEY_SEGMENT7
, KEY.SEGMENT8 KEY_SEGMENT8
, KEY.SEGMENT9 KEY_SEGMENT9
FROM FA_INV_INTERFACE ITF
, FA_DISTRIBUTION_HISTORY DH
, FA_LOOKUPS LU
, FA_LOOKUPS LU2
, FA_LOOKUPS LU3
, FA_CATEGORIES CAT
, FA_LOCATIONS LOC
, FA_ASSET_KEYWORDS KEY
WHERE ITF.ASSET_ID = DH.ASSET_ID(+)
AND ITF.DISTRIBUTION_ID = DH.DISTRIBUTION_ID(+)
AND ITF.STATUS = LU.LOOKUP_CODE(+)
AND LU.LOOKUP_TYPE(+) = 'INVENTORY STATUS'
AND ITF.UNIT_RECONCILE_MTH = LU2.LOOKUP_CODE(+)
AND LU2.LOOKUP_TYPE(+) LIKE 'INVENTORY UNIT METHOD%'
AND LU3.LOOKUP_TYPE(+) LIKE 'INVENTORY LOCATION METHOD'
AND ITF.LOC_RECONCILE_MTH = LU3.LOOKUP_CODE(+)
AND ITF.ASSET_CATEGORY_ID = CAT.CATEGORY_ID(+)
AND ITF.LOCATION_ID = LOC.LOCATION_ID(+)
AND ITF.ASSET_KEY_CCID = KEY.CODE_COMBINATION_ID(+)