Product: | OKS - Service Contracts |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKS_BILLPRST_SRVSUBLINE_V |
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