VRM_SOURCE_DOC_LINES

Details

Schema: FUSION
Object owner: VRM
Object type: VIEW

Columns

Name
SRC_LINE_DOCUMENT_LINE_ID SRC_LINE_DOC_LINE_ID_INT_1 SRC_LINE_DOC_LINE_ID_INT_2 SRC_LINE_DOC_LINE_ID_INT_3 SRC_LINE_DOC_LINE_ID_INT_4 SRC_LINE_DOC_LINE_ID_INT_5 SRC_LINE_DOC_LINE_ID_CHAR_1 SRC_LINE_DOC_LINE_ID_CHAR_2 SRC_LINE_DOC_LINE_ID_CHAR_3 SRC_LINE_DOC_LINE_ID_CHAR_4 SRC_LINE_DOC_LINE_ID_CHAR_5 SRC_LINE_ATTRIBUTE_CATEGORY SRC_LINE_ATTRIBUTE_CHAR1 SRC_LINE_ATTRIBUTE_CHAR2 SRC_LINE_ATTRIBUTE_CHAR3 SRC_LINE_ATTRIBUTE_CHAR4 SRC_LINE_ATTRIBUTE_CHAR5 SRC_LINE_ATTRIBUTE_CHAR6 SRC_LINE_ATTRIBUTE_CHAR7 SRC_LINE_ATTRIBUTE_CHAR8 SRC_LINE_ATTRIBUTE_CHAR9 SRC_LINE_ATTRIBUTE_CHAR10 SRC_LINE_ATTRIBUTE_CHAR11 SRC_LINE_ATTRIBUTE_CHAR12 SRC_LINE_ATTRIBUTE_CHAR13 SRC_LINE_ATTRIBUTE_CHAR14 SRC_LINE_ATTRIBUTE_CHAR15 SRC_LINE_ATTRIBUTE_CHAR16 SRC_LINE_ATTRIBUTE_CHAR17 SRC_LINE_ATTRIBUTE_CHAR18 SRC_LINE_ATTRIBUTE_CHAR19 SRC_LINE_ATTRIBUTE_CHAR20 SRC_LINE_ATTRIBUTE_CHAR21 SRC_LINE_ATTRIBUTE_CHAR22 SRC_LINE_ATTRIBUTE_CHAR23 SRC_LINE_ATTRIBUTE_CHAR24 SRC_LINE_ATTRIBUTE_CHAR25 SRC_LINE_ATTRIBUTE_CHAR26 SRC_LINE_ATTRIBUTE_CHAR27 SRC_LINE_ATTRIBUTE_CHAR28 SRC_LINE_ATTRIBUTE_CHAR29 SRC_LINE_ATTRIBUTE_CHAR30 SRC_LINE_ATTRIBUTE_CHAR31 SRC_LINE_ATTRIBUTE_CHAR32 SRC_LINE_ATTRIBUTE_CHAR33 SRC_LINE_ATTRIBUTE_CHAR34 SRC_LINE_ATTRIBUTE_CHAR35 SRC_LINE_ATTRIBUTE_CHAR36 SRC_LINE_ATTRIBUTE_CHAR37 SRC_LINE_ATTRIBUTE_CHAR38 SRC_LINE_ATTRIBUTE_CHAR39 SRC_LINE_ATTRIBUTE_CHAR40 SRC_LINE_ATTRIBUTE_CHAR41 SRC_LINE_ATTRIBUTE_CHAR42 SRC_LINE_ATTRIBUTE_CHAR43 SRC_LINE_ATTRIBUTE_CHAR44 SRC_LINE_ATTRIBUTE_CHAR45 SRC_LINE_ATTRIBUTE_CHAR46 SRC_LINE_ATTRIBUTE_CHAR47 SRC_LINE_ATTRIBUTE_CHAR48 SRC_LINE_ATTRIBUTE_CHAR49 SRC_LINE_ATTRIBUTE_CHAR50 SRC_LINE_ATTRIBUTE_CHAR51 SRC_LINE_ATTRIBUTE_CHAR52 SRC_LINE_ATTRIBUTE_CHAR53 SRC_LINE_ATTRIBUTE_CHAR54 SRC_LINE_ATTRIBUTE_CHAR55 SRC_LINE_ATTRIBUTE_CHAR56 SRC_LINE_ATTRIBUTE_CHAR57 SRC_LINE_ATTRIBUTE_CHAR58 SRC_LINE_ATTRIBUTE_CHAR59 SRC_LINE_ATTRIBUTE_CHAR60 SRC_LINE_LINE_TYPE SRC_LINE_INVENTORY_ORG_ID SRC_LINE_ITEM_ID SRC_LINE_ITEM_NUMBER SRC_LINE_ITEM_DESCRIPTION SRC_LINE_MEMO_LINE_ID SRC_LINE_UOM_CODE SRC_LINE_QUANTITY SRC_LINE_UNIT_SELLING_PRICE SRC_LINE_UNIT_LIST_PRICE SRC_LINE_DISCOUNT_PERCENTAGE SRC_LINE_UT_SELL_PCT_PRICE SRC_LINE_UT_LIST_PCT_PRICE SRC_LINE_BASE_PRICE SRC_LINE_LINE_AMOUNT SRC_LINE_DELIVERED_FLAG SRC_LINE_INVOICED_FLAG SRC_LINE_FULFILLED_FLAG SRC_LINE_CANCELLED_FLAG SRC_LINE_DELIVERY_STATUS SRC_LINE_COMMENTS SRC_LINE_MEMO_LINE_SEQ_ID SRC_LINE_PAYMENT_AMOUNT SRC_LINE_QUANTITY_CANCELLED SRC_LINE_QUANTITY_SHIPPED SRC_LINE_QUANTITY_ORDERED SRC_LINE_QUANTITY_FULFILLED SRC_LINE_QUANTITY_INVOICED SRC_LINE_PROJECT_ID SRC_LINE_TASK_ID SRC_LINE_RULE_START_DATE SRC_LINE_RULE_END_DATE SRC_LINE_ACTUAL_SHIPMENT_DATE SRC_LINE_ACTUAL_ARRIVAL_DATE SRC_LINE_FOB_POINT_CODE SRC_LINE_FRIT_TERMS_CODE SRC_LINE_SCHED_STATUS_CODE SRC_LINE_SOURCE_TYPE_CODE SRC_LINE_SHIP_INTFLAG SRC_LINE_CR_INVOICE_LINE_ID SRC_LINE_REF_CUST_TRX_LINE_ID SRC_LINE_SHIPPABLE_FLAG SRC_LINE_FULMT_DATE SRC_LINE_ACTUAL_FULMT_DATE SRC_LINE_CONTINGENCY_ID SRC_LINE_REVREC_EVENT_CODE SRC_LINE_REVREC_EXPIRE_DAYS SRC_LINE_ACCEPTED_QUANTITY SRC_LINE_ACCEPTED_BY SRC_LINE_REVREC_COMMENTS SRC_LINE_REVREC_REF_DOC SRC_LINE_REVREC_SIGNATURE SRC_LINE_REVREC_SIGNATURE_DATE SRC_LINE_REVREC_IMPLICIT_FLAG LINE_NUMBER EVENT_ID

