RA_CUSTOMER_TRX_SUB_LINES_RM

Details

Schema: FUSION
Object owner: VRM
Object type: VIEW

Columns

Name
DOC_SUB_LINE_ID_INT_1 DOC_SUB_LINE_ID_INT_2 DOC_SUB_LINE_ID_INT_3 DOC_SUB_LINE_ID_CHAR_1 CUSTOMER_TRX_LINE_ID OKS_SUB_LINE_ID OKS_BILLING_ID CUSTOMER_TRX_ID DOC_SUB_LINE_TYPE DOC_SUB_LINE_LEVEL ORG_ID LEDGER_ID CODE_COMBINATION_ID CREATION_DATE LAST_UPDATE_DATE SALESREP_ID SALESREP_NAME REVENUE_AMOUNT_SPLIT REVENUE_PERCENT_SPLIT CONTINGENCY_NAME CONTINGENCY_ID EXPIRATION_DATE EXPIRATION_DAYS EXPIRED_FLAG EXPIRATION_EVENT_DATE EXPIRED_BY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 SATISFACTION_MEASUREMENT_DATE SATISFACTION_EVENT_QUANTITY SATISFACTION_EVENT_PERCENT

Name

DOC_SUB_LINE_ID_INT_1

DOC_SUB_LINE_ID_INT_2

DOC_SUB_LINE_ID_INT_3

DOC_SUB_LINE_ID_CHAR_1

CUSTOMER_TRX_LINE_ID

OKS_SUB_LINE_ID

OKS_BILLING_ID

CUSTOMER_TRX_ID

DOC_SUB_LINE_TYPE

DOC_SUB_LINE_LEVEL

ORG_ID

LEDGER_ID

CODE_COMBINATION_ID

CREATION_DATE

LAST_UPDATE_DATE

SALESREP_ID

SALESREP_NAME

REVENUE_AMOUNT_SPLIT

REVENUE_PERCENT_SPLIT

CONTINGENCY_NAME

CONTINGENCY_ID

EXPIRATION_DATE

EXPIRATION_DAYS

EXPIRED_FLAG

EXPIRATION_EVENT_DATE

EXPIRED_BY

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

SATISFACTION_MEASUREMENT_DATE

SATISFACTION_EVENT_QUANTITY

SATISFACTION_EVENT_PERCENT

Query

SQL_Statement
SELECT ctl.CUSTOMER_TRX_LINE_ID DOC_SUB_LINE_ID_INT_1, -99 DOC_SUB_LINE_ID_INT_2, -99 DOC_SUB_LINE_ID_INT_3, 'ORA_SATIS_EVENT_SMM_QUANTITY' DOC_SUB_LINE_ID_CHAR_1, ctl.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, -99 OKS_SUB_LINE_ID, -99 OKS_BILLING_ID, ctl.CUSTOMER_TRX_ID CUSTOMER_TRX_ID, 'ORA_SATIS_EVENT_SMM_QUANTITY' DOC_SUB_LINE_TYPE, 'L' DOC_SUB_LINE_LEVEL, ctl.ORG_ID ORG_ID, ctl.SET_OF_BOOKS_ID LEDGER_ID, NULL CODE_COMBINATION_ID, ctl.CREATION_DATE CREATION_DATE, ctl.LAST_UPDATE_DATE LAST_UPDATE_DATE, NULL SALESREP_ID, NULL SALESREP_NAME, NULL REVENUE_AMOUNT_SPLIT, NULL REVENUE_PERCENT_SPLIT, NULL CONTINGENCY_NAME, NULL CONTINGENCY_ID, NULL EXPIRATION_DATE, NULL EXPIRATION_DAYS, NULL EXPIRED_FLAG, NULL EXPIRATION_EVENT_DATE, NULL EXPIRED_BY, NULL ATTRIBUTE_CATEGORY, NULL ATTRIBUTE1, NULL ATTRIBUTE2, NULL ATTRIBUTE3, NULL ATTRIBUTE4, NULL ATTRIBUTE5, NULL ATTRIBUTE6, NULL ATTRIBUTE7, NULL ATTRIBUTE8, NULL ATTRIBUTE9, NULL ATTRIBUTE10, NULL ATTRIBUTE11, NULL ATTRIBUTE12, NULL ATTRIBUTE13, NULL ATTRIBUTE14, NULL ATTRIBUTE15, ct.trx_date SATISFACTION_MEASUREMENT_DATE, DECODE(ct.trx_class,'CM', NVL(CTL.QUANTITY_CREDITED,-1) ,'ONACC', COALESCE(CTL.QUANTITY_INVOICED,CTL.QUANTITY_CREDITED,-1) , NVL(CTL.QUANTITY_INVOICED,1) ) SATISFACTION_EVENT_QUANTITY, NULL SATISFACTION_EVENT_PERCENT FROM RA_CUSTOMER_TRX_LINES_ALL ctl, RA_CUSTOMER_TRX_ALL ct, RA_CUST_TRX_TYPES_ALL ctt, AR_MEMO_LINES_ALL_VL ml, RA_CUST_TRX_LINE_GL_DIST_ALL gld WHERE ctl.line_type = 'LINE' AND ctl.accounting_rule_id is null AND ctl.customer_trx_id = ct.customer_trx_id AND ct.complete_flag = 'Y' AND ct.cust_trx_type_seq_id = ctt.cust_trx_type_seq_id AND ct.trx_class IN ('INV','ONACC') AND ctl.memo_line_seq_id = ml.memo_line_seq_id (+) AND gld.customer_trx_id = ct.customer_trx_id AND gld.account_class = 'REC' AND gld.account_set_flag = 'N' AND gld.posting_control_id <> -3 AND gld.latest_rec_flag = 'Y'

