View: SO_LINE_SALES_CREDITS

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.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