[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 |