VRM_SOURCE_DOCUMENTS

Details

Schema: FUSION
Object owner: VRM
Object type: VIEW

Columns

Name
SRC_DOCUMENT_ID SRC_APPLICATION_ID SRC_DOCUMENT_TYPE_ID SRC_DOC_ID_INT_1 SRC_DOC_ID_INT_2 SRC_DOC_ID_INT_3 SRC_DOC_ID_INT_4 SRC_DOC_ID_INT_5 SRC_DOC_ID_CHAR_1 SRC_DOC_ID_CHAR_2 SRC_DOC_ID_CHAR_3 SRC_DOC_ID_CHAR_4 SRC_DOC_ID_CHAR_5 SRC_DOC_DATE SRC_ATTRIBUTE_CATEGORY SRC_ATTRIBUTE_CHAR1 SRC_ATTRIBUTE_CHAR2 SRC_ATTRIBUTE_CHAR3 SRC_ATTRIBUTE_CHAR4 SRC_ATTRIBUTE_CHAR5 SRC_ATTRIBUTE_CHAR6 SRC_ATTRIBUTE_CHAR7 SRC_ATTRIBUTE_CHAR8 SRC_ATTRIBUTE_CHAR9 SRC_ATTRIBUTE_CHAR10 SRC_ATTRIBUTE_CHAR11 SRC_ATTRIBUTE_CHAR12 SRC_ATTRIBUTE_CHAR13 SRC_ATTRIBUTE_CHAR14 SRC_ATTRIBUTE_CHAR15 SRC_ATTRIBUTE_CHAR16 SRC_ATTRIBUTE_CHAR17 SRC_ATTRIBUTE_CHAR18 SRC_ATTRIBUTE_CHAR19 SRC_ATTRIBUTE_CHAR20 SRC_ATTRIBUTE_CHAR21 SRC_ATTRIBUTE_CHAR22 SRC_ATTRIBUTE_CHAR23 SRC_ATTRIBUTE_CHAR24 SRC_ATTRIBUTE_CHAR25 SRC_ATTRIBUTE_CHAR26 SRC_ATTRIBUTE_CHAR27 SRC_ATTRIBUTE_CHAR28 SRC_ATTRIBUTE_CHAR29 SRC_ATTRIBUTE_CHAR30 SRC_ATTRIBUTE_CHAR31 SRC_ATTRIBUTE_CHAR32 SRC_ATTRIBUTE_CHAR33 SRC_ATTRIBUTE_CHAR34 SRC_ATTRIBUTE_CHAR35 SRC_ATTRIBUTE_CHAR36 SRC_ATTRIBUTE_CHAR37 SRC_ATTRIBUTE_CHAR38 SRC_ATTRIBUTE_CHAR39 SRC_ATTRIBUTE_CHAR40 SRC_ATTRIBUTE_CHAR41 SRC_ATTRIBUTE_CHAR42 SRC_ATTRIBUTE_CHAR43 SRC_ATTRIBUTE_CHAR44 SRC_ATTRIBUTE_CHAR45 SRC_ATTRIBUTE_CHAR46 SRC_ATTRIBUTE_CHAR47 SRC_ATTRIBUTE_CHAR48 SRC_ATTRIBUTE_CHAR49 SRC_ATTRIBUTE_CHAR50 SRC_ATTRIBUTE_CHAR51 SRC_ATTRIBUTE_CHAR52 SRC_ATTRIBUTE_CHAR53 SRC_ATTRIBUTE_CHAR54 SRC_ATTRIBUTE_CHAR55 SRC_ATTRIBUTE_CHAR56 SRC_ATTRIBUTE_CHAR57 SRC_ATTRIBUTE_CHAR58 SRC_ATTRIBUTE_CHAR59 SRC_ATTRIBUTE_CHAR60 SRC_DOC_NUMBER SRC_DOC_TYPE SRC_CURRENCY_CODE SRC_SALESREP_ID SRC_SALESREP_NAME SRC_BILL_TO_CUST_PARTY_ID SRC_BILL_TO_CUST_PARTY_NUM SRC_BILL_TO_CUST_PARTY_NAME SRC_BILL_TO_CUST_ID SRC_SHIP_TO_CUST_ID SRC_BILL_TO_CUST_NUM SRC_SHIP_TO_CUST_NUM SRC_BILL_TO_CUST_NAME SRC_SHIP_TO_CUST_NAME SRC_BILL_TO_CUST_SITE_ID SRC_BILL_TO_CUST_SITE_NAME SRC_SHIP_TO_CUST_SITE_ID SRC_SHIP_TO_CUST_SITE_NAME SRC_BILL_TO_COUNTRY SRC_SHIP_TO_COUNTRY SRC_ORG_ID SRC_ORGANIZATION_NAME SRC_LEDGER_ID SRC_LEDGER_NAME SRC_LEGAL_ENTITY_ID SRC_LEGAL_ENTITY_NAME SRC_CUST_PO_NUMBER SRC_CUST_CONTRACT_NUMBER SRC_SALES_AGREEMENT_NUMBER SRC_QUOTE_NUMBER SRC_EXCHANGE_RATE SRC_EXCHANGE_RATE_TYPE SRC_EXCHANGE_DATE SRC_BILL_TO_CUST_STATE SRC_BILL_TO_CUST_COUNTY SRC_BILL_TO_CUST_CITY SRC_BILL_TO_CUST_POSTAL_CODE SRC_BILL_TO_CUST_CLASS SRC_REQUEST_ID SRC_CREATED_BY SRC_LEGAL_ENTITY_COUNTRY SRC_LEGAL_ENTITY_ADDRESS SRC_PAYMENT_TERM_ID SRC_INVOICING_RULE_ID SRC_ACCOUNTING_RULE_ID SRC_ACCOUNTING_RULE_DURATION SRC_CANCELLED_FLAG SRC_OPEN_FLAG SRC_RETURN_REASON_CODE SRC_DOCUMENT_TYPE_CODE LINE_NUMBER EVENT_ID

