1. Tables and Views for SCM
  2. CST_XLA_INV_SOURCES_REF_V

CST_XLA_INV_SOURCES_REF_V

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

INV_PROJECT_ID

INV_TASK_ID

INV_COUNTRY_OF_ORIGIN_CODE

CST_INV_TRANSACTION_ID

INV_PROJECT_NUMBER

INV_TASK_NUMBER

Query

SQL_Statement

SELECT

cit.project_id inv_project_id,

cit.task_id inv_task_id,

cit.country_of_origin_code inv_country_of_origin_code,

cit.cst_inv_transaction_id cst_inv_transaction_id,

ppa.segment1 inv_project_number,

pt.task_number inv_task_number

FROM

cst_inv_transactions cit,

pjf_tasks_v pt,

pjf_projects_all_vl ppa

WHERE

cit.project_id IS NOT NULL

AND cit.project_id = ppa.project_id

AND cit.task_id = pt.task_id