VIEW: APPS.OKI_CSOURCE_DTL_V

Source

View Text - Preformatted

SELECT /*+ use_nl(opnb,opnt,cop,oie,oli,khdr,slin,tlin,odcb, odcb2) parallel(opnb) parallel(opnt) parallel(cop) parallel(oie) parallel(oli) parallel(khdr) parallel(slin) parallel(tlin) parallel(odcb) parallel(odcb2) */ oli.subject_cle_id target_cle_id, oli.object_cle_id source_cle_id, opnt.meaning source_operation, khdr.contract_number source_contract_number, khdr.contract_number_modifier source_contract_modifier, tlin.line_number||'.'||slin.line_number source_line_number, slin.CURRENCY_CODE source_currency_code, odcb2.CURR_CODE_F SOURCE_CURR_CODE_F, curr.CURR_CODE_G SOURCE_CURR_CODE_G, curr.CURR_CODE_SG SOURCE_CURR_CODE_SG, curr.CURR_CODE_A SOURCE_CURR_CODE_A, slin.price_negotiated source_contract_line_amt, odcb2.PRICE_NEGOTIATED_F SOURCE_PRICE_NEGOTIATED_F, odcb2.PRICE_NEGOTIATED_G SOURCE_PRICE_NEGOTIATED_G, odcb2.PRICE_NEGOTIATED_SG SOURCE_PRICE_NEGOTIATED_SG, odcb2.PRICE_NEGOTIATED_A SOURCE_PRICE_NEGOTIATED_A , odcb.CONTRACT_NUMBER TAR_CONTRACT_NUMBER, odcb.CONTRACT_NUMBER_MODIFIER TAR_CONTRACT_NUMBER_MODIFIER, odcb.CURR_CODE TAR_CURR_CODE, odcb.CURR_CODE_F TAR_CURR_CODE_F, curr.CURR_CODE_G TAR_CURR_CODE_G, curr.CURR_CODE_SG TAR_CURR_CODE_SG, curr.CURR_CODE_A TAR_CURR_CODE_A , odcb.PRICE_NEGOTIATED TAR_PRICE_NEGOTIATED, odcb.PRICE_NEGOTIATED_F TAR_PRICE_NEGOTIATED_F, odcb.PRICE_NEGOTIATED_G TAR_PRICE_NEGOTIATED_G, odcb.PRICE_NEGOTIATED_SG TAR_PRICE_NEGOTIATED_SG, odcb.PRICE_NEGOTIATED_A TAR_PRICE_NEGOTIATED_A FROM OKC_OPERATIONS_B OPNB, OKC_OPERATIONS_TL OPNT, okc_class_operations cop , okc_operation_instances oie , okc_operation_lines oli , okc_k_headers_all_b khdr , okc_k_lines_b slin , okc_operation_lines oli2 , okc_k_lines_b tlin , OKI_DBI_CLE_B odcb, ( SELECT CURR_CODE_G , CURR_CODE_SG , DECODE( BIS_COMMON_PARAMETERS.GET_ANNUALIZED_CURRENCY_CODE, 'PRIMARY', CURR_CODE_G, 'SECONDARY', CURR_CODE_SG, CURR_CODE_G ) CURR_CODE_A FROM(SELECT CAST( BIS_COMMON_PARAMETERS.GET_CURRENCY_CODE AS VARCHAR2(15)) CURR_CODE_G , CAST( BIS_COMMON_PARAMETERS.GET_SECONDARY_CURRENCY_CODE AS VARCHAR2(15)) CURR_CODE_SG FROM DUAL)) CURR , OKI_DBI_CLE_B odcb2 WHERE opnb.code = cop.opn_code and cop.cls_code = 'SERVICE' and cop.id = oie.cop_id and oie.id = oli.oie_id and oli.object_cle_id = slin.id and oli2.object_cle_id = slin.id and slin.lse_id in(7,8,9,10,11,18,25,35) and tlin.id = slin.cle_id and cop.opn_code IN ('RENEWAL', 'REN_CON', 'TRANSFER') and slin.dnz_chr_id = khdr.id and OPNB.CODE = OPNT.CODE and OPNT.LANGUAGE = USERENV('LANG') and odcb.CLE_ID = oli.subject_cle_id(+) AND odcb.application_id = 515 AND odcb.buy_or_sell = 'S' AND odcb.gsd_flag = 1 AND odcb.term_flag = 1 AND odcb.scs_code IN ('SERVICE','WARRANTY') AND odcb.root_lty_code IN ('SERVICE','WARRANTY','EXT_WARRANTY') and odcb2.CLE_ID = oli2.object_cle_id(+) AND odcb2.application_id = 515 AND odcb2.buy_or_sell = 'S' AND odcb2.gsd_flag = 1 AND odcb2.term_flag = 1 AND odcb2.scs_code IN ('SERVICE','WARRANTY') AND odcb2.root_lty_code IN ('SERVICE','WARRANTY','EXT_WARRANTY')

View Text - HTML Formatted