Name

SRC_DOCUMENT_ID

SRC_APPLICATION_ID

SRC_DOCUMENT_TYPE_ID

SRC_DOC_ID_INT_1

SRC_DOC_ID_INT_2

SRC_DOC_ID_INT_3

SRC_DOC_ID_INT_4

SRC_DOC_ID_INT_5

SRC_DOC_ID_CHAR_1

SRC_DOC_ID_CHAR_2

SRC_DOC_ID_CHAR_3

SRC_DOC_ID_CHAR_4

SRC_DOC_ID_CHAR_5

SRC_DOC_DATE

SRC_ATTRIBUTE_CATEGORY

SRC_ATTRIBUTE_CHAR1

SRC_ATTRIBUTE_CHAR2

SRC_ATTRIBUTE_CHAR3

SRC_ATTRIBUTE_CHAR4

SRC_ATTRIBUTE_CHAR5

SRC_ATTRIBUTE_CHAR6

SRC_ATTRIBUTE_CHAR7

SRC_ATTRIBUTE_CHAR8

SRC_ATTRIBUTE_CHAR9

SRC_ATTRIBUTE_CHAR10

SRC_ATTRIBUTE_CHAR11

SRC_ATTRIBUTE_CHAR12

SRC_ATTRIBUTE_CHAR13

SRC_ATTRIBUTE_CHAR14

SRC_ATTRIBUTE_CHAR15

SRC_ATTRIBUTE_CHAR16

SRC_ATTRIBUTE_CHAR17

SRC_ATTRIBUTE_CHAR18

SRC_ATTRIBUTE_CHAR19

SRC_ATTRIBUTE_CHAR20

SRC_ATTRIBUTE_CHAR21

SRC_ATTRIBUTE_CHAR22

SRC_ATTRIBUTE_CHAR23

SRC_ATTRIBUTE_CHAR24

SRC_ATTRIBUTE_CHAR25

SRC_ATTRIBUTE_CHAR26

SRC_ATTRIBUTE_CHAR27

SRC_ATTRIBUTE_CHAR28

SRC_ATTRIBUTE_CHAR29

SRC_ATTRIBUTE_CHAR30

SRC_ATTRIBUTE_CHAR31

SRC_ATTRIBUTE_CHAR32

SRC_ATTRIBUTE_CHAR33

SRC_ATTRIBUTE_CHAR34

SRC_ATTRIBUTE_CHAR35

SRC_ATTRIBUTE_CHAR36

SRC_ATTRIBUTE_CHAR37

SRC_ATTRIBUTE_CHAR38

SRC_ATTRIBUTE_CHAR39

SRC_ATTRIBUTE_CHAR40

SRC_ATTRIBUTE_CHAR41

SRC_ATTRIBUTE_CHAR42

SRC_ATTRIBUTE_CHAR43

SRC_ATTRIBUTE_CHAR44

SRC_ATTRIBUTE_CHAR45

SRC_ATTRIBUTE_CHAR46

SRC_ATTRIBUTE_CHAR47

SRC_ATTRIBUTE_CHAR48

SRC_ATTRIBUTE_CHAR49

SRC_ATTRIBUTE_CHAR50

SRC_ATTRIBUTE_CHAR51

SRC_ATTRIBUTE_CHAR52

SRC_ATTRIBUTE_CHAR53

SRC_ATTRIBUTE_CHAR54

SRC_ATTRIBUTE_CHAR55

SRC_ATTRIBUTE_CHAR56

SRC_ATTRIBUTE_CHAR57

SRC_ATTRIBUTE_CHAR58

SRC_ATTRIBUTE_CHAR59

SRC_ATTRIBUTE_CHAR60

