[Home] [Help]
View: CS_CP_INCLUDED_ITEMS_V
Product: | CS - Service |
Description: | Included items of a product in the installed base |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CP.ROWID ROW_ID
, CP.ORIGINAL_LINE_SERV_DETAIL_ID
, CP.ORIGINAL_ORDER_LINE_ID
, CP.INVENTORY_ITEM_ID
, MTL.CONCATENATED_SEGMENTS PRODUCT
, MTL.DESCRIPTION PRODUCT_DESC
, CP.QUANTITY QUANTITY
, CP.UNIT_OF_MEASURE_CODE
, CP.REFERENCE_NUMBER
, CP.CURRENT_SERIAL_NUMBER SERIAL_NUMBER
, CP.LOT_NUMBER
, CP.SHIPPED_DATE
FROM MTL_SYSTEM_ITEMS_KFV MTL
, CS_CUSTOMER_PRODUCTS_ALL CP
WHERE MTL.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID
AND MTL.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID
Columns
Name |
ROW_ID |
ORIG_ORDER_LINE_DETAIL_ID |
ORIGINAL_ORDER_LINE_ID |
INVENTORY_ITEM_ID |
PRODUCT |
PRODUCT_DESC |
QUANTITY |
UNIT_OF_MEASURE_CODE |
REFERENCE_NUMBER |
SERIAL_NUMBER |
LOT_NUMBER |
SHIPPED_DATE |