SELECT /*+ USE_NL(OPNB
, OPNT
, COP
, OIE
, OLI
, KHDR
, SLIN
, TLIN
, ODCB
, ODCB2) PARALLEL(OPNB) PARALLEL(OPNT) PARALLEL(COP) PARALLEL(OIE) PARALLEL(OLI) PARALLEL(KHDR) PARALLEL(SLIN) PARALLEL(TLIN) PARALLEL(ODCB) PARALLEL(ODCB2) */ OLI.SUBJECT_CLE_ID TARGET_CLE_ID
, OLI.OBJECT_CLE_ID SOURCE_CLE_ID
, OPNT.MEANING SOURCE_OPERATION
, KHDR.CONTRACT_NUMBER SOURCE_CONTRACT_NUMBER
, KHDR.CONTRACT_NUMBER_MODIFIER SOURCE_CONTRACT_MODIFIER
, TLIN.LINE_NUMBER||'.'||SLIN.LINE_NUMBER SOURCE_LINE_NUMBER
, SLIN.CURRENCY_CODE SOURCE_CURRENCY_CODE
, ODCB2.CURR_CODE_F SOURCE_CURR_CODE_F
, CURR.CURR_CODE_G SOURCE_CURR_CODE_G
, CURR.CURR_CODE_SG SOURCE_CURR_CODE_SG
, CURR.CURR_CODE_A SOURCE_CURR_CODE_A
, SLIN.PRICE_NEGOTIATED SOURCE_CONTRACT_LINE_AMT
, ODCB2.PRICE_NEGOTIATED_F SOURCE_PRICE_NEGOTIATED_F
, ODCB2.PRICE_NEGOTIATED_G SOURCE_PRICE_NEGOTIATED_G
, ODCB2.PRICE_NEGOTIATED_SG SOURCE_PRICE_NEGOTIATED_SG
, ODCB2.PRICE_NEGOTIATED_A SOURCE_PRICE_NEGOTIATED_A
, ODCB.CONTRACT_NUMBER TAR_CONTRACT_NUMBER
, ODCB.CONTRACT_NUMBER_MODIFIER TAR_CONTRACT_NUMBER_MODIFIER
, ODCB.CURR_CODE TAR_CURR_CODE
, ODCB.CURR_CODE_F TAR_CURR_CODE_F
, CURR.CURR_CODE_G TAR_CURR_CODE_G
, CURR.CURR_CODE_SG TAR_CURR_CODE_SG
, CURR.CURR_CODE_A TAR_CURR_CODE_A
, ODCB.PRICE_NEGOTIATED TAR_PRICE_NEGOTIATED
, ODCB.PRICE_NEGOTIATED_F TAR_PRICE_NEGOTIATED_F
, ODCB.PRICE_NEGOTIATED_G TAR_PRICE_NEGOTIATED_G
, ODCB.PRICE_NEGOTIATED_SG TAR_PRICE_NEGOTIATED_SG
, ODCB.PRICE_NEGOTIATED_A TAR_PRICE_NEGOTIATED_A
FROM OKC_OPERATIONS_B OPNB
, OKC_OPERATIONS_TL OPNT
, OKC_CLASS_OPERATIONS COP
, OKC_OPERATION_INSTANCES OIE
, OKC_OPERATION_LINES OLI
, OKC_K_HEADERS_ALL_B KHDR
, OKC_K_LINES_B SLIN
, OKC_OPERATION_LINES OLI2
, OKC_K_LINES_B TLIN
, OKI_DBI_CLE_B ODCB
, ( SELECT CURR_CODE_G
, CURR_CODE_SG
, DECODE( BIS_COMMON_PARAMETERS.GET_ANNUALIZED_CURRENCY_CODE
, 'PRIMARY'
, CURR_CODE_G
, 'SECONDARY'
, CURR_CODE_SG
, CURR_CODE_G ) CURR_CODE_A FROM(SELECT CAST( BIS_COMMON_PARAMETERS.GET_CURRENCY_CODE AS VARCHAR2(15)) CURR_CODE_G
, CAST( BIS_COMMON_PARAMETERS.GET_SECONDARY_CURRENCY_CODE AS VARCHAR2(15)) CURR_CODE_SG
FROM DUAL)) CURR
, OKI_DBI_CLE_B ODCB2
WHERE OPNB.CODE = COP.OPN_CODE
AND COP.CLS_CODE = 'SERVICE'
AND COP.ID = OIE.COP_ID
AND OIE.ID = OLI.OIE_ID
AND OLI.OBJECT_CLE_ID = SLIN.ID
AND OLI2.OBJECT_CLE_ID = SLIN.ID
AND SLIN.LSE_ID IN(7
, 8
, 9
, 10
, 11
, 18
, 25
, 35)
AND TLIN.ID = SLIN.CLE_ID
AND COP.OPN_CODE IN ('RENEWAL'
, 'REN_CON'
, 'TRANSFER')
AND SLIN.DNZ_CHR_ID = KHDR.ID
AND OPNB.CODE = OPNT.CODE
AND OPNT.LANGUAGE = USERENV('LANG')
AND ODCB.CLE_ID = OLI.SUBJECT_CLE_ID(+)
AND ODCB.APPLICATION_ID = 515
AND ODCB.BUY_OR_SELL = 'S'
AND ODCB.GSD_FLAG = 1
AND ODCB.TERM_FLAG = 1
AND ODCB.SCS_CODE IN ('SERVICE'
, 'WARRANTY')
AND ODCB.ROOT_LTY_CODE IN ('SERVICE'
, 'WARRANTY'
, 'EXT_WARRANTY')
AND ODCB2.CLE_ID = OLI2.OBJECT_CLE_ID(+)
AND ODCB2.APPLICATION_ID = 515
AND ODCB2.BUY_OR_SELL = 'S'
AND ODCB2.GSD_FLAG = 1
AND ODCB2.TERM_FLAG = 1
AND ODCB2.SCS_CODE IN ('SERVICE'
, 'WARRANTY')
AND ODCB2.ROOT_LTY_CODE IN ('SERVICE'
, 'WARRANTY'
, 'EXT_WARRANTY')