VIEW: APPS.OKS_VRM_SALESCREDIT_V

Source

View Text - Preformatted

SELECT SCV.CHR_ID CONTRACT_ID, SUBLIN.ID CONTRACT_SUBLINE_ID, 1 BILLING_ID, SCV.ID SALESCREDIT_LINE_ID, 'SALESCREDITS' DOC_SUB_LINE_TYPE, 'L' DOC_SUB_LINE_LEVEL, OKCLIN.LINE_NUMBER, CHRB.AUTHORING_ORG_ID ORG_ID, SCV.CREATION_DATE, SCV.LAST_UPDATE_DATE, SCV.SALES_GROUP_ID, SCV.CTC_ID SALESREP_ID, OKCLIN.PRICE_NEGOTIATED LINE_AMOUNT, SCV.PERCENT REVENUE_PERCENT_SPLIT FROM OKS_K_sales_credits_V SCV, OKC_K_LINES_B OKCLIN, OKC_K_LINES_B SUBLIN, OKC_K_HEADERS_ALL_B CHRB WHERE SCV.CLE_ID = OKCLIN.ID AND SCV.CHR_ID = CHRB.ID AND OKCLIN.ID = SUBLIN.CLE_ID AND SUBLIN.LSE_ID IN (7, 8, 9, 10, 11, 18, 25, 35) AND OKCLIN.LSE_ID IN (1, 14, 19) UNION ALL SELECT SCV.CHR_ID CONTRACT_ID, SUBLIN.ID CONTRACT_SUBLINE_ID, bsl.id billing_id, SCV.ID SALESCREDIT_LINE_ID, 'SALESCREDITS' DOC_SUB_LINE_TYPE, 'L' DOC_SUB_LINE_LEVEL, OKCLIN.LINE_NUMBER, CHRB.AUTHORING_ORG_ID ORG_ID, SCV.CREATION_DATE, SCV.LAST_UPDATE_DATE, SCV.SALES_GROUP_ID, SCV.CTC_ID SALESREP_ID, bcl.amount LINE_AMOUNT, SCV.PERCENT REVENUE_PERCENT_SPLIT FROM OKS_K_sales_credits_V SCV, OKC_K_LINES_B OKCLIN, OKC_K_LINES_B SUBLIN, OKC_K_HEADERS_ALL_B CHRB , oks_bill_cont_lines bcl, OKS_BILL_SUB_LINES BSL WHERE SCV.CLE_ID = OKCLIN.ID AND SCV.CHR_ID = CHRB.ID AND OKCLIN.ID = SUBLIN.CLE_ID AND SUBLIN.LSE_ID IN (13,66) AND OKCLIN.LSE_ID IN (12) AND bsl.cle_id = sublin.id AND bcl.cle_id = okclin.id AND bsl.bcl_id = bcl.id UNION ALL SELECT SCV.CHR_ID CONTRACT_ID, OKCLIN.ID CONTRACT_SUBLINE_ID, 1 billing_id, SCV.ID SALESCREDIT_LINE_ID, 'SALESCREDITS' DOC_SUB_LINE_TYPE, 'L' DOC_SUB_LINE_LEVEL, OKCLIN.LINE_NUMBER, CHRB.AUTHORING_ORG_ID ORG_ID, SCV.CREATION_DATE, SCV.LAST_UPDATE_DATE, SCV.SALES_GROUP_ID, SCV.CTC_ID SALESREP_ID, OKCLIN.PRICE_NEGOTIATED LINE_AMOUNT, SCV.PERCENT REVENUE_PERCENT_SPLIT FROM OKC_K_HEADERS_ALL_B CHRB,OKC_K_LINES_B OKCLIN,OKS_K_SALES_CREDITS_V SCV WHERE SCV.CLE_ID = OKCLIN.ID AND SCV.CHR_ID = CHRB.ID AND OKCLIN.dnz_chr_ID = CHRB.ID AND OKCLIN.LSE_ID =46

View Text - HTML Formatted