SRC_DOC_NUMBER

SRC_DOC_TYPE

SRC_CURRENCY_CODE

SRC_SALESREP_ID

SRC_SALESREP_NAME

SRC_BILL_TO_CUST_PARTY_ID

SRC_BILL_TO_CUST_PARTY_NUM

SRC_BILL_TO_CUST_PARTY_NAME

SRC_BILL_TO_CUST_ID

SRC_SHIP_TO_CUST_ID

SRC_BILL_TO_CUST_NUM

SRC_SHIP_TO_CUST_NUM

SRC_BILL_TO_CUST_NAME

SRC_SHIP_TO_CUST_NAME

SRC_BILL_TO_CUST_SITE_ID

SRC_BILL_TO_CUST_SITE_NAME

SRC_SHIP_TO_CUST_SITE_ID

SRC_SHIP_TO_CUST_SITE_NAME

SRC_BILL_TO_COUNTRY

SRC_SHIP_TO_COUNTRY

SRC_ORG_ID

SRC_ORGANIZATION_NAME

SRC_LEDGER_ID

SRC_LEDGER_NAME

SRC_LEGAL_ENTITY_ID

SRC_LEGAL_ENTITY_NAME

SRC_CUST_PO_NUMBER

SRC_CUST_CONTRACT_NUMBER

SRC_SALES_AGREEMENT_NUMBER

SRC_QUOTE_NUMBER

SRC_EXCHANGE_RATE

SRC_EXCHANGE_RATE_TYPE

SRC_EXCHANGE_DATE

SRC_BILL_TO_CUST_STATE

SRC_BILL_TO_CUST_COUNTY

SRC_BILL_TO_CUST_CITY

SRC_BILL_TO_CUST_POSTAL_CODE

SRC_BILL_TO_CUST_CLASS

SRC_REQUEST_ID

SRC_CREATED_BY

SRC_LEGAL_ENTITY_COUNTRY

SRC_LEGAL_ENTITY_ADDRESS

SRC_PAYMENT_TERM_ID

SRC_INVOICING_RULE_ID

SRC_ACCOUNTING_RULE_ID

SRC_ACCOUNTING_RULE_DURATION

SRC_CANCELLED_FLAG

SRC_OPEN_FLAG

SRC_RETURN_REASON_CODE

SRC_DOCUMENT_TYPE_CODE

LINE_NUMBER

EVENT_ID

Query