Name

SRC_LINE_DOCUMENT_LINE_ID

SRC_LINE_DOC_LINE_ID_INT_1

SRC_LINE_DOC_LINE_ID_INT_2

SRC_LINE_DOC_LINE_ID_INT_3

SRC_LINE_DOC_LINE_ID_INT_4

SRC_LINE_DOC_LINE_ID_INT_5

SRC_LINE_DOC_LINE_ID_CHAR_1

SRC_LINE_DOC_LINE_ID_CHAR_2

SRC_LINE_DOC_LINE_ID_CHAR_3

SRC_LINE_DOC_LINE_ID_CHAR_4

SRC_LINE_DOC_LINE_ID_CHAR_5

SRC_LINE_ATTRIBUTE_CATEGORY

SRC_LINE_ATTRIBUTE_CHAR1

SRC_LINE_ATTRIBUTE_CHAR2

SRC_LINE_ATTRIBUTE_CHAR3

SRC_LINE_ATTRIBUTE_CHAR4

SRC_LINE_ATTRIBUTE_CHAR5

SRC_LINE_ATTRIBUTE_CHAR6

SRC_LINE_ATTRIBUTE_CHAR7

SRC_LINE_ATTRIBUTE_CHAR8

SRC_LINE_ATTRIBUTE_CHAR9

SRC_LINE_ATTRIBUTE_CHAR10

SRC_LINE_ATTRIBUTE_CHAR11

SRC_LINE_ATTRIBUTE_CHAR12

SRC_LINE_ATTRIBUTE_CHAR13

SRC_LINE_ATTRIBUTE_CHAR14

SRC_LINE_ATTRIBUTE_CHAR15

SRC_LINE_ATTRIBUTE_CHAR16

SRC_LINE_ATTRIBUTE_CHAR17

SRC_LINE_ATTRIBUTE_CHAR18

SRC_LINE_ATTRIBUTE_CHAR19

SRC_LINE_ATTRIBUTE_CHAR20

SRC_LINE_ATTRIBUTE_CHAR21

SRC_LINE_ATTRIBUTE_CHAR22

SRC_LINE_ATTRIBUTE_CHAR23

SRC_LINE_ATTRIBUTE_CHAR24

SRC_LINE_ATTRIBUTE_CHAR25

SRC_LINE_ATTRIBUTE_CHAR26

SRC_LINE_ATTRIBUTE_CHAR27

SRC_LINE_ATTRIBUTE_CHAR28

SRC_LINE_ATTRIBUTE_CHAR29

SRC_LINE_ATTRIBUTE_CHAR30

SRC_LINE_ATTRIBUTE_CHAR31

SRC_LINE_ATTRIBUTE_CHAR32

SRC_LINE_ATTRIBUTE_CHAR33

SRC_LINE_ATTRIBUTE_CHAR34

SRC_LINE_ATTRIBUTE_CHAR35

SRC_LINE_ATTRIBUTE_CHAR36

SRC_LINE_ATTRIBUTE_CHAR37

SRC_LINE_ATTRIBUTE_CHAR38

SRC_LINE_ATTRIBUTE_CHAR39

SRC_LINE_ATTRIBUTE_CHAR40

SRC_LINE_ATTRIBUTE_CHAR41

SRC_LINE_ATTRIBUTE_CHAR42

SRC_LINE_ATTRIBUTE_CHAR43

SRC_LINE_ATTRIBUTE_CHAR44

SRC_LINE_ATTRIBUTE_CHAR45

SRC_LINE_ATTRIBUTE_CHAR46

SRC_LINE_ATTRIBUTE_CHAR47

SRC_LINE_ATTRIBUTE_CHAR48

