1. Tables and Views for Financials
  2. FV_SAM_CLASSIFICATION_CODES_V

FV_SAM_CLASSIFICATION_CODES_V

Details

  • Schema: FUSION

  • Object owner: FV

  • Object type: VIEW

Columns

Name

UNIQUE_ENTITY_IDENTIFIER_SAM

ENTITY_EFT_INDICATOR

SAM_TRADING_PARTNER_ID

CODE_TYPE

CODE

DESCRIPTION

Query

SQL_Statement

SELECT

FTRP.UNIQUE_ENTITY_IDENTIFIER_SAM "UNIQUE_ENTITY_IDENTIFIER_SAM",

FTRP.ENTITY_EFT_INDICATOR "ENTITY_EFT_INDICATOR",

FTRP.SAM_TRADING_PARTNER_ID "SAM_TRADING_PARTNER_ID",

FRTPC."CODE_TYPE" "CODE_TYPE",

FRTPC."CODE" "CODE",

FRTPC."DESC1" "DESCRIPTION"

FROM

FV_SAM_TRADING_PARTNER FTRP,

JSON_TABLE(FTRP.BUSINESS_TYPES_INFORMATION,

'$.items[*]' COLUMNS (CODE_TYPE VARCHAR2(30) PATH '$.CODE_TYPE' NULL ON ERROR,

CODE VARCHAR2(30) PATH '$.CODE' NULL ON ERROR,

DESC1 VARCHAR2(150) PATH '$.DESC1' NULL ON ERROR)) FRTPC