Product: | XNI - Install Base Intelligence (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT /*+ FIRST_ROWS */ A.INSTANCE_ID INSTANCE_ID
, A.INSTANCE_NUMBER INSTANCE_NUMBER
, A.OWNER_PARTY_ACCOUNT_ID OWNER_PARTY_ACCOUNT_ID
, A.ACTIVE_START_DATE ACTIVE_START_DATE
, A.ACTIVE_END_DATE ACTIVE_END_DATE
, ROUND((A.QUANTITY*B.UNIT_SELLING_PRICE )/11000000
, 2) AMOUNT
, A.LAST_OE_ORDER_LINE_ID
, A.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, C.HEADER_ID ORDER_HEADER
, C.ORDER_NUMBER ORDER_NUMBER
, C.ORG_ID ORDER_ORG_ID
, C.SALESREP_ID ORDER_SALESREP_ID
, C.TRANSACTIONAL_CURR_CODE TRANS_CUR_CODE
, D.ORGANIZATION_ID MTL_ORGANIZATION_ID
, D.SEGMENT1 PRODUCT_NUMBER
, D.SEGMENT2 PRODUCT_NAME
, E.NAME SALESREP_NAME
FROM CSI_ITEM_INSTANCES A
, OE_ORDER_LINES_ALL B
, OE_ORDER_HEADERS_ALL C
, MTL_SYSTEM_ITEMS_B D
, JTF_RS_SALESREPS E
WHERE A.INVENTORY_ITEM_ID = D.INVENTORY_ITEM_ID
AND A.LAST_OE_ORDER_LINE_ID = B.LINE_ID
AND B.HEADER_ID = C.HEADER_ID
AND B.INVENTORY_ITEM_ID = D.INVENTORY_ITEM_ID
AND C.SALESREP_ID = E.SALESREP_ID (+)
AND C.ORG_ID = E.ORG_ID (+)