SRC_LINE_ATTRIBUTE_CHAR49

SRC_LINE_ATTRIBUTE_CHAR50

SRC_LINE_ATTRIBUTE_CHAR51

SRC_LINE_ATTRIBUTE_CHAR52

SRC_LINE_ATTRIBUTE_CHAR53

SRC_LINE_ATTRIBUTE_CHAR54

SRC_LINE_ATTRIBUTE_CHAR55

SRC_LINE_ATTRIBUTE_CHAR56

SRC_LINE_ATTRIBUTE_CHAR57

SRC_LINE_ATTRIBUTE_CHAR58

SRC_LINE_ATTRIBUTE_CHAR59

SRC_LINE_ATTRIBUTE_CHAR60

SRC_LINE_LINE_TYPE

SRC_LINE_INVENTORY_ORG_ID

SRC_LINE_ITEM_ID

SRC_LINE_ITEM_NUMBER

SRC_LINE_ITEM_DESCRIPTION

SRC_LINE_MEMO_LINE_ID

SRC_LINE_UOM_CODE

SRC_LINE_QUANTITY

SRC_LINE_UNIT_SELLING_PRICE

SRC_LINE_UNIT_LIST_PRICE

SRC_LINE_DISCOUNT_PERCENTAGE

SRC_LINE_UT_SELL_PCT_PRICE

SRC_LINE_UT_LIST_PCT_PRICE

SRC_LINE_BASE_PRICE

SRC_LINE_LINE_AMOUNT

SRC_LINE_DELIVERED_FLAG

SRC_LINE_INVOICED_FLAG

SRC_LINE_FULFILLED_FLAG

SRC_LINE_CANCELLED_FLAG

SRC_LINE_DELIVERY_STATUS

SRC_LINE_COMMENTS

SRC_LINE_MEMO_LINE_SEQ_ID

SRC_LINE_PAYMENT_AMOUNT

SRC_LINE_QUANTITY_CANCELLED

SRC_LINE_QUANTITY_SHIPPED

SRC_LINE_QUANTITY_ORDERED

SRC_LINE_QUANTITY_FULFILLED

SRC_LINE_QUANTITY_INVOICED

SRC_LINE_PROJECT_ID

SRC_LINE_TASK_ID

SRC_LINE_RULE_START_DATE

SRC_LINE_RULE_END_DATE

SRC_LINE_ACTUAL_SHIPMENT_DATE

SRC_LINE_ACTUAL_ARRIVAL_DATE

SRC_LINE_FOB_POINT_CODE

SRC_LINE_FRIT_TERMS_CODE

SRC_LINE_SCHED_STATUS_CODE

SRC_LINE_SOURCE_TYPE_CODE

SRC_LINE_SHIP_INTFLAG

SRC_LINE_CR_INVOICE_LINE_ID

SRC_LINE_REF_CUST_TRX_LINE_ID

SRC_LINE_SHIPPABLE_FLAG

SRC_LINE_FULMT_DATE

SRC_LINE_ACTUAL_FULMT_DATE

SRC_LINE_CONTINGENCY_ID

SRC_LINE_REVREC_EVENT_CODE

SRC_LINE_REVREC_EXPIRE_DAYS

SRC_LINE_ACCEPTED_QUANTITY

SRC_LINE_ACCEPTED_BY

SRC_LINE_REVREC_COMMENTS

SRC_LINE_REVREC_REF_DOC

SRC_LINE_REVREC_SIGNATURE

SRC_LINE_REVREC_SIGNATURE_DATE

SRC_LINE_REVREC_IMPLICIT_FLAG

LINE_NUMBER

EVENT_ID

Query