SQL_Statement
SELECT vsd.DOCUMENT_ID SRC_DOCUMENT_ID , vsd.APPLICATION_ID SRC_APPLICATION_ID, vsd.DOCUMENT_TYPE_ID SRC_DOCUMENT_TYPE_ID, vsd.DOC_ID_INT_1 SRC_DOC_ID_INT_1, vsd.DOC_ID_INT_2 SRC_DOC_ID_INT_2, vsd.DOC_ID_INT_3 SRC_DOC_ID_INT_3, vsd.DOC_ID_INT_4 SRC_DOC_ID_INT_4, vsd.DOC_ID_INT_5 SRC_DOC_ID_INT_5, vsd.DOC_ID_CHAR_1 SRC_DOC_ID_CHAR_1, vsd.DOC_ID_CHAR_2 SRC_DOC_ID_CHAR_2, vsd.DOC_ID_CHAR_3 SRC_DOC_ID_CHAR_3, vsd.DOC_ID_CHAR_4 SRC_DOC_ID_CHAR_4, vsd.DOC_ID_CHAR_5 SRC_DOC_ID_CHAR_5, vsd.DOCUMENT_DATE SRC_DOC_DATE, vsd.SRC_ATTRIBUTE_CATEGORY SRC_ATTRIBUTE_CATEGORY, vsd.SRC_ATTRIBUTE_CHAR1 SRC_ATTRIBUTE_CHAR1, vsd.SRC_ATTRIBUTE_CHAR2 SRC_ATTRIBUTE_CHAR2, vsd.SRC_ATTRIBUTE_CHAR3 SRC_ATTRIBUTE_CHAR3, vsd.SRC_ATTRIBUTE_CHAR4 SRC_ATTRIBUTE_CHAR4, vsd.SRC_ATTRIBUTE_CHAR5 SRC_ATTRIBUTE_CHAR5, vsd.SRC_ATTRIBUTE_CHAR6 SRC_ATTRIBUTE_CHAR6, vsd.SRC_ATTRIBUTE_CHAR7 SRC_ATTRIBUTE_CHAR7, vsd.SRC_ATTRIBUTE_CHAR8 SRC_ATTRIBUTE_CHAR8, vsd.SRC_ATTRIBUTE_CHAR9 SRC_ATTRIBUTE_CHAR9, vsd.SRC_ATTRIBUTE_CHAR10 SRC_ATTRIBUTE_CHAR10, vsd.SRC_ATTRIBUTE_CHAR11 SRC_ATTRIBUTE_CHAR11, vsd.SRC_ATTRIBUTE_CHAR12 SRC_ATTRIBUTE_CHAR12, vsd.SRC_ATTRIBUTE_CHAR13 SRC_ATTRIBUTE_CHAR13, vsd.SRC_ATTRIBUTE_CHAR14 SRC_ATTRIBUTE_CHAR14, vsd.SRC_ATTRIBUTE_CHAR15 SRC_ATTRIBUTE_CHAR15, vsd.SRC_ATTRIBUTE_CHAR16 SRC_ATTRIBUTE_CHAR16, vsd.SRC_ATTRIBUTE_CHAR17 SRC_ATTRIBUTE_CHAR17, vsd.SRC_ATTRIBUTE_CHAR18 SRC_ATTRIBUTE_CHAR18, vsd.SRC_ATTRIBUTE_CHAR19 SRC_ATTRIBUTE_CHAR19, vsd.SRC_ATTRIBUTE_CHAR20 SRC_ATTRIBUTE_CHAR20, vsd.SRC_ATTRIBUTE_CHAR21 SRC_ATTRIBUTE_CHAR21, vsd.SRC_ATTRIBUTE_CHAR22 SRC_ATTRIBUTE_CHAR22, vsd.SRC_ATTRIBUTE_CHAR23 SRC_ATTRIBUTE_CHAR23, vsd.SRC_ATTRIBUTE_CHAR24 SRC_ATTRIBUTE_CHAR24, vsd.SRC_ATTRIBUTE_CHAR25 SRC_ATTRIBUTE_CHAR25, vsd.SRC_ATTRIBUTE_CHAR26 SRC_ATTRIBUTE_CHAR26, vsd.SRC_ATTRIBUTE_CHAR27 SRC_ATTRIBUTE_CHAR27, vsd.SRC_ATTRIBUTE_CHAR28 SRC_ATTRIBUTE_CHAR28, vsd.SRC_ATTRIBUTE_CHAR29 SRC_ATTRIBUTE_CHAR29, vsd.SRC_ATTRIBUTE_CHAR30 SRC_ATTRIBUTE_CHAR30, vsd.SRC_ATTRIBUTE_CHAR31 SRC_ATTRIBUTE_CHAR31, vsd.SRC_ATTRIBUTE_CHAR32 SRC_ATTRIBUTE_CHAR32, vsd.SRC_ATTRIBUTE_CHAR33 SRC_ATTRIBUTE_CHAR33, vsd.SRC_ATTRIBUTE_CHAR34 SRC_ATTRIBUTE_CHAR34, vsd.SRC_ATTRIBUTE_CHAR35 SRC_ATTRIBUTE_CHAR35, vsd.SRC_ATTRIBUTE_CHAR36 SRC_ATTRIBUTE_CHAR36, vsd.SRC_ATTRIBUTE_CHAR37 SRC_ATTRIBUTE_CHAR37, vsd.SRC_ATTRIBUTE_CHAR38 SRC_ATTRIBUTE_CHAR38, vsd.SRC_ATTRIBUTE_CHAR39 SRC_ATTRIBUTE_CHAR39, vsd.SRC_ATTRIBUTE_CHAR40 SRC_ATTRIBUTE_CHAR40, vsd.SRC_ATTRIBUTE_CHAR41 SRC_ATTRIBUTE_CHAR41, vsd.SRC_ATTRIBUTE_CHAR42 SRC_ATTRIBUTE_CHAR42, vsd.SRC_ATTRIBUTE_CHAR43 SRC_ATTRIBUTE_CHAR43, vsd.SRC_ATTRIBUTE_CHAR44 SRC_ATTRIBUTE_CHAR44, vsd.SRC_ATTRIBUTE_CHAR45 SRC_ATTRIBUTE_CHAR45, vsd.SRC_ATTRIBUTE_CHAR46 SRC_ATTRIBUTE_CHAR46, vsd.SRC_ATTRIBUTE_CHAR47 SRC_ATTRIBUTE_CHAR47, vsd.SRC_ATTRIBUTE_CHAR48 SRC_ATTRIBUTE_CHAR48, vsd.SRC_ATTRIBUTE_CHAR49 SRC_ATTRIBUTE_CHAR49, vsd.SRC_ATTRIBUTE_CHAR50 SRC_ATTRIBUTE_CHAR50, vsd.SRC_ATTRIBUTE_CHAR51 SRC_ATTRIBUTE_CHAR51, vsd.SRC_ATTRIBUTE_CHAR52 SRC_ATTRIBUTE_CHAR52, vsd.SRC_ATTRIBUTE_CHAR53 SRC_ATTRIBUTE_CHAR53, vsd.SRC_ATTRIBUTE_CHAR54 SRC_ATTRIBUTE_CHAR54, vsd.SRC_ATTRIBUTE_CHAR55 SRC_ATTRIBUTE_CHAR55, vsd.SRC_ATTRIBUTE_CHAR56 SRC_ATTRIBUTE_CHAR56, vsd.SRC_ATTRIBUTE_CHAR57 SRC_ATTRIBUTE_CHAR57, vsd.SRC_ATTRIBUTE_CHAR58 SRC_ATTRIBUTE_CHAR58, vsd.SRC_ATTRIBUTE_CHAR59 SRC_ATTRIBUTE_CHAR59, vsd.SRC_ATTRIBUTE_CHAR60 SRC_ATTRIBUTE_CHAR60, vsd.DOCUMENT_NUMBER SRC_DOC_NUMBER, vsd.DOCUMENT_TYPE SRC_DOC_TYPE, vsd.CURRENCY_CODE SRC_CURRENCY_CODE, vsd.SALESREP_ID SRC_SALESREP_ID, vsd.SALESREP_NAME SRC_SALESREP_NAME, vsd.BILL_TO_CUSTOMER_PARTY_ID SRC_BILL_TO_CUST_PARTY_ID, vsd.BILL_TO_CUSTOMER_PARTY_NUM SRC_BILL_TO_CUST_PARTY_NUM, vsd.BILL_TO_CUSTOMER_PARTY_NAME SRC_BILL_TO_CUST_PARTY_NAME, vsd.BILL_TO_CUSTOMER_ID SRC_BILL_TO_CUST_ID, vsd.SHIP_TO_CUSTOMER_ID SRC_SHIP_TO_CUST_ID, vsd.BILL_TO_CUSTOMER_NUM SRC_BILL_TO_CUST_NUM, vsd.SHIP_TO_CUSTOMER_NUM SRC_SHIP_TO_CUST_NUM, vsd.BILL_TO_CUSTOMER_NAME SRC_BILL_TO_CUST_NAME, vsd.SHIP_TO_CUSTOMER_NAME SRC_SHIP_TO_CUST_NAME, vsd.BILL_TO_CUSTOMER_SITE_ID SRC_BILL_TO_CUST_SITE_ID, vsd.BILL_TO_CUST_SITE_NAME SRC_BILL_TO_CUST_SITE_NAME, vsd.SHIP_TO_CUSTOMER_SITE_ID SRC_SHIP_TO_CUST_SITE_ID, vsd.SHIP_TO_CUST_SITE_NAME SRC_SHIP_TO_CUST_SITE_NAME, vsd.BILL_TO_COUNTRY SRC_BILL_TO_COUNTRY, vsd.SHIP_TO_COUNTRY SRC_SHIP_TO_COUNTRY, vsd.ORG_ID SRC_ORG_ID, vsd.ORGANIZATION_NAME SRC_ORGANIZATION_NAME, vsd.LEDGER_ID SRC_LEDGER_ID, vsd.LEDGER_NAME SRC_LEDGER_NAME, vsd.LEGAL_ENTITY_ID SRC_LEGAL_ENTITY_ID, vsd.LEGAL_ENTITY_NAME SRC_LEGAL_ENTITY_NAME, vsd.CUST_PO_NUMBER SRC_CUST_PO_NUMBER, vsd.CUSTOMER_CONTRACT_NUMBER SRC_CUST_CONTRACT_NUMBER, vsd.SALES_AGREEMENT_NUMBER SRC_SALES_AGREEMENT_NUMBER, vsd.QUOTE_NUMBER SRC_QUOTE_NUMBER, vsd.EXCHANGE_RATE SRC_EXCHANGE_RATE, vsd.EXCHANGE_RATE_TYPE SRC_EXCHANGE_RATE_TYPE, vsd.EXCHANGE_DATE SRC_EXCHANGE_DATE, vsd.BILL_TO_CUSTOMER_STATE SRC_BILL_TO_CUST_STATE, vsd.BILL_TO_CUSTOMER_COUNTY SRC_BILL_TO_CUST_COUNTY, vsd.BILL_TO_CUSTOMER_CITY SRC_BILL_TO_CUST_CITY, vsd.BILL_TO_CUSTOMER_POSTAL_CODE SRC_BILL_TO_CUST_POSTAL_CODE, vsd.BILL_TO_CUST_CLASSIFICATION SRC_BILL_TO_CUST_CLASS, vsd.REQUEST_ID SRC_REQUEST_ID, vsd.CREATED_BY SRC_CREATED_BY, vsd.LEGAL_ENTITY_COUNTRY SRC_LEGAL_ENTITY_COUNTRY, vsd.LEGAL_ENTITY_ADDRESS SRC_LEGAL_ENTITY_ADDRESS, vsd.PAYMENT_TERM_ID SRC_PAYMENT_TERM_ID, vsd.INVOICING_RULE_ID SRC_INVOICING_RULE_ID, vsd.ACCOUNTING_RULE_ID SRC_ACCOUNTING_RULE_ID, vsd.ACCOUNTING_RULE_DURATION SRC_ACCOUNTING_RULE_DURATION, vsd.CANCELLED_FLAG SRC_CANCELLED_FLAG, vsd.OPEN_FLAG SRC_OPEN_FLAG, vsd.RETURN_REASON_CODE SRC_RETURN_REASON_CODE, vdt.DOCUMENT_TYPE_CODE SRC_DOCUMENT_TYPE_CODE, l.LINE_NUMBER, l.EVENT_ID FROM VRM_SOURCE_DOCUMENTS vsd, VRM_SOURCE_DOC_TYPES_B vdt, vrm_xla_lines_extract_gt l WHERE l.SOURCE_DOCUMENT_ID = vsd.DOCUMENT_ID AND vsd.DOCUMENT_TYPE_ID = vdt.DOCUMENT_TYPE_ID AND l.level_flag = 'H'

