[Home] [Help]
| Product: | XNI - Install Base Intelligence (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT /*+ FIRST_ROWS */ A.INSTANCE_ID INSTANCE_ID
, A.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, A.CREATION_DATE CREATION_DATE
, A.OWNER_PARTY_ACCOUNT_ID OWNER_PARTY_ACCOUNT_ID
, B.LINE_ID ORDER_LINE_ID
, C.HEADER_ID ORDER_HEADER_ID
, C.ORDER_NUMBER ORDER_NUMBER
, C.TRANSACTIONAL_CURR_CODE TRANS_CUR_CODE
, C.ORG_ID ORG_ID
, D.SEGMENT1 PRODUCT_NUMBER
, D.SEGMENT2 PRODUCT_NAME
, D.DESCRIPTION DESCRIPTION
, D.ORGANIZATION_ID MTL_ORGANIZATION_ID
, ROUND((A.QUANTITY*B.UNIT_SELLING_PRICE )/11000000
, 2) AMOUNT
FROM CSI_ITEM_INSTANCES A
, OE_ORDER_LINES_ALL B
, OE_ORDER_HEADERS_ALL C
, MTL_SYSTEM_ITEMS_B D
WHERE A.INVENTORY_ITEM_ID = B.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 A.INSTANCE_STATUS_ID NOT IN (1
, 5)