SQL_Statement
SELECT vsdl.DOCUMENT_LINE_ID SRC_LINE_DOCUMENT_LINE_ID, vsdl.DOC_LINE_ID_INT_1 SRC_LINE_DOC_LINE_ID_INT_1, vsdl.DOC_LINE_ID_INT_2 SRC_LINE_DOC_LINE_ID_INT_2, vsdl.DOC_LINE_ID_INT_3 SRC_LINE_DOC_LINE_ID_INT_3, vsdl.DOC_LINE_ID_INT_4 SRC_LINE_DOC_LINE_ID_INT_4, vsdl.DOC_LINE_ID_INT_5 SRC_LINE_DOC_LINE_ID_INT_5, vsdl.DOC_LINE_ID_CHAR_1 SRC_LINE_DOC_LINE_ID_CHAR_1, vsdl.DOC_LINE_ID_CHAR_2 SRC_LINE_DOC_LINE_ID_CHAR_2, vsdl.DOC_LINE_ID_CHAR_3 SRC_LINE_DOC_LINE_ID_CHAR_3, vsdl.DOC_LINE_ID_CHAR_4 SRC_LINE_DOC_LINE_ID_CHAR_4, vsdl.DOC_LINE_ID_CHAR_5 SRC_LINE_DOC_LINE_ID_CHAR_5, vsdl.SRC_ATTRIBUTE_CATEGORY SRC_LINE_ATTRIBUTE_CATEGORY, vsdl.SRC_ATTRIBUTE_CHAR1 SRC_LINE_ATTRIBUTE_CHAR1, vsdl.SRC_ATTRIBUTE_CHAR2 SRC_LINE_ATTRIBUTE_CHAR2, vsdl.SRC_ATTRIBUTE_CHAR3 SRC_LINE_ATTRIBUTE_CHAR3, vsdl.SRC_ATTRIBUTE_CHAR4 SRC_LINE_ATTRIBUTE_CHAR4, vsdl.SRC_ATTRIBUTE_CHAR5 SRC_LINE_ATTRIBUTE_CHAR5, vsdl.SRC_ATTRIBUTE_CHAR6 SRC_LINE_ATTRIBUTE_CHAR6, vsdl.SRC_ATTRIBUTE_CHAR7 SRC_LINE_ATTRIBUTE_CHAR7, vsdl.SRC_ATTRIBUTE_CHAR8 SRC_LINE_ATTRIBUTE_CHAR8, vsdl.SRC_ATTRIBUTE_CHAR9 SRC_LINE_ATTRIBUTE_CHAR9, vsdl.SRC_ATTRIBUTE_CHAR10 SRC_LINE_ATTRIBUTE_CHAR10, vsdl.SRC_ATTRIBUTE_CHAR11 SRC_LINE_ATTRIBUTE_CHAR11, vsdl.SRC_ATTRIBUTE_CHAR12 SRC_LINE_ATTRIBUTE_CHAR12, vsdl.SRC_ATTRIBUTE_CHAR13 SRC_LINE_ATTRIBUTE_CHAR13, vsdl.SRC_ATTRIBUTE_CHAR14 SRC_LINE_ATTRIBUTE_CHAR14, vsdl.SRC_ATTRIBUTE_CHAR15 SRC_LINE_ATTRIBUTE_CHAR15, vsdl.SRC_ATTRIBUTE_CHAR16 SRC_LINE_ATTRIBUTE_CHAR16, vsdl.SRC_ATTRIBUTE_CHAR17 SRC_LINE_ATTRIBUTE_CHAR17, vsdl.SRC_ATTRIBUTE_CHAR18 SRC_LINE_ATTRIBUTE_CHAR18, vsdl.SRC_ATTRIBUTE_CHAR19 SRC_LINE_ATTRIBUTE_CHAR19, vsdl.SRC_ATTRIBUTE_CHAR20 SRC_LINE_ATTRIBUTE_CHAR20, vsdl.SRC_ATTRIBUTE_CHAR21 SRC_LINE_ATTRIBUTE_CHAR21, vsdl.SRC_ATTRIBUTE_CHAR22 SRC_LINE_ATTRIBUTE_CHAR22, vsdl.SRC_ATTRIBUTE_CHAR23 SRC_LINE_ATTRIBUTE_CHAR23, vsdl.SRC_ATTRIBUTE_CHAR24 SRC_LINE_ATTRIBUTE_CHAR24, vsdl.SRC_ATTRIBUTE_CHAR25 SRC_LINE_ATTRIBUTE_CHAR25, vsdl.SRC_ATTRIBUTE_CHAR26 SRC_LINE_ATTRIBUTE_CHAR26, vsdl.SRC_ATTRIBUTE_CHAR27 SRC_LINE_ATTRIBUTE_CHAR27, vsdl.SRC_ATTRIBUTE_CHAR28 SRC_LINE_ATTRIBUTE_CHAR28, vsdl.SRC_ATTRIBUTE_CHAR29 SRC_LINE_ATTRIBUTE_CHAR29, vsdl.SRC_ATTRIBUTE_CHAR30 SRC_LINE_ATTRIBUTE_CHAR30, vsdl.SRC_ATTRIBUTE_CHAR31 SRC_LINE_ATTRIBUTE_CHAR31, vsdl.SRC_ATTRIBUTE_CHAR32 SRC_LINE_ATTRIBUTE_CHAR32, vsdl.SRC_ATTRIBUTE_CHAR33 SRC_LINE_ATTRIBUTE_CHAR33, vsdl.SRC_ATTRIBUTE_CHAR34 SRC_LINE_ATTRIBUTE_CHAR34, vsdl.SRC_ATTRIBUTE_CHAR35 SRC_LINE_ATTRIBUTE_CHAR35, vsdl.SRC_ATTRIBUTE_CHAR36 SRC_LINE_ATTRIBUTE_CHAR36, vsdl.SRC_ATTRIBUTE_CHAR37 SRC_LINE_ATTRIBUTE_CHAR37, vsdl.SRC_ATTRIBUTE_CHAR38 SRC_LINE_ATTRIBUTE_CHAR38, vsdl.SRC_ATTRIBUTE_CHAR39 SRC_LINE_ATTRIBUTE_CHAR39, vsdl.SRC_ATTRIBUTE_CHAR40 SRC_LINE_ATTRIBUTE_CHAR40, vsdl.SRC_ATTRIBUTE_CHAR41 SRC_LINE_ATTRIBUTE_CHAR41, vsdl.SRC_ATTRIBUTE_CHAR42 SRC_LINE_ATTRIBUTE_CHAR42, vsdl.SRC_ATTRIBUTE_CHAR43 SRC_LINE_ATTRIBUTE_CHAR43, vsdl.SRC_ATTRIBUTE_CHAR44 SRC_LINE_ATTRIBUTE_CHAR44, vsdl.SRC_ATTRIBUTE_CHAR45 SRC_LINE_ATTRIBUTE_CHAR45, vsdl.SRC_ATTRIBUTE_CHAR46 SRC_LINE_ATTRIBUTE_CHAR46, vsdl.SRC_ATTRIBUTE_CHAR47 SRC_LINE_ATTRIBUTE_CHAR47, vsdl.SRC_ATTRIBUTE_CHAR48 SRC_LINE_ATTRIBUTE_CHAR48, vsdl.SRC_ATTRIBUTE_CHAR49 SRC_LINE_ATTRIBUTE_CHAR49, vsdl.SRC_ATTRIBUTE_CHAR50 SRC_LINE_ATTRIBUTE_CHAR50, vsdl.SRC_ATTRIBUTE_CHAR51 SRC_LINE_ATTRIBUTE_CHAR51, vsdl.SRC_ATTRIBUTE_CHAR52 SRC_LINE_ATTRIBUTE_CHAR52, vsdl.SRC_ATTRIBUTE_CHAR53 SRC_LINE_ATTRIBUTE_CHAR53, vsdl.SRC_ATTRIBUTE_CHAR54 SRC_LINE_ATTRIBUTE_CHAR54, vsdl.SRC_ATTRIBUTE_CHAR55 SRC_LINE_ATTRIBUTE_CHAR55, vsdl.SRC_ATTRIBUTE_CHAR56 SRC_LINE_ATTRIBUTE_CHAR56, vsdl.SRC_ATTRIBUTE_CHAR57 SRC_LINE_ATTRIBUTE_CHAR57, vsdl.SRC_ATTRIBUTE_CHAR58 SRC_LINE_ATTRIBUTE_CHAR58, vsdl.SRC_ATTRIBUTE_CHAR59 SRC_LINE_ATTRIBUTE_CHAR59, vsdl.SRC_ATTRIBUTE_CHAR60 SRC_LINE_ATTRIBUTE_CHAR60, vsdl.LINE_TYPE SRC_LINE_LINE_TYPE, vsdl.INVENTORY_ORG_ID SRC_LINE_INVENTORY_ORG_ID, vsdl.ITEM_ID SRC_LINE_ITEM_ID, vsdl.ITEM_NUMBER SRC_LINE_ITEM_NUMBER, vsdl.ITEM_DESCRIPTION SRC_LINE_ITEM_DESCRIPTION, vsdl.MEMO_LINE_ID SRC_LINE_MEMO_LINE_ID, vsdl.UOM_CODE SRC_LINE_UOM_CODE, vsdl.QUANTITY SRC_LINE_QUANTITY, vsdl.UNIT_SELLING_PRICE SRC_LINE_UNIT_SELLING_PRICE, vsdl.UNIT_LIST_PRICE SRC_LINE_UNIT_LIST_PRICE, vsdl.DISCOUNT_PERCENTAGE SRC_LINE_DISCOUNT_PERCENTAGE, vsdl.UNIT_SELLING_PCT_BASE_PRICE SRC_LINE_UT_SELL_PCT_PRICE, vsdl.UNIT_LIST_PCT_BASE_PRICE SRC_LINE_UT_LIST_PCT_PRICE, vsdl.BASE_PRICE SRC_LINE_BASE_PRICE, vsdl.LINE_AMOUNT SRC_LINE_LINE_AMOUNT, vsdl.DELIVERED_FLAG SRC_LINE_DELIVERED_FLAG, vsdl.INVOICED_FLAG SRC_LINE_INVOICED_FLAG, vsdl.FULFILLED_FLAG SRC_LINE_FULFILLED_FLAG, vsdl.CANCELLED_FLAG SRC_LINE_CANCELLED_FLAG, vsdl.DELIVERY_STATUS SRC_LINE_DELIVERY_STATUS, vsdl.COMMENTS SRC_LINE_COMMENTS, vsdl.MEMO_LINE_SEQ_ID SRC_LINE_MEMO_LINE_SEQ_ID, vsdl.PAYMENT_AMOUNT SRC_LINE_PAYMENT_AMOUNT, vsdl.QUANTITY_CANCELLED SRC_LINE_QUANTITY_CANCELLED, vsdl.QUANTITY_SHIPPED SRC_LINE_QUANTITY_SHIPPED, vsdl.QUANTITY_ORDERED SRC_LINE_QUANTITY_ORDERED, vsdl.QUANTITY_FULFILLED SRC_LINE_QUANTITY_FULFILLED, vsdl.QUANTITY_INVOICED SRC_LINE_QUANTITY_INVOICED, vsdl.PROJECT_ID SRC_LINE_PROJECT_ID, vsdl.TASK_ID SRC_LINE_TASK_ID, vsdl.RULE_START_DATE SRC_LINE_RULE_START_DATE, vsdl.RULE_END_DATE SRC_LINE_RULE_END_DATE, vsdl.ACTUAL_SHIPMENT_DATE SRC_LINE_ACTUAL_SHIPMENT_DATE, vsdl.ACTUAL_ARRIVAL_DATE SRC_LINE_ACTUAL_ARRIVAL_DATE, vsdl.FOB_POINT_CODE SRC_LINE_FOB_POINT_CODE, vsdl.FRIEGHT_TERMS_CODE SRC_LINE_FRIT_TERMS_CODE, vsdl.SCHEDULED_STATUS_CODE SRC_LINE_SCHED_STATUS_CODE, vsdl.SOURCE_TYPE_CODE SRC_LINE_SOURCE_TYPE_CODE, vsdl.SHIPPING_INTERFACED_FLAG SRC_LINE_SHIP_INTFLAG, vsdl.CREDIT_INVOICE_LINE_ID SRC_LINE_CR_INVOICE_LINE_ID, vsdl.REFERENCE_CUSTOMER_TRX_LINE_ID SRC_LINE_REF_CUST_TRX_LINE_ID, vsdl.SHIPPABLE_FLAG SRC_LINE_SHIPPABLE_FLAG, vsdl.FULFILLMENT_DATE SRC_LINE_FULMT_DATE, vsdl.ACTUAL_FULFILLMENT_DATE SRC_LINE_ACTUAL_FULMT_DATE, vsdl.CONTINGENCY_ID SRC_LINE_CONTINGENCY_ID, vsdl.REVREC_EVENT_CODE SRC_LINE_REVREC_EVENT_CODE, vsdl.REVREC_EXPIRATION_DAYS SRC_LINE_REVREC_EXPIRE_DAYS, vsdl.ACCEPTED_QUANTITY SRC_LINE_ACCEPTED_QUANTITY, vsdl.ACCEPTED_BY SRC_LINE_ACCEPTED_BY, vsdl.REVREC_COMMENTS SRC_LINE_REVREC_COMMENTS, vsdl.REVREC_REFERENCE_DOCUMENT SRC_LINE_REVREC_REF_DOC, vsdl.REVREC_SIGNATURE SRC_LINE_REVREC_SIGNATURE, vsdl.REVREC_SIGNATURE_DATE SRC_LINE_REVREC_SIGNATURE_DATE, vsdl.REVREC_IMPLICIT_FLAG SRC_LINE_REVREC_IMPLICIT_FLAG, l.LINE_NUMBER, l.EVENT_ID FROM VRM_SOURCE_DOC_LINES vsdl, vrm_xla_lines_extract_gt l WHERE l.SOURCE_DOCUMENT_LINE_ID = vsdl.DOCUMENT_LINE_ID AND l.level_flag = 'L'