SQL_Statement

SELECT

vsd.DOCUMENT_ID SRC_DOCUMENT_ID ,

vsd.APPLICATION_ID SRC_APPLICATION_ID,

vsd.DOCUMENT_TYPE_ID SRC_DOCUMENT_TYPE_ID,

vsd.DOC_ID_INT_1 SRC_DOC_ID_INT_1,

vsd.DOC_ID_INT_2 SRC_DOC_ID_INT_2,

vsd.DOC_ID_INT_3 SRC_DOC_ID_INT_3,

vsd.DOC_ID_INT_4 SRC_DOC_ID_INT_4,

vsd.DOC_ID_INT_5 SRC_DOC_ID_INT_5,

vsd.DOC_ID_CHAR_1 SRC_DOC_ID_CHAR_1,

vsd.DOC_ID_CHAR_2 SRC_DOC_ID_CHAR_2,

vsd.DOC_ID_CHAR_3 SRC_DOC_ID_CHAR_3,

vsd.DOC_ID_CHAR_4 SRC_DOC_ID_CHAR_4,

vsd.DOC_ID_CHAR_5 SRC_DOC_ID_CHAR_5,

vsd.DOCUMENT_DATE SRC_DOC_DATE,

vsd.SRC_ATTRIBUTE_CATEGORY SRC_ATTRIBUTE_CATEGORY,

