1. Tables and Views for Financials
  2. VRM_LINES_SCHEDULES_SPLITS_V

VRM_LINES_SCHEDULES_SPLITS_V

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: VIEW

Columns

Name

ATTRIBUTE_CATEGORY

AUTORULE_COMPLETE_FLAG

CODE_COMBINATION_ID

CONTINGENCY_COUNT

DOCUMENT_LINE_ID

EXTENDED_CARVED_OUT_AMOUNT

EXTENDED_REVENUE_PRICE_AMOUNT

EXTENDED_UNIT_PRICE_AMOUNT

INVENTORY_ORG_ID

ITEM_DESCRIPTION

ITEM_ID

ITEM_NUMBER

LINE_TYPE

LINK_TO_REV_DOC_LINE_ID

MEA_NUMBER

MEMO_LINE_SEQ_ID

PREV_REVENUE_DOCUMENT_LINE_ID

PROGRAM_APPLICATION_ID

PROGRAM_ID

PROGRAM_UPDATE_DATE

QUANTITY

QUANTITY_CREDITED

QUANTITY_INVOICED

REQUIRES_MANUAL_SCHEDULING

REVENUE_DOCUMENT_LINE_ID

REVENUE_RULE_ID

REVENUE_RULE_NAME

RULE_DURATION

RULE_DURATION_PROCESSED

RULE_END_DATE

RULE_START_DATE

REV_DOC_LINE_ATTRIBUT_CATEGORY

REV_DOC_LINE_ATTRIBUTE1

REV_DOC_LINE_ATTRIBUTE2

REV_DOC_LINE_ATTRIBUTE3

REV_DOC_LINE_ATTRIBUTE4

REV_DOC_LINE_ATTRIBUTE5

REV_DOC_LINE_ATTRIBUTE6

REV_DOC_LINE_ATTRIBUTE7

REV_DOC_LINE_ATTRIBUTE8

REV_DOC_LINE_ATTRIBUTE9

REV_DOC_LINE_ATTRIBUTE10

REV_DOC_LINE_ATTRIBUTE11

REV_DOC_LINE_ATTRIBUTE12

REV_DOC_LINE_ATTRIBUTE13

REV_DOC_LINE_ATTRIBUTE14

REV_DOC_LINE_ATTRIBUTE15

SOURCE_DOCUMENT_LINE_NUMBER

UNIT_CARVE_OUT_PRICE

UNIT_REVENUE_PRICE

UNIT_SELLING_PRICE

UNSCHEDULED_AMOUNT

UOM_CODE

ACCOUNT_CLASS

ACCOUNT_SET_FLAG

ACCOUNTING_DATE

COLLECTED_TAX_CCID

COMMENTS

CONCATENATED_SEGMENTS

GL_POSTED_DATE

LATEST_REC_FLAG

ORIGINAL_ACCOUNTING_DATE

PERCENT

POST_REQUEST_ID

POSTED_TO_SLA_FLAG

POSTING_CONTROL_ID

RA_POST_LOOP_NUMBER

REC_OFFSET_FLAG

REVENUE_ADJUSTMENT_ID

REVENUE_DOC_LINE_SCHEDULE_ID

REVENUE_LINE_SPLIT_ID

ROUNDING_CORRECTION_FLAG

SCHEDULE_EVENT

SCHEDULE_LINE_NUMBER

USER_GENERATED_FLAG

AMOUNT

ACCTD_AMOUNT

OFFSET_LINE_ACCOUNT_CCID

SCHEDULED_ACCTD_AMOUNT

OFFSET_LINE_TYPE

SCHEDULED_AMOUNT

PREV_REVENUE_LINE_SPLIT_ID

SALESREP_ID

SALESREP_NAME

SPLIT_AMOUNT

SPLIT_BASIS

SPLIT_DATE

SPLIT_PERCENT

REV_CCID

LINE_NUMBER

EVENT_ID

Query

SQL_Statement

SELECT rdl.ATTRIBUTE_CATEGORY,

rdl.AUTORULE_COMPLETE_FLAG,

rds.CODE_COMBINATION_ID,

rdl.CONTINGENCY_COUNT,

rdl.DOCUMENT_LINE_ID,

rdl.EXTENDED_CARVED_OUT_AMOUNT,

rdl.EXTENDED_REVENUE_PRICE_AMOUNT,

rdl.EXTENDED_UNIT_PRICE_AMOUNT,

rdl.INVENTORY_ORG_ID,

rdl.ITEM_DESCRIPTION,

rdl.ITEM_ID,

rdl.ITEM_NUMBER,

rdl.LINE_TYPE,

rdl.LINK_TO_REV_DOC_LINE_ID,

rdl.MEA_NUMBER,

rdl.MEMO_LINE_SEQ_ID,

rdl.PREV_REVENUE_DOCUMENT_LINE_ID,

rdl.PROGRAM_APPLICATION_ID,

rdl.PROGRAM_ID,

rdl.PROGRAM_UPDATE_DATE,

rdl.QUANTITY,

rdl.QUANTITY_CREDITED,

rdl.QUANTITY_INVOICED,

rdl.REQUIRES_MANUAL_SCHEDULING,