SQL_Statement

SELECT

vsdl.DOCUMENT_LINE_ID SRC_LINE_DOCUMENT_LINE_ID,

vsdl.DOC_LINE_ID_INT_1 SRC_LINE_DOC_LINE_ID_INT_1,

vsdl.DOC_LINE_ID_INT_2 SRC_LINE_DOC_LINE_ID_INT_2,

vsdl.DOC_LINE_ID_INT_3 SRC_LINE_DOC_LINE_ID_INT_3,

vsdl.DOC_LINE_ID_INT_4 SRC_LINE_DOC_LINE_ID_INT_4,

vsdl.DOC_LINE_ID_INT_5 SRC_LINE_DOC_LINE_ID_INT_5,

vsdl.DOC_LINE_ID_CHAR_1 SRC_LINE_DOC_LINE_ID_CHAR_1,

vsdl.DOC_LINE_ID_CHAR_2 SRC_LINE_DOC_LINE_ID_CHAR_2,

vsdl.DOC_LINE_ID_CHAR_3 SRC_LINE_DOC_LINE_ID_CHAR_3,

vsdl.DOC_LINE_ID_CHAR_4 SRC_LINE_DOC_LINE_ID_CHAR_4,

vsdl.DOC_LINE_ID_CHAR_5 SRC_LINE_DOC_LINE_ID_CHAR_5,

