VIEW: APPS.SO_LINE_SALES_CREDITS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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