vsd.SRC_ATTRIBUTE_CHAR1 SRC_ATTRIBUTE_CHAR1,

vsd.SRC_ATTRIBUTE_CHAR2 SRC_ATTRIBUTE_CHAR2,

vsd.SRC_ATTRIBUTE_CHAR3 SRC_ATTRIBUTE_CHAR3,

vsd.SRC_ATTRIBUTE_CHAR4 SRC_ATTRIBUTE_CHAR4,

vsd.SRC_ATTRIBUTE_CHAR5 SRC_ATTRIBUTE_CHAR5,

vsd.SRC_ATTRIBUTE_CHAR6 SRC_ATTRIBUTE_CHAR6,

vsd.SRC_ATTRIBUTE_CHAR7 SRC_ATTRIBUTE_CHAR7,

vsd.SRC_ATTRIBUTE_CHAR8 SRC_ATTRIBUTE_CHAR8,

vsd.SRC_ATTRIBUTE_CHAR9 SRC_ATTRIBUTE_CHAR9,

vsd.SRC_ATTRIBUTE_CHAR10 SRC_ATTRIBUTE_CHAR10,

vsd.SRC_ATTRIBUTE_CHAR11 SRC_ATTRIBUTE_CHAR11,

vsd.SRC_ATTRIBUTE_CHAR12 SRC_ATTRIBUTE_CHAR12,

vsd.SRC_ATTRIBUTE_CHAR13 SRC_ATTRIBUTE_CHAR13,

vsd.SRC_ATTRIBUTE_CHAR14 SRC_ATTRIBUTE_CHAR14,

vsd.SRC_ATTRIBUTE_CHAR15 SRC_ATTRIBUTE_CHAR15,

vsd.SRC_ATTRIBUTE_CHAR16 SRC_ATTRIBUTE_CHAR16,

vsd.SRC_ATTRIBUTE_CHAR17 SRC_ATTRIBUTE_CHAR17,

vsd.SRC_ATTRIBUTE_CHAR18 SRC_ATTRIBUTE_CHAR18,

vsd.SRC_ATTRIBUTE_CHAR19 SRC_ATTRIBUTE_CHAR19,

vsd.SRC_ATTRIBUTE_CHAR20 SRC_ATTRIBUTE_CHAR20,

vsd.SRC_ATTRIBUTE_CHAR21 SRC_ATTRIBUTE_CHAR21,

vsd.SRC_ATTRIBUTE_CHAR22 SRC_ATTRIBUTE_CHAR22,