vsdl.SRC_ATTRIBUTE_CATEGORY SRC_LINE_ATTRIBUTE_CATEGORY,

vsdl.SRC_ATTRIBUTE_CHAR1 SRC_LINE_ATTRIBUTE_CHAR1,

vsdl.SRC_ATTRIBUTE_CHAR2 SRC_LINE_ATTRIBUTE_CHAR2,

vsdl.SRC_ATTRIBUTE_CHAR3 SRC_LINE_ATTRIBUTE_CHAR3,

vsdl.SRC_ATTRIBUTE_CHAR4 SRC_LINE_ATTRIBUTE_CHAR4,

vsdl.SRC_ATTRIBUTE_CHAR5 SRC_LINE_ATTRIBUTE_CHAR5,

vsdl.SRC_ATTRIBUTE_CHAR6 SRC_LINE_ATTRIBUTE_CHAR6,

vsdl.SRC_ATTRIBUTE_CHAR7 SRC_LINE_ATTRIBUTE_CHAR7,

vsdl.SRC_ATTRIBUTE_CHAR8 SRC_LINE_ATTRIBUTE_CHAR8,

vsdl.SRC_ATTRIBUTE_CHAR9 SRC_LINE_ATTRIBUTE_CHAR9,

vsdl.SRC_ATTRIBUTE_CHAR10 SRC_LINE_ATTRIBUTE_CHAR10,

vsdl.SRC_ATTRIBUTE_CHAR11 SRC_LINE_ATTRIBUTE_CHAR11,

vsdl.SRC_ATTRIBUTE_CHAR12 SRC_LINE_ATTRIBUTE_CHAR12,

vsdl.SRC_ATTRIBUTE_CHAR13 SRC_LINE_ATTRIBUTE_CHAR13,

vsdl.SRC_ATTRIBUTE_CHAR14 SRC_LINE_ATTRIBUTE_CHAR14,

vsdl.SRC_ATTRIBUTE_CHAR15 SRC_LINE_ATTRIBUTE_CHAR15,

vsdl.SRC_ATTRIBUTE_CHAR16 SRC_LINE_ATTRIBUTE_CHAR16,

vsdl.SRC_ATTRIBUTE_CHAR17 SRC_LINE_ATTRIBUTE_CHAR17,

vsdl.SRC_ATTRIBUTE_CHAR18 SRC_LINE_ATTRIBUTE_CHAR18,

vsdl.SRC_ATTRIBUTE_CHAR19 SRC_LINE_ATTRIBUTE_CHAR19,