SQL_Statement

SELECT ctl.CUSTOMER_TRX_LINE_ID DOC_SUB_LINE_ID_INT_1,

-99 DOC_SUB_LINE_ID_INT_2,

-99 DOC_SUB_LINE_ID_INT_3,

'ORA_SATIS_EVENT_SMM_QUANTITY' DOC_SUB_LINE_ID_CHAR_1,

ctl.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID,

-99 OKS_SUB_LINE_ID,

-99 OKS_BILLING_ID,

ctl.CUSTOMER_TRX_ID CUSTOMER_TRX_ID,

'ORA_SATIS_EVENT_SMM_QUANTITY' DOC_SUB_LINE_TYPE,

'L' DOC_SUB_LINE_LEVEL,

ctl.ORG_ID ORG_ID,

ctl.SET_OF_BOOKS_ID LEDGER_ID,

NULL CODE_COMBINATION_ID,

ctl.CREATION_DATE CREATION_DATE,

ctl.LAST_UPDATE_DATE LAST_UPDATE_DATE,

NULL SALESREP_ID,

NULL SALESREP_NAME,

NULL REVENUE_AMOUNT_SPLIT,

NULL REVENUE_PERCENT_SPLIT,

NULL CONTINGENCY_NAME,

NULL CONTINGENCY_ID,

NULL EXPIRATION_DATE,

NULL EXPIRATION_DAYS,

NULL EXPIRED_FLAG,

NULL EXPIRATION_EVENT_DATE,

NULL EXPIRED_BY,

NULL ATTRIBUTE_CATEGORY,

NULL ATTRIBUTE1,

NULL ATTRIBUTE2,

NULL ATTRIBUTE3,

NULL ATTRIBUTE4,

NULL ATTRIBUTE5,

NULL ATTRIBUTE6,

NULL ATTRIBUTE7,

NULL ATTRIBUTE8,

NULL ATTRIBUTE9,

NULL ATTRIBUTE10,

NULL ATTRIBUTE11,

NULL ATTRIBUTE12,

NULL ATTRIBUTE13,

NULL ATTRIBUTE14,

NULL ATTRIBUTE15,

ct.trx_date SATISFACTION_MEASUREMENT_DATE,

DECODE(ct.trx_class,'CM', NVL(CTL.QUANTITY_CREDITED,-1) ,'ONACC', COALESCE(CTL.QUANTITY_INVOICED,CTL.QUANTITY_CREDITED,-1) , NVL(CTL.QUANTITY_INVOICED,1) ) SATISFACTION_EVENT_QUANTITY,

NULL SATISFACTION_EVENT_PERCENT

FROM RA_CUSTOMER_TRX_LINES_ALL ctl,

RA_CUSTOMER_TRX_ALL ct,

RA_CUST_TRX_TYPES_ALL ctt,

AR_MEMO_LINES_ALL_VL ml,

RA_CUST_TRX_LINE_GL_DIST_ALL gld

WHERE ctl.line_type = 'LINE'

AND ctl.accounting_rule_id is null

AND ctl.customer_trx_id = ct.customer_trx_id

AND ct.complete_flag = 'Y'

AND ct.cust_trx_type_seq_id = ctt.cust_trx_type_seq_id

AND ct.trx_class IN ('INV','ONACC')

AND ctl.memo_line_seq_id = ml.memo_line_seq_id (+)

AND gld.customer_trx_id = ct.customer_trx_id

AND gld.account_class = 'REC'

AND gld.account_set_flag = 'N'

AND gld.posting_control_id <> -3

AND gld.latest_rec_flag = 'Y'