VIEW: APPS.OKI_CLICE_DTL_V

Source

View Text - Preformatted

SELECT CLE.CLE_ID , CII.INSTANCE_ID , CLE.CONTRACT_NUMBER , CLE.CONTRACT_NUMBER_MODIFIER , CLE.COMPLETE_K_NUMBER , CLE.ORDER_NUMBER , CII.SYSTEM_ID , CII.INSTANCE_TYPE_CODE , CII.LAST_OE_PO_NUMBER , CII.LAST_OE_ORDER_LINE_ID , CLE.CURR_CODE , CLE.CURR_CODE_F , CLE.CURR_CODE_G , CLE.CURR_CODE_SG , OL.UNIT_LIST_PRICE , OL.UNIT_LIST_PRICE * CLE.TRX_FUNC_CURR_RATE UNIT_LIST_PRICE_F , OL.UNIT_LIST_PRICE * CLE.TRX_FUNC_CURR_RATE * CLE.FUNC_GLOBAL_CURR_RATE UNIT_LIST_PRICE_G , OL.UNIT_LIST_PRICE * CLE.TRX_FUNC_CURR_RATE * CLE.FUNC_SGLOBAL_CURR_RATE UNIT_LIST_PRICE_SG , OL.UNIT_SELLING_PRICE , OL.UNIT_SELLING_PRICE * CLE.TRX_FUNC_CURR_RATE UNIT_SELLING_PRICE_F , OL.UNIT_SELLING_PRICE * CLE.TRX_FUNC_CURR_RATE * CLE.FUNC_GLOBAL_CURR_RATE UNIT_SELLING_PRICE_G , OL.UNIT_SELLING_PRICE * CLE.TRX_FUNC_CURR_RATE * CLE.FUNC_SGLOBAL_CURR_RATE UNIT_SELLING_PRICE_SG , OL.ORDERED_QUANTITY , OL.PRICING_QUANTITY , OL.CUST_PO_NUMBER , jtfrs.RESOURCE_ID FROM CSI_ITEM_INSTANCES CII , OE_ORDER_LINES_ALL OL , OKI_DBI_CLE_V CLE , JTF_RS_SALESREPS jtfrs WHERE OL.LINE_ID = CII.LAST_OE_ORDER_LINE_ID AND CLE.COV_PROD_ID = CII.INSTANCE_ID AND jtfrs.ORG_ID = OL.ORG_ID AND jtfrs.SALESREP_ID = OL.SALESREP_ID

View Text - HTML Formatted

SELECT CLE.CLE_ID
, CII.INSTANCE_ID
, CLE.CONTRACT_NUMBER
, CLE.CONTRACT_NUMBER_MODIFIER
, CLE.COMPLETE_K_NUMBER
, CLE.ORDER_NUMBER
, CII.SYSTEM_ID
, CII.INSTANCE_TYPE_CODE
, CII.LAST_OE_PO_NUMBER
, CII.LAST_OE_ORDER_LINE_ID
, CLE.CURR_CODE
, CLE.CURR_CODE_F
, CLE.CURR_CODE_G
, CLE.CURR_CODE_SG
, OL.UNIT_LIST_PRICE
, OL.UNIT_LIST_PRICE * CLE.TRX_FUNC_CURR_RATE UNIT_LIST_PRICE_F
, OL.UNIT_LIST_PRICE * CLE.TRX_FUNC_CURR_RATE * CLE.FUNC_GLOBAL_CURR_RATE UNIT_LIST_PRICE_G
, OL.UNIT_LIST_PRICE * CLE.TRX_FUNC_CURR_RATE * CLE.FUNC_SGLOBAL_CURR_RATE UNIT_LIST_PRICE_SG
, OL.UNIT_SELLING_PRICE
, OL.UNIT_SELLING_PRICE * CLE.TRX_FUNC_CURR_RATE UNIT_SELLING_PRICE_F
, OL.UNIT_SELLING_PRICE * CLE.TRX_FUNC_CURR_RATE * CLE.FUNC_GLOBAL_CURR_RATE UNIT_SELLING_PRICE_G
, OL.UNIT_SELLING_PRICE * CLE.TRX_FUNC_CURR_RATE * CLE.FUNC_SGLOBAL_CURR_RATE UNIT_SELLING_PRICE_SG
, OL.ORDERED_QUANTITY
, OL.PRICING_QUANTITY
, OL.CUST_PO_NUMBER
, JTFRS.RESOURCE_ID
FROM CSI_ITEM_INSTANCES CII
, OE_ORDER_LINES_ALL OL
, OKI_DBI_CLE_V CLE
, JTF_RS_SALESREPS JTFRS
WHERE OL.LINE_ID = CII.LAST_OE_ORDER_LINE_ID
AND CLE.COV_PROD_ID = CII.INSTANCE_ID
AND JTFRS.ORG_ID = OL.ORG_ID
AND JTFRS.SALESREP_ID = OL.SALESREP_ID