vsdl.SRC_ATTRIBUTE_CHAR20 SRC_LINE_ATTRIBUTE_CHAR20,

vsdl.SRC_ATTRIBUTE_CHAR21 SRC_LINE_ATTRIBUTE_CHAR21,

vsdl.SRC_ATTRIBUTE_CHAR22 SRC_LINE_ATTRIBUTE_CHAR22,

vsdl.SRC_ATTRIBUTE_CHAR23 SRC_LINE_ATTRIBUTE_CHAR23,

vsdl.SRC_ATTRIBUTE_CHAR24 SRC_LINE_ATTRIBUTE_CHAR24,

vsdl.SRC_ATTRIBUTE_CHAR25 SRC_LINE_ATTRIBUTE_CHAR25,

vsdl.SRC_ATTRIBUTE_CHAR26 SRC_LINE_ATTRIBUTE_CHAR26,

vsdl.SRC_ATTRIBUTE_CHAR27 SRC_LINE_ATTRIBUTE_CHAR27,

vsdl.SRC_ATTRIBUTE_CHAR28 SRC_LINE_ATTRIBUTE_CHAR28,

vsdl.SRC_ATTRIBUTE_CHAR29 SRC_LINE_ATTRIBUTE_CHAR29,

vsdl.SRC_ATTRIBUTE_CHAR30 SRC_LINE_ATTRIBUTE_CHAR30,

vsdl.SRC_ATTRIBUTE_CHAR31 SRC_LINE_ATTRIBUTE_CHAR31,

vsdl.SRC_ATTRIBUTE_CHAR32 SRC_LINE_ATTRIBUTE_CHAR32,

vsdl.SRC_ATTRIBUTE_CHAR33 SRC_LINE_ATTRIBUTE_CHAR33,

vsdl.SRC_ATTRIBUTE_CHAR34 SRC_LINE_ATTRIBUTE_CHAR34,

vsdl.SRC_ATTRIBUTE_CHAR35 SRC_LINE_ATTRIBUTE_CHAR35,

vsdl.SRC_ATTRIBUTE_CHAR36 SRC_LINE_ATTRIBUTE_CHAR36,

vsdl.SRC_ATTRIBUTE_CHAR37 SRC_LINE_ATTRIBUTE_CHAR37,

vsdl.SRC_ATTRIBUTE_CHAR38 SRC_LINE_ATTRIBUTE_CHAR38,

vsdl.SRC_ATTRIBUTE_CHAR39 SRC_LINE_ATTRIBUTE_CHAR39,

vsdl.SRC_ATTRIBUTE_CHAR40 SRC_LINE_ATTRIBUTE_CHAR40,

vsdl.SRC_ATTRIBUTE_CHAR41 SRC_LINE_ATTRIBUTE_CHAR41,

vsdl.SRC_ATTRIBUTE_CHAR42 SRC_LINE_ATTRIBUTE_CHAR42,

vsdl.SRC_ATTRIBUTE_CHAR43 SRC_LINE_ATTRIBUTE_CHAR43,

vsdl.SRC_ATTRIBUTE_CHAR44 SRC_LINE_ATTRIBUTE_CHAR44,

vsdl.SRC_ATTRIBUTE_CHAR45 SRC_LINE_ATTRIBUTE_CHAR45,

vsdl.SRC_ATTRIBUTE_CHAR46 SRC_LINE_ATTRIBUTE_CHAR46,

vsdl.SRC_ATTRIBUTE_CHAR47 SRC_LINE_ATTRIBUTE_CHAR47,

vsdl.SRC_ATTRIBUTE_CHAR48 SRC_LINE_ATTRIBUTE_CHAR48,

vsdl.SRC_ATTRIBUTE_CHAR49 SRC_LINE_ATTRIBUTE_CHAR49,

vsdl.SRC_ATTRIBUTE_CHAR50 SRC_LINE_ATTRIBUTE_CHAR50,

vsdl.SRC_ATTRIBUTE_CHAR51 SRC_LINE_ATTRIBUTE_CHAR51,

vsdl.SRC_ATTRIBUTE_CHAR52 SRC_LINE_ATTRIBUTE_CHAR52,

vsdl.SRC_ATTRIBUTE_CHAR53 SRC_LINE_ATTRIBUTE_CHAR53,

vsdl.SRC_ATTRIBUTE_CHAR54 SRC_LINE_ATTRIBUTE_CHAR54,

vsdl.SRC_ATTRIBUTE_CHAR55 SRC_LINE_ATTRIBUTE_CHAR55,

vsdl.SRC_ATTRIBUTE_CHAR56 SRC_LINE_ATTRIBUTE_CHAR56,

vsdl.SRC_ATTRIBUTE_CHAR57 SRC_LINE_ATTRIBUTE_CHAR57,

vsdl.SRC_ATTRIBUTE_CHAR58 SRC_LINE_ATTRIBUTE_CHAR58,

vsdl.SRC_ATTRIBUTE_CHAR59 SRC_LINE_ATTRIBUTE_CHAR59,

vsdl.SRC_ATTRIBUTE_CHAR60 SRC_LINE_ATTRIBUTE_CHAR60,

vsdl.LINE_TYPE SRC_LINE_LINE_TYPE,

vsdl.INVENTORY_ORG_ID SRC_LINE_INVENTORY_ORG_ID,

vsdl.ITEM_ID SRC_LINE_ITEM_ID,