vsd.SRC_ATTRIBUTE_CHAR23 SRC_ATTRIBUTE_CHAR23,

vsd.SRC_ATTRIBUTE_CHAR24 SRC_ATTRIBUTE_CHAR24,

vsd.SRC_ATTRIBUTE_CHAR25 SRC_ATTRIBUTE_CHAR25,

vsd.SRC_ATTRIBUTE_CHAR26 SRC_ATTRIBUTE_CHAR26,

vsd.SRC_ATTRIBUTE_CHAR27 SRC_ATTRIBUTE_CHAR27,

vsd.SRC_ATTRIBUTE_CHAR28 SRC_ATTRIBUTE_CHAR28,

vsd.SRC_ATTRIBUTE_CHAR29 SRC_ATTRIBUTE_CHAR29,

vsd.SRC_ATTRIBUTE_CHAR30 SRC_ATTRIBUTE_CHAR30,

vsd.SRC_ATTRIBUTE_CHAR31 SRC_ATTRIBUTE_CHAR31,

vsd.SRC_ATTRIBUTE_CHAR32 SRC_ATTRIBUTE_CHAR32,

vsd.SRC_ATTRIBUTE_CHAR33 SRC_ATTRIBUTE_CHAR33,

vsd.SRC_ATTRIBUTE_CHAR34 SRC_ATTRIBUTE_CHAR34,

vsd.SRC_ATTRIBUTE_CHAR35 SRC_ATTRIBUTE_CHAR35,

vsd.SRC_ATTRIBUTE_CHAR36 SRC_ATTRIBUTE_CHAR36,

vsd.SRC_ATTRIBUTE_CHAR37 SRC_ATTRIBUTE_CHAR37,

vsd.SRC_ATTRIBUTE_CHAR38 SRC_ATTRIBUTE_CHAR38,

vsd.SRC_ATTRIBUTE_CHAR39 SRC_ATTRIBUTE_CHAR39,

vsd.SRC_ATTRIBUTE_CHAR40 SRC_ATTRIBUTE_CHAR40,

vsd.SRC_ATTRIBUTE_CHAR41 SRC_ATTRIBUTE_CHAR41,

vsd.SRC_ATTRIBUTE_CHAR42 SRC_ATTRIBUTE_CHAR42,

vsd.SRC_ATTRIBUTE_CHAR43 SRC_ATTRIBUTE_CHAR43,

vsd.SRC_ATTRIBUTE_CHAR44 SRC_ATTRIBUTE_CHAR44,

vsd.SRC_ATTRIBUTE_CHAR45 SRC_ATTRIBUTE_CHAR45,

vsd.SRC_ATTRIBUTE_CHAR46 SRC_ATTRIBUTE_CHAR46,

vsd.SRC_ATTRIBUTE_CHAR47 SRC_ATTRIBUTE_CHAR47,

vsd.SRC_ATTRIBUTE_CHAR48 SRC_ATTRIBUTE_CHAR48,

vsd.SRC_ATTRIBUTE_CHAR49 SRC_ATTRIBUTE_CHAR49,

vsd.SRC_ATTRIBUTE_CHAR50 SRC_ATTRIBUTE_CHAR50,

vsd.SRC_ATTRIBUTE_CHAR51 SRC_ATTRIBUTE_CHAR51,

vsd.SRC_ATTRIBUTE_CHAR52 SRC_ATTRIBUTE_CHAR52,

vsd.SRC_ATTRIBUTE_CHAR53 SRC_ATTRIBUTE_CHAR53,

vsd.SRC_ATTRIBUTE_CHAR54 SRC_ATTRIBUTE_CHAR54,

vsd.SRC_ATTRIBUTE_CHAR55 SRC_ATTRIBUTE_CHAR55,

vsd.SRC_ATTRIBUTE_CHAR56 SRC_ATTRIBUTE_CHAR56,

vsd.SRC_ATTRIBUTE_CHAR57 SRC_ATTRIBUTE_CHAR57,

vsd.SRC_ATTRIBUTE_CHAR58 SRC_ATTRIBUTE_CHAR58,

vsd.SRC_ATTRIBUTE_CHAR59 SRC_ATTRIBUTE_CHAR59,

vsd.SRC_ATTRIBUTE_CHAR60 SRC_ATTRIBUTE_CHAR60,

vsd.DOCUMENT_NUMBER SRC_DOC_NUMBER,

vsd.DOCUMENT_TYPE SRC_DOC_TYPE,

vsd.CURRENCY_CODE SRC_CURRENCY_CODE,

vsd.SALESREP_ID SRC_SALESREP_ID,

vsd.SALESREP_NAME SRC_SALESREP_NAME,

vsd.BILL_TO_CUSTOMER_PARTY_ID SRC_BILL_TO_CUST_PARTY_ID,

