Skip to content

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

VIEW: CSD.CSD_PRODUCT_TRANSACTIONS#

Object Details
Object Name: CSD_PRODUCT_TRANSACTIONS#
Object Type: VIEW
Owner: CSD
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PRODUCT_TRANSACTION_ID NUMBER (15) Yes
REPAIR_LINE_ID NUMBER (15) Yes
ESTIMATE_DETAIL_ID NUMBER

ACTION_TYPE VARCHAR2 (30)
ACTION_CODE VARCHAR2 (30)
INTERFACE_TO_OM_FLAG VARCHAR2 (1)
BOOK_SALES_ORDER_FLAG VARCHAR2 (1)
RELEASE_SALES_ORDER_FLAG VARCHAR2 (1)
SHIP_SALES_ORDER_FLAG VARCHAR2 (1)
SUB_INVENTORY VARCHAR2 (30)
LOT_NUMBER VARCHAR2 (80)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
OBJECT_VERSION_NUMBER NUMBER
Yes
SECURITY_GROUP_ID NUMBER

PROD_TXN_STATUS VARCHAR2 (30)
PROD_TXN_CODE VARCHAR2 (30)
SHIPPED_SERIAL_NUMBER VARCHAR2 (30)
SOURCE_SERIAL_NUMBER VARCHAR2 (30)
NON_SOURCE_SERIAL_NUMBER VARCHAR2 (30)
SOURCE_INSTANCE_ID NUMBER

NON_SOURCE_INSTANCE_ID NUMBER

REQ_HEADER_ID NUMBER

REQ_LINE_ID NUMBER

ORDER_HEADER_ID NUMBER

ORDER_LINE_ID NUMBER

QUANTITY_RECEIVED NUMBER

QUANTITY_SHIPPED NUMBER

LOCATOR_ID NUMBER

SUB_INVENTORY_RCVD VARCHAR2 (30)
LOT_NUMBER_RCVD VARCHAR2 (80)
PICKING_RULE_ID NUMBER (15)
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
UNIT_NUMBER VARCHAR2 (30)
INTERNAL_PO_HEADER_ID NUMBER

UNPLANNED_RECEIPT_FLAG VARCHAR2 (3)
EXP_QUANTITY NUMBER

INVENTORY_ITEM_ID NUMBER

SHIP_FROM_OU NUMBER

SHIP_FROM_ORG NUMBER

RCV_INTO_OU NUMBER

RCV_INTO_ORG NUMBER

QUANTITY_PICKED NUMBER

DELIVERY_DETAIL_ID NUMBER

QUANTITY_AVAILABLE NUMBER

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
,      UNPLANNED_RECEIPT_FLAG
,      EXP_QUANTITY
,      INVENTORY_ITEM_ID
,      SHIP_FROM_OU
,      SHIP_FROM_ORG
,      RCV_INTO_OU
,      RCV_INTO_ORG
,      QUANTITY_PICKED
,      DELIVERY_DETAIL_ID
,      QUANTITY_AVAILABLE
FROM CSD.CSD_PRODUCT_TRANSACTIONS#;

Dependencies

[top of page]

CSD.CSD_PRODUCT_TRANSACTIONS# references the following:

SchemaCSD
TableCSD_PRODUCT_TRANSACTIONS
CSD.CSD_PRODUCT_TRANSACTIONS# is referenced by following:

SchemaAPPS
SynonymCSD_PRODUCT_TRANSACTIONS