FND Design Data [Home] [Help]

View: OKS_BILLPRST_SRVSUBLINE_V

Product: OKS - Service Contracts
Description:
Implementation/DBA Data: ViewAPPS.OKS_BILLPRST_SRVSUBLINE_V
View Text

SELECT STYLE.NAME NAME
, SX.NAME DESCRIPTION
, LINE.COGNOMEN LINE_REFERENCE
, LINE.START_DATE START_DATE
, LINE.END_DATE END_DATE
, LINE.PRICE_NEGOTIATED EXTENDED_PRICE
, RLINE.INVOICE_TEXT INVOICE_TEXT
, LINE.DNZ_CHR_ID DNZ_CHR_ID
, LINE.ID ID
, BSL.DATE_BILLED_FROM DATE_BILLED_FROM
, BSL.DATE_BILLED_TO DATE_BILLED_TO
, BSL.AMOUNT AMOUNT_BILLED
, LINE.CLE_ID CLE_ID
, BSL.BCL_ID BCL_ID
, HDR.CURRENCY_CODE CURRENCY_CODE
, BSL.ID BSL_ID
, HDR.CONTRACT_NUMBER||' '||CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER
, TXN.BILL_INSTANCE_NUMBER BILL_INSTANCE_NUMBER
FROM OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, OKX_SYSTEMS_V SX
, OKC_K_ITEMS ITM
, OKC_K_HEADERS_B HDR
, OKC_K_LINES_V LINE
, OKC_LINE_STYLES_V STYLE
, OKS_K_LINES_V RLINE
WHERE LINE.LSE_ID = 11
AND STYLE.ID = LINE.LSE_ID
AND HDR.ID = LINE.DNZ_CHR_ID
AND ITM.CLE_ID = LINE.ID
AND HDR.AUTHORING_ORG_ID = SX.ORG_ID
AND SX.ID1 = ITM.OBJECT1_ID1
AND BSL.CLE_ID = LINE.ID
AND RLINE.CLE_ID = LINE.ID
AND NVL(TXN.BSL_ID
, -999) = DECODE(TXN.BSL_ID
, NULL
, -999
, BSL.ID)
AND TXN.BCL_ID = BSL.BCL_ID UNION ALL SELECT STYLE.NAME NAME
, SX.NAME DESCRIPTION
, LINE.COGNOMEN LINE_REFERENCE
, LINE.START_DATE START_DATE
, LINE.END_DATE END_DATE
, LINE.PRICE_NEGOTIATED EXTENDED_PRICE
, RLINE.INVOICE_TEXT INVOICE_TEXT
, LINE.DNZ_CHR_ID DNZ_CHR_ID
, LINE.ID ID
, BSL.DATE_BILLED_FROM DATE_BILLED_FROM
, BSL.DATE_BILLED_TO DATE_BILLED_TO
, BSL.AMOUNT AMOUNT_BILLED
, LINE.CLE_ID CLE_ID
, BSL.BCL_ID BCL_ID
, HDR.CURRENCY_CODE CURRENCY_CODE
, BSL.ID BSL_ID
, HDR.CONTRACT_NUMBER||' '||CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER
, TXN.BILL_INSTANCE_NUMBER BILL_INSTANCE_NUMBER
FROM OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, OKX_CUST_SITE_USES_V SX
, OKC_K_ITEMS ITM
, OKC_K_HEADERS_B HDR
, OKC_K_LINES_V LINE
, OKC_LINE_STYLES_V STYLE
, OKS_K_LINES_V RLINE
WHERE LINE.LSE_ID = 10
AND STYLE.ID = LINE.LSE_ID
AND HDR.ID = LINE.DNZ_CHR_ID
AND ITM.CLE_ID = LINE.ID
AND HDR.AUTHORING_ORG_ID = SX.ORG_ID
AND SX.ID1 = ITM.OBJECT1_ID1
AND BSL.CLE_ID = LINE.ID
AND RLINE.CLE_ID = LINE.ID
AND NVL(TXN.BSL_ID
, -999) = DECODE(TXN.BSL_ID
, NULL
, -999
, BSL.ID)
AND TXN.BCL_ID = BSL.BCL_ID UNION ALL SELECT STYLE.NAME NAME
, SX.NAME DESCRIPTION
, LINE.COGNOMEN LINE_REFERENCE
, LINE.START_DATE START_DATE
, LINE.END_DATE END_DATE
, LINE.PRICE_NEGOTIATED EXTENDED_PRICE
, RLINE.INVOICE_TEXT INVOICE_TEXT
, LINE.DNZ_CHR_ID DNZ_CHR_ID
, LINE.ID ID
, BSL.DATE_BILLED_FROM DATE_BILLED_FROM
, BSL.DATE_BILLED_TO DATE_BILLED_TO
, BSL.AMOUNT AMOUNT_BILLED
, LINE.CLE_ID CLE_ID
, BSL.BCL_ID BCL_ID
, HDR.CURRENCY_CODE CURRENCY_CODE
, BSL.ID BSL_ID
, HDR.CONTRACT_NUMBER||' '||CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER
, TXN.BILL_INSTANCE_NUMBER BILL_INSTANCE_NUMBER
FROM OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, OKX_PARTIES_V SX
, OKC_K_ITEMS ITM
, OKC_K_HEADERS_B HDR
, OKC_K_LINES_V LINE
, OKC_LINE_STYLES_V STYLE
, OKS_K_LINES_V RLINE
WHERE LINE.LSE_ID = 8
AND HDR.ID = LINE.DNZ_CHR_ID
AND ITM.CLE_ID = LINE.ID
AND SX.ID1 = ITM.OBJECT1_ID1
AND BSL.CLE_ID = LINE.ID
AND RLINE.CLE_ID = LINE.ID
AND STYLE.ID = LINE.LSE_ID
AND NVL(TXN.BSL_ID
, -999) = DECODE(TXN.BSL_ID
, NULL
, -999
, BSL.ID)
AND TXN.BCL_ID = BSL.BCL_ID UNION ALL SELECT STYLE.NAME NAME
, SX.NAME DESCRIPTION
, LINE.COGNOMEN LINE_REFERENCE
, LINE.START_DATE START_DATE
, LINE.END_DATE END_DATE
, LINE.PRICE_NEGOTIATED EXTENDED_PRICE
, RLINE.INVOICE_TEXT INVOICE_TEXT
, LINE.DNZ_CHR_ID DNZ_CHR_ID
, LINE.ID ID
, BSL.DATE_BILLED_FROM DATE_BILLED_FROM
, BSL.DATE_BILLED_TO DATE_BILLED_TO
, BSL.AMOUNT AMOUNT_BILLED
, LINE.CLE_ID CLE_ID
, BSL.BCL_ID BCL_ID
, HDR.CURRENCY_CODE CURRENCY_CODE
, BSL.ID BSL_ID
, HDR.CONTRACT_NUMBER||' '||CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER
, TXN.BILL_INSTANCE_NUMBER BILL_INSTANCE_NUMBER
FROM OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, OKX_SYSTEM_ITEMS_V SX
, OKC_K_ITEMS ITM
, OKC_K_HEADERS_B HDR
, OKC_K_LINES_V LINE
, OKC_LINE_STYLES_V STYLE
, OKS_K_LINES_V RLINE
WHERE LINE.LSE_ID = 7
AND HDR.ID = LINE.DNZ_CHR_ID
AND ITM.CLE_ID = LINE.ID
AND SX.ID1 = ITM.OBJECT1_ID1
AND SX.ID2 = ITM.OBJECT1_ID2
AND BSL.CLE_ID = LINE.ID
AND RLINE.CLE_ID = LINE.ID
AND STYLE.ID = LINE.LSE_ID
AND NVL(TXN.BSL_ID
, -999) = DECODE(TXN.BSL_ID
, NULL
, -999
, BSL.ID)
AND TXN.BCL_ID = BSL.BCL_ID UNION ALL SELECT STYLE.NAME NAME
, SX.NAME DESCRIPTION
, LINE.COGNOMEN LINE_REFERENCE
, LINE.START_DATE START_DATE
, LINE.END_DATE END_DATE
, LINE.PRICE_NEGOTIATED EXTENDED_PRICE
, RLINE.INVOICE_TEXT INVOICE_TEXT
, LINE.DNZ_CHR_ID DNZ_CHR_ID
, LINE.ID ID
, BSL.DATE_BILLED_FROM DATE_BILLED_FROM
, BSL.DATE_BILLED_TO DATE_BILLED_TO
, BSL.AMOUNT AMOUNT_BILLED
, LINE.CLE_ID CLE_ID
, BSL.BCL_ID BCL_ID
, HDR.CURRENCY_CODE CURRENCY_CODE
, BSL.ID BSL_ID
, HDR.CONTRACT_NUMBER||' '||CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER
, TXN.BILL_INSTANCE_NUMBER BILL_INSTANCE_NUMBER
FROM OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, OKX_CUSTOMER_ACCOUNTS_V SX
, OKC_K_ITEMS ITM
, OKS_K_LINES_V RLINE
, OKC_K_LINES_V LINE
, OKC_K_HEADERS_B HDR
, OKC_LINE_STYLES_V STYLE
WHERE LINE.LSE_ID = 35
AND STYLE.ID = LINE.LSE_ID
AND ITM.CLE_ID = LINE.ID
AND HDR.ID = LINE.DNZ_CHR_ID
AND SX.ID1 = ITM.OBJECT1_ID1
AND BSL.CLE_ID = LINE.ID
AND RLINE.CLE_ID = LINE.ID
AND NVL(TXN.BSL_ID
, -999) = DECODE(TXN.BSL_ID
, NULL
, -999
, BSL.ID)
AND TXN.BCL_ID = BSL.BCL_ID UNION ALL SELECT STYLE.NAME NAME
, SX.NAME DESCRIPTION
, LINE.COGNOMEN LINE_REFERENCE
, LINE.START_DATE START_DATE
, LINE.END_DATE END_DATE
, LINE.PRICE_NEGOTIATED EXTENDED_PRICE
, RLINE.INVOICE_TEXT INVOICE_TEXT
, LINE.DNZ_CHR_ID DNZ_CHR_ID
, LINE.ID ID
, BSL.DATE_BILLED_FROM DATE_BILLED_FROM
, BSL.DATE_BILLED_TO DATE_BILLED_TO
, BSL.AMOUNT AMOUNT_BILLED
, LINE.CLE_ID CLE_ID
, BSL.BCL_ID BCL_ID
, HDR.CURRENCY_CODE CURRENCY_CODE
, BSL.ID BSL_ID
, HDR.CONTRACT_NUMBER||' '||CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER
, TXN.BILL_INSTANCE_NUMBER BILL_INSTANCE_NUMBER
FROM OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, CS_CUSTOMER_PRODUCTS CP
, OKX_SYSTEM_ITEMS_V SX
, OKC_K_ITEMS ITM
, OKC_K_HEADERS_B HDR
, OKS_K_LINES_V RLINE
, OKC_K_LINES_V LINE
, OKC_LINE_STYLES_V STYLE
WHERE LINE.LSE_ID = 9
AND STYLE.ID = LINE.LSE_ID
AND ITM.CLE_ID = LINE.ID
AND HDR.ID = LINE.DNZ_CHR_ID
AND ITM.CLE_ID = LINE.ID
AND HDR.INV_ORGANIZATION_ID = SX.ID2
AND SX.ID1 = CP.INVENTORY_ITEM_ID
AND CP.CUSTOMER_PRODUCT_ID = ITM.OBJECT1_ID1
AND BSL.CLE_ID = LINE.ID
AND RLINE.CLE_ID = LINE.ID
AND NVL(TXN.BSL_ID
, -999) = DECODE(TXN.BSL_ID
, NULL
, -999
, BSL.ID)
AND TXN.BCL_ID = BSL.BCL_ID UNION ALL SELECT STYLE.NAME NAME
, SX.NAME DESCRIPTION
, LINE.COGNOMEN LINE_REFERENCE
, LINE.START_DATE START_DATE
, LINE.END_DATE END_DATE
, LINE.PRICE_NEGOTIATED EXTENDED_PRICE
, RLINE.INVOICE_TEXT INVOICE_TEXT
, LINE.DNZ_CHR_ID DNZ_CHR_ID
, LINE.ID ID
, BSL.DATE_BILLED_FROM DATE_BILLED_FROM
, BSL.DATE_BILLED_TO DATE_BILLED_TO
, BSL.AMOUNT AMOUNT_BILLED
, LINE.CLE_ID CLE_ID
, BSL.BCL_ID BCL_ID
, HDR.CURRENCY_CODE CURRENCY_CODE
, BSL.ID BSL_ID
, HDR.CONTRACT_NUMBER||' '||CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER
, TXN.BILL_INSTANCE_NUMBER BILL_INSTANCE_NUMBER
FROM OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, CS_CUSTOMER_PRODUCTS CP
, OKX_SYSTEM_ITEMS_V SX
, OKC_K_ITEMS ITM
, OKC_K_HEADERS_B HDR
, OKS_K_LINES_V RLINE
, OKC_K_LINES_V LINE
, OKC_LINE_STYLES_V STYLE
WHERE LINE.LSE_ID = 25
AND STYLE.ID = LINE.LSE_ID
AND ITM.CLE_ID = LINE.ID
AND HDR.ID = LINE.DNZ_CHR_ID
AND ITM.CLE_ID = LINE.ID
AND HDR.INV_ORGANIZATION_ID = SX.ID2
AND SX.ID1 = CP.INVENTORY_ITEM_ID
AND CP.CUSTOMER_PRODUCT_ID = ITM.OBJECT1_ID1
AND BSL.CLE_ID = LINE.ID
AND RLINE.CLE_ID = LINE.ID
AND NVL(TXN.BSL_ID
, -999) = DECODE(TXN.BSL_ID
, NULL
, -999
, BSL.ID)
AND TXN.BCL_ID = BSL.BCL_ID

Columns

Name
NAME
DESCRIPTION
LINE_REFERENCE
START_DATE
END_DATE
EXTENDED_PRICE
INVOICE_TEXT
DNZ_CHR_ID
ID
DATE_BILLED_FROM
DATE_BILLED_TO
AMOUNT_BILLED
CLE_ID
BCL_ID
CURRENCY_CODE
BSL_ID
CONTRACT_NUMBER
BILL_INSTANCE_NUMBER