FV_TREASURY_EXTRACT_HEADER_V

Details

  • Schema: FUSION

  • Object owner: FV

  • Object type: VIEW

Columns

Name

EVENT_ID

TREASURY_CONFIRMATION_ID

BUSINESS_UNIT_ID

PAYMENT_INSTRUCTION_ID

Query

SQL_Statement

SELECT FTC.CONFIRMED_EVENT_ID "EVENT_ID",

FTC.TREASURY_CONFIRMATION_ID "TREASURY_CONFIRMATION_ID",

FTC.BU_ID "BUSINESS_UNIT_ID",

FTC.PAYMENT_INSTRUCTION_ID "PAYMENT_INSTRUCTION_ID"

FROM FV_TREASURY_CONFIRM_ALL FTC INNER JOIN XLA_EVENTS_GT XE

ON XE.EVENT_ID=FTC.CONFIRMED_EVENT_ID