eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CSD.CSD_PRODUCT_TRANSACTIONS

Object Details

Object Name:	CSD_PRODUCT_TRANSACTIONS
Object Type:	TABLE
Owner:	CSD
FND Design Data:	CSD.CSD_PRODUCT_TRANSACTIONS
Subobject Name:
Status:	VALID

This enitty is the child table for CSD_REPAIRS and holds all the product (Inbound / Outbound) transactions for a Repair Order.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSD_PRODUCT_TRANSACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRODUCT_TRANSACTION_ID
CSD_PRODUCT_TRANSACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPAIR_LINE_ID ACTION_TYPE
CSD_PRODUCT_TRANSACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ESTIMATE_DETAIL_ID
CSD_PRODUCT_TRANSACTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_HEADER_ID ORDER_LINE_ID
CSD_PRODUCT_TRANSACTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQ_HEADER_ID REQ_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PRODUCT_TRANSACTION_ID	NUMBER	(15)	Yes	Unique identifier for the table
REPAIR_LINE_ID	NUMBER	(15)	Yes	Unique repair order identifier. Foreign key to CSD_REPAIRS.
ESTIMATE_DETAIL_ID	NUMBER			Foreign key to the CS_ESTIMATE_DETAILS(Charge lines) table.
ACTION_TYPE	VARCHAR2	(30)		Describes the type of action - RMA , SHIP etc. Values form the FND lookup CSD_PROD_ACTION_TYPE.
ACTION_CODE	VARCHAR2	(30)		Categorization of the Product transaction - Customer Product , Loaner etc. Values from user extensible FND lookup CSD_PRODUCT_ACTION_CODE.
INTERFACE_TO_OM_FLAG	VARCHAR2	(1)		Flag to indicate whether to interface the charge line to OM or not.
BOOK_SALES_ORDER_FLAG	VARCHAR2	(1)		Flag to determine whether to Book the Sales Order created earlier.
RELEASE_SALES_ORDER_FLAG	VARCHAR2	(1)		Flag to determine whether to Pick Release the Sales Order booked earlier.
SHIP_SALES_ORDER_FLAG	VARCHAR2	(1)		Flag to determine whether to Ship Confirm the Sales Order released earlier.
SUB_INVENTORY	VARCHAR2	(30)		Sub Inventory Code. For Installed Base/ Shipment purposes.
LOT_NUMBER	VARCHAR2	(80)		Lot Number for Installed Base purposes.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CONTEXT	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number used for database locking control
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
PROD_TXN_STATUS	VARCHAR2	(30)		Status for the product transaction lifecycle. Valid values are from FND lookup CSD_PRODUCT_TXN_STATUS.
PROD_TXN_CODE	VARCHAR2	(30)		Determines whether it will have pre or post repair logistics. Values could be either PRE or POST.
SHIPPED_SERIAL_NUMBER	VARCHAR2	(30)		Serial number of the shipped item : Not used in 11.5.10
SOURCE_SERIAL_NUMBER	VARCHAR2	(30)		Serial number of item instance that user is currently transacting.
NON_SOURCE_SERIAL_NUMBER	VARCHAR2	(30)		Serial number of item instance that user wants to build relation ship with current item instance that is being transacted.
SOURCE_INSTANCE_ID	NUMBER			IB Refl number of item instance that user is currently transacting. This column will have value only if item is IB Trackable.
NON_SOURCE_INSTANCE_ID	NUMBER			IB Ref number of item instance that user wants to build relation ship with current item instance that is being transacted. This column may have value only when item is IB Trackable.
REQ_HEADER_ID	NUMBER			This column holds internal requisition header Id information.This column is used by internal ROs created from outside DWB.
REQ_LINE_ID	NUMBER			This column holds internal requisition Line Id information.This column is used by internal ROs created from outside the DWB.
ORDER_HEADER_ID	NUMBER			This column holds sales order header Id information.This column will always have a value for internal ROs.
ORDER_LINE_ID	NUMBER			This column holds sales order line Id information.This column will always have a value for internal ROs.
QUANTITY_RECEIVED	NUMBER			This column holds quantity received(part or whole) value for an RMA or internal requisition line.
QUANTITY_SHIPPED	NUMBER			This column holds quantity shipped(part or whole) value for SHIP or internal sales order line.
LOCATOR_ID	NUMBER			If item is locator controlled then locator_id will have value of item shipped or item received.
SUB_INVENTORY_RCVD	VARCHAR2	(30)		Name of sub inventory code where item is received. This column will be popupated only for internal repair orders.
LOT_NUMBER_RCVD	VARCHAR2	(80)		Lot number information for item received, this column is populated only for internal repair orders and when item is lot controlled.
PICKING_RULE_ID	NUMBER	(15)		Picking rule identifier.
PROJECT_ID	NUMBER	(15)		Project Id
TASK_ID	NUMBER	(15)		Task Id
UNIT_NUMBER	VARCHAR2	(30)		Unit Number
INTERNAL_PO_HEADER_ID	NUMBER			Internal Purchase Order Header Id

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PRODUCT_TRANSACTION_ID
,      REPAIR_LINE_ID
,      ESTIMATE_DETAIL_ID
,      ACTION_TYPE
,      ACTION_CODE
,      INTERFACE_TO_OM_FLAG
,      BOOK_SALES_ORDER_FLAG
,      RELEASE_SALES_ORDER_FLAG
,      SHIP_SALES_ORDER_FLAG
,      SUB_INVENTORY
,      LOT_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      PROD_TXN_STATUS
,      PROD_TXN_CODE
,      SHIPPED_SERIAL_NUMBER
,      SOURCE_SERIAL_NUMBER
,      NON_SOURCE_SERIAL_NUMBER
,      SOURCE_INSTANCE_ID
,      NON_SOURCE_INSTANCE_ID
,      REQ_HEADER_ID
,      REQ_LINE_ID
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      QUANTITY_RECEIVED
,      QUANTITY_SHIPPED
,      LOCATOR_ID
,      SUB_INVENTORY_RCVD
,      LOT_NUMBER_RCVD
,      PICKING_RULE_ID
,      PROJECT_ID
,      TASK_ID
,      UNIT_NUMBER
,      INTERNAL_PO_HEADER_ID
FROM CSD.CSD_PRODUCT_TRANSACTIONS;

Dependencies

[top of page]

CSD.CSD_PRODUCT_TRANSACTIONS does not reference any database object

CSD.CSD_PRODUCT_TRANSACTIONS is referenced by following:

APPS: CSD_PRODUCT_TRANSACTIONS