vsd.BILL_TO_CUSTOMER_PARTY_NUM SRC_BILL_TO_CUST_PARTY_NUM,

vsd.BILL_TO_CUSTOMER_PARTY_NAME SRC_BILL_TO_CUST_PARTY_NAME,

vsd.BILL_TO_CUSTOMER_ID SRC_BILL_TO_CUST_ID,

vsd.SHIP_TO_CUSTOMER_ID SRC_SHIP_TO_CUST_ID,

vsd.BILL_TO_CUSTOMER_NUM SRC_BILL_TO_CUST_NUM,

vsd.SHIP_TO_CUSTOMER_NUM SRC_SHIP_TO_CUST_NUM,

vsd.BILL_TO_CUSTOMER_NAME SRC_BILL_TO_CUST_NAME,

vsd.SHIP_TO_CUSTOMER_NAME SRC_SHIP_TO_CUST_NAME,

vsd.BILL_TO_CUSTOMER_SITE_ID SRC_BILL_TO_CUST_SITE_ID,

vsd.BILL_TO_CUST_SITE_NAME SRC_BILL_TO_CUST_SITE_NAME,

vsd.SHIP_TO_CUSTOMER_SITE_ID SRC_SHIP_TO_CUST_SITE_ID,

vsd.SHIP_TO_CUST_SITE_NAME SRC_SHIP_TO_CUST_SITE_NAME,

vsd.BILL_TO_COUNTRY SRC_BILL_TO_COUNTRY,

vsd.SHIP_TO_COUNTRY SRC_SHIP_TO_COUNTRY,

vsd.ORG_ID SRC_ORG_ID,

vsd.ORGANIZATION_NAME SRC_ORGANIZATION_NAME,

vsd.LEDGER_ID SRC_LEDGER_ID,

vsd.LEDGER_NAME SRC_LEDGER_NAME,

vsd.LEGAL_ENTITY_ID SRC_LEGAL_ENTITY_ID,

vsd.LEGAL_ENTITY_NAME SRC_LEGAL_ENTITY_NAME,

vsd.CUST_PO_NUMBER SRC_CUST_PO_NUMBER,

vsd.CUSTOMER_CONTRACT_NUMBER SRC_CUST_CONTRACT_NUMBER,

vsd.SALES_AGREEMENT_NUMBER SRC_SALES_AGREEMENT_NUMBER,

vsd.QUOTE_NUMBER SRC_QUOTE_NUMBER,

vsd.EXCHANGE_RATE SRC_EXCHANGE_RATE,

vsd.EXCHANGE_RATE_TYPE SRC_EXCHANGE_RATE_TYPE,

vsd.EXCHANGE_DATE SRC_EXCHANGE_DATE,

vsd.BILL_TO_CUSTOMER_STATE SRC_BILL_TO_CUST_STATE,

vsd.BILL_TO_CUSTOMER_COUNTY SRC_BILL_TO_CUST_COUNTY,

vsd.BILL_TO_CUSTOMER_CITY SRC_BILL_TO_CUST_CITY,

vsd.BILL_TO_CUSTOMER_POSTAL_CODE SRC_BILL_TO_CUST_POSTAL_CODE,

vsd.BILL_TO_CUST_CLASSIFICATION SRC_BILL_TO_CUST_CLASS,

vsd.REQUEST_ID SRC_REQUEST_ID,

vsd.CREATED_BY SRC_CREATED_BY,

vsd.LEGAL_ENTITY_COUNTRY SRC_LEGAL_ENTITY_COUNTRY,

vsd.LEGAL_ENTITY_ADDRESS SRC_LEGAL_ENTITY_ADDRESS,

vsd.PAYMENT_TERM_ID SRC_PAYMENT_TERM_ID,

vsd.INVOICING_RULE_ID SRC_INVOICING_RULE_ID,

vsd.ACCOUNTING_RULE_ID SRC_ACCOUNTING_RULE_ID,

vsd.ACCOUNTING_RULE_DURATION SRC_ACCOUNTING_RULE_DURATION,

vsd.CANCELLED_FLAG SRC_CANCELLED_FLAG,

vsd.OPEN_FLAG SRC_OPEN_FLAG,

vsd.RETURN_REASON_CODE SRC_RETURN_REASON_CODE,

vdt.DOCUMENT_TYPE_CODE SRC_DOCUMENT_TYPE_CODE,

l.LINE_NUMBER,

l.EVENT_ID

FROM VRM_SOURCE_DOCUMENTS vsd,

VRM_SOURCE_DOC_TYPES_B vdt,

vrm_xla_lines_extract_gt l

WHERE l.SOURCE_DOCUMENT_ID = vsd.DOCUMENT_ID

AND vsd.DOCUMENT_TYPE_ID = vdt.DOCUMENT_TYPE_ID

AND l.level_flag = 'H'