[Home] [Help]
View: SO_LINE_SALES_CREDITS
View Text
SELECT LINE_ID
, 4
, SALESREP_ID
, SC.SALES_CREDIT_TYPE_ID
, SCT.QUOTA_FLAG
, SC.PERCENT
FROM SO_SALES_CREDITS SC
, SO_SALES_CREDIT_TYPES_115 SCT
WHERE SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
AND LINE_ID IS NOT NULL UNION /* LEVEL 3 = PARENT SALES CREDITS */ SELECT L1.LINE_ID
, 2
, SC.SALESREP_ID
, SC.SALES_CREDIT_TYPE_ID
, SCT.QUOTA_FLAG
, SC.PERCENT
FROM SO_SALES_CREDITS SC
, SO_SALES_CREDIT_TYPES SCT
, SO_LINES L1
WHERE SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
AND SC.LINE_ID = L1.PARENT_LINE_ID UNION /* LEVEL 1 = HEADER SALES CREDITS */ SELECT L.LINE_ID
, 1
, SC.SALESREP_ID
, SC.SALES_CREDIT_TYPE_ID
, SCT.QUOTA_FLAG
, SC.PERCENT
FROM SO_SALES_CREDITS SC
, SO_SALES_CREDIT_TYPES SCT
, SO_LINES L
, SO_HEADERS H
WHERE SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
AND SC.HEADER_ID = H.HEADER_ID
AND H.HEADER_ID = L.HEADER_ID
AND SC.LINE_ID IS NULL
Columns
Name |
LINE_ID |
LEVEL_ID |
SALESREP_ID |
SALES_CREDIT_TYPE_ID |
QUOTA_FLAG |
PERCENT |