rds.REVENUE_DOCUMENT_LINE_ID,

rdl.REVENUE_RULE_ID,

rdl.REVENUE_RULE_NAME,

rdl.RULE_DURATION,

rdl.RULE_DURATION_PROCESSED,

rdl.RULE_END_DATE,

rdl.RULE_START_DATE,

rdl.ATTRIBUTE_CATEGORY REV_DOC_LINE_ATTRIBUT_CATEGORY,

rdl.ATTRIBUTE1 REV_DOC_LINE_ATTRIBUTE1,

rdl.ATTRIBUTE2 REV_DOC_LINE_ATTRIBUTE2,

rdl.ATTRIBUTE3 REV_DOC_LINE_ATTRIBUTE3,

rdl.ATTRIBUTE4 REV_DOC_LINE_ATTRIBUTE4,

rdl.ATTRIBUTE5 REV_DOC_LINE_ATTRIBUTE5,

rdl.ATTRIBUTE6 REV_DOC_LINE_ATTRIBUTE6,

rdl.ATTRIBUTE7 REV_DOC_LINE_ATTRIBUTE7,

rdl.ATTRIBUTE8 REV_DOC_LINE_ATTRIBUTE8,

rdl.ATTRIBUTE9 REV_DOC_LINE_ATTRIBUTE9,

rdl.ATTRIBUTE10 REV_DOC_LINE_ATTRIBUTE10,

rdl.ATTRIBUTE11 REV_DOC_LINE_ATTRIBUTE11,

rdl.ATTRIBUTE12 REV_DOC_LINE_ATTRIBUTE12,

rdl.ATTRIBUTE13 REV_DOC_LINE_ATTRIBUTE13,

rdl.ATTRIBUTE14 REV_DOC_LINE_ATTRIBUTE14,

rdl.ATTRIBUTE15 REV_DOC_LINE_ATTRIBUTE15,

rdl.SOURCE_DOCUMENT_LINE_NUMBER,

rdl.UNIT_CARVE_OUT_PRICE,

rdl.UNIT_REVENUE_PRICE,

rdl.UNIT_SELLING_PRICE,

rds.UNSCHEDULED_AMOUNT,

rdl.UOM_CODE,

rds.ACCOUNT_CLASS,

rds.ACCOUNT_SET_FLAG,

rds.ACCOUNTING_DATE,

rds.COLLECTED_TAX_CCID,

rds.COMMENTS,

rds.CONCATENATED_SEGMENTS,

rds.GL_POSTED_DATE,

rds.LATEST_REC_FLAG,

rds.ORIGINAL_ACCOUNTING_DATE,

rds.PERCENT,

rds.POST_REQUEST_ID,

rds.POSTED_TO_SLA_FLAG,

rds.POSTING_CONTROL_ID,

rds.RA_POST_LOOP_NUMBER,

rds.REC_OFFSET_FLAG,

rds.REVENUE_ADJUSTMENT_ID,

rds.REVENUE_DOC_LINE_SCHEDULE_ID,

rds.REVENUE_LINE_SPLIT_ID,

rds.ROUNDING_CORRECTION_FLAG,

rds.SCHEDULE_EVENT,

rds.SCHEDULE_LINE_NUMBER,

rds.USER_GENERATED_FLAG,

rds.AMOUNT,

rds.ACCTD_AMOUNT,

rds.OFFSET_LINE_ACCOUNT_CCID,

rds.SCHEDULED_ACCTD_AMOUNT,

rds.OFFSET_LINE_TYPE,

rds.SCHEDULED_AMOUNT,

rdspt.PREV_REVENUE_LINE_SPLIT_ID,

rdspt.SALESREP_ID,

rdspt.SALESREP_NAME,

rdspt.SPLIT_AMOUNT,

rdspt.SPLIT_BASIS,

rdspt.SPLIT_DATE,

rdspt.SPLIT_PERCENT,

refacc.REV_CCID,

l.LINE_NUMBER,

l.EVENT_ID

FROM VRM_REVENUE_DOC_LINES_ALL rdl,

VRM_REV_DOC_LINE_SCHEDULES_ALL rds,

VRM_REV_DOC_LINE_SPLITS_ALL rdspt,

vrm_xla_lines_extract_gt l,

AR_REF_ACCOUNTS_ALL refacc,

VRM_SOURCE_DOC_LINES vsdl

WHERE rdl.REVENUE_DOCUMENT_LINE_ID = rds.REVENUE_DOCUMENT_LINE_ID

AND rds.REVENUE_DOC_LINE_SCHEDULE_ID = l.REVENUE_DOC_LINE_SCHEDULE_ID

AND rds.REVENUE_LINE_SPLIT_ID = rdspt.REVENUE_LINE_SPLIT_ID (+)

AND rds.EVENT_ID = l.EVENT_ID

AND rdl.DOCUMENT_LINE_ID = vsdl.DOCUMENT_LINE_ID

AND refacc.source_ref_account_id (+) = vsdl.memo_line_id

AND refacc.SOURCE_REF_TABLE (+) = 'AR_MEMO_LINES_ALL_B'

AND NVL(refacc.bu_id,l.org_id) = l.org_id

AND l.level_flag = 'L'