vsdl.ITEM_NUMBER SRC_LINE_ITEM_NUMBER,

vsdl.ITEM_DESCRIPTION SRC_LINE_ITEM_DESCRIPTION,

vsdl.MEMO_LINE_ID SRC_LINE_MEMO_LINE_ID,

vsdl.UOM_CODE SRC_LINE_UOM_CODE,

vsdl.QUANTITY SRC_LINE_QUANTITY,

vsdl.UNIT_SELLING_PRICE SRC_LINE_UNIT_SELLING_PRICE,

vsdl.UNIT_LIST_PRICE SRC_LINE_UNIT_LIST_PRICE,

vsdl.DISCOUNT_PERCENTAGE SRC_LINE_DISCOUNT_PERCENTAGE,

vsdl.UNIT_SELLING_PCT_BASE_PRICE SRC_LINE_UT_SELL_PCT_PRICE,

vsdl.UNIT_LIST_PCT_BASE_PRICE SRC_LINE_UT_LIST_PCT_PRICE,

vsdl.BASE_PRICE SRC_LINE_BASE_PRICE,

vsdl.LINE_AMOUNT SRC_LINE_LINE_AMOUNT,

vsdl.DELIVERED_FLAG SRC_LINE_DELIVERED_FLAG,

vsdl.INVOICED_FLAG SRC_LINE_INVOICED_FLAG,

vsdl.FULFILLED_FLAG SRC_LINE_FULFILLED_FLAG,

vsdl.CANCELLED_FLAG SRC_LINE_CANCELLED_FLAG,

vsdl.DELIVERY_STATUS SRC_LINE_DELIVERY_STATUS,

vsdl.COMMENTS SRC_LINE_COMMENTS,

vsdl.MEMO_LINE_SEQ_ID SRC_LINE_MEMO_LINE_SEQ_ID,

vsdl.PAYMENT_AMOUNT SRC_LINE_PAYMENT_AMOUNT,

vsdl.QUANTITY_CANCELLED SRC_LINE_QUANTITY_CANCELLED,

vsdl.QUANTITY_SHIPPED SRC_LINE_QUANTITY_SHIPPED,

vsdl.QUANTITY_ORDERED SRC_LINE_QUANTITY_ORDERED,

vsdl.QUANTITY_FULFILLED SRC_LINE_QUANTITY_FULFILLED,

vsdl.QUANTITY_INVOICED SRC_LINE_QUANTITY_INVOICED,

vsdl.PROJECT_ID SRC_LINE_PROJECT_ID,

vsdl.TASK_ID SRC_LINE_TASK_ID,

vsdl.RULE_START_DATE SRC_LINE_RULE_START_DATE,

vsdl.RULE_END_DATE SRC_LINE_RULE_END_DATE,

vsdl.ACTUAL_SHIPMENT_DATE SRC_LINE_ACTUAL_SHIPMENT_DATE,

vsdl.ACTUAL_ARRIVAL_DATE SRC_LINE_ACTUAL_ARRIVAL_DATE,

vsdl.FOB_POINT_CODE SRC_LINE_FOB_POINT_CODE,

vsdl.FRIEGHT_TERMS_CODE SRC_LINE_FRIT_TERMS_CODE,

vsdl.SCHEDULED_STATUS_CODE SRC_LINE_SCHED_STATUS_CODE,

vsdl.SOURCE_TYPE_CODE SRC_LINE_SOURCE_TYPE_CODE,

vsdl.SHIPPING_INTERFACED_FLAG SRC_LINE_SHIP_INTFLAG,

vsdl.CREDIT_INVOICE_LINE_ID SRC_LINE_CR_INVOICE_LINE_ID,

vsdl.REFERENCE_CUSTOMER_TRX_LINE_ID SRC_LINE_REF_CUST_TRX_LINE_ID,

vsdl.SHIPPABLE_FLAG SRC_LINE_SHIPPABLE_FLAG,

vsdl.FULFILLMENT_DATE SRC_LINE_FULMT_DATE,

vsdl.ACTUAL_FULFILLMENT_DATE SRC_LINE_ACTUAL_FULMT_DATE,

vsdl.CONTINGENCY_ID SRC_LINE_CONTINGENCY_ID,

vsdl.REVREC_EVENT_CODE SRC_LINE_REVREC_EVENT_CODE,

vsdl.REVREC_EXPIRATION_DAYS SRC_LINE_REVREC_EXPIRE_DAYS,

vsdl.ACCEPTED_QUANTITY SRC_LINE_ACCEPTED_QUANTITY,

vsdl.ACCEPTED_BY SRC_LINE_ACCEPTED_BY,

vsdl.REVREC_COMMENTS SRC_LINE_REVREC_COMMENTS,

vsdl.REVREC_REFERENCE_DOCUMENT SRC_LINE_REVREC_REF_DOC,

vsdl.REVREC_SIGNATURE SRC_LINE_REVREC_SIGNATURE,

vsdl.REVREC_SIGNATURE_DATE SRC_LINE_REVREC_SIGNATURE_DATE,

vsdl.REVREC_IMPLICIT_FLAG SRC_LINE_REVREC_IMPLICIT_FLAG,

l.LINE_NUMBER,

l.EVENT_ID

FROM VRM_SOURCE_DOC_LINES vsdl,

vrm_xla_lines_extract_gt l

WHERE l.SOURCE_DOCUMENT_LINE_ID = vsdl.DOCUMENT_LINE_ID

AND l.level_flag = 'L'