SELECT SCV.CHR_ID CONTRACT_ID
, SUBLIN.ID CONTRACT_SUBLINE_ID
, 1 BILLING_ID
, SCV.ID SALESCREDIT_LINE_ID
, 'SALESCREDITS' DOC_SUB_LINE_TYPE
, 'L' DOC_SUB_LINE_LEVEL
, OKCLIN.LINE_NUMBER
, CHRB.AUTHORING_ORG_ID ORG_ID
, SCV.CREATION_DATE
, SCV.LAST_UPDATE_DATE
, SCV.SALES_GROUP_ID
, SCV.CTC_ID SALESREP_ID
, OKCLIN.PRICE_NEGOTIATED LINE_AMOUNT
, SCV.PERCENT REVENUE_PERCENT_SPLIT
FROM OKS_K_SALES_CREDITS_V SCV
, OKC_K_LINES_B OKCLIN
, OKC_K_LINES_B SUBLIN
, OKC_K_HEADERS_ALL_B CHRB
WHERE SCV.CLE_ID = OKCLIN.ID
AND SCV.CHR_ID = CHRB.ID
AND OKCLIN.ID = SUBLIN.CLE_ID
AND SUBLIN.LSE_ID IN (7
, 8
, 9
, 10
, 11
, 18
, 25
, 35)
AND OKCLIN.LSE_ID IN (1
, 14
, 19) UNION ALL SELECT SCV.CHR_ID CONTRACT_ID
, SUBLIN.ID CONTRACT_SUBLINE_ID
, BSL.ID BILLING_ID
, SCV.ID SALESCREDIT_LINE_ID
, 'SALESCREDITS' DOC_SUB_LINE_TYPE
, 'L' DOC_SUB_LINE_LEVEL
, OKCLIN.LINE_NUMBER
, CHRB.AUTHORING_ORG_ID ORG_ID
, SCV.CREATION_DATE
, SCV.LAST_UPDATE_DATE
, SCV.SALES_GROUP_ID
, SCV.CTC_ID SALESREP_ID
, BCL.AMOUNT LINE_AMOUNT
, SCV.PERCENT REVENUE_PERCENT_SPLIT
FROM OKS_K_SALES_CREDITS_V SCV
, OKC_K_LINES_B OKCLIN
, OKC_K_LINES_B SUBLIN
, OKC_K_HEADERS_ALL_B CHRB
, OKS_BILL_CONT_LINES BCL
, OKS_BILL_SUB_LINES BSL
WHERE SCV.CLE_ID = OKCLIN.ID
AND SCV.CHR_ID = CHRB.ID
AND OKCLIN.ID = SUBLIN.CLE_ID
AND SUBLIN.LSE_ID IN (13
, 66)
AND OKCLIN.LSE_ID IN (12)
AND BSL.CLE_ID = SUBLIN.ID
AND BCL.CLE_ID = OKCLIN.ID
AND BSL.BCL_ID = BCL.ID UNION ALL SELECT SCV.CHR_ID CONTRACT_ID
, OKCLIN.ID CONTRACT_SUBLINE_ID
, 1 BILLING_ID
, SCV.ID SALESCREDIT_LINE_ID
, 'SALESCREDITS' DOC_SUB_LINE_TYPE
, 'L' DOC_SUB_LINE_LEVEL
, OKCLIN.LINE_NUMBER
, CHRB.AUTHORING_ORG_ID ORG_ID
, SCV.CREATION_DATE
, SCV.LAST_UPDATE_DATE
, SCV.SALES_GROUP_ID
, SCV.CTC_ID SALESREP_ID
, OKCLIN.PRICE_NEGOTIATED LINE_AMOUNT
, SCV.PERCENT REVENUE_PERCENT_SPLIT
FROM OKC_K_HEADERS_ALL_B CHRB
, OKC_K_LINES_B OKCLIN
, OKS_K_SALES_CREDITS_V SCV
WHERE SCV.CLE_ID = OKCLIN.ID
AND SCV.CHR_ID = CHRB.ID
AND OKCLIN.DNZ_CHR_ID = CHRB.ID
AND OKCLIN.LSE_ID =46