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

TABLE: CSD.CSD_BULK_RECEIVE_ITEMS_B

Object Details
Object Name: CSD_BULK_RECEIVE_ITEMS_B
Object Type: TABLE
Owner: CSD
FND Design Data: TableCSD.CSD_BULK_RECEIVE_ITEMS_B
Subobject Name:
Status: VALID


Transaction table for Bulk Receive module.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BULK_RECEIVE_ID NUMBER
Yes Primary Key
TRANSACTION_NUMBER NUMBER

Transaction Number
ORIG_PARTY_ID NUMBER

Original Party ID Identifier ( Entered Party)
ORIG_CUST_ACCOUNT_ID NUMBER

Original Customer Account ID Identifier ( Entered Account)
PARTY_ID NUMBER

Party ID Identifier
CUST_ACCOUNT_ID NUMBER

Customer Account ID Identifier
SERIAL_NUMBER VARCHAR2 (30)
Serial Number
INVENTORY_ITEM_ID NUMBER

Inventory Item ID Identifier
INSTANCE_ID NUMBER

Instance ID Identifier
QUANTITY NUMBER

Quantity
UOM_CODE VARCHAR2 (3)
Unit of Measure Identifier
STATUS VARCHAR2 (30)
Record Status - It can either 'NEW','ERRORED','PROCESSED'
CHANGE_OWNER_FLAG VARCHAR2 (1)
Change Owner Flag - Indicates if Change owner is required
INTERNAL_SR_FLAG VARCHAR2 (1)
Internal SR Flag
WARNING_FLAG VARCHAR2 (1)
Warning Flag
WARNING_REASON_CODE VARCHAR2 (80)
Warning Reason Code
INCIDENT_ID NUMBER

Incident ID Identifier
REPAIR_LINE_ID NUMBER

Repair Line Identifier
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
OBJECT_VERSION_NUMBER NUMBER

Standard Who column
CREATED_BY NVARCHAR2 (30)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

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).
Query Text

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


SELECT BULK_RECEIVE_ID
,      TRANSACTION_NUMBER
,      ORIG_PARTY_ID
,      ORIG_CUST_ACCOUNT_ID
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      SERIAL_NUMBER
,      INVENTORY_ITEM_ID
,      INSTANCE_ID
,      QUANTITY
,      UOM_CODE
,      STATUS
,      CHANGE_OWNER_FLAG
,      INTERNAL_SR_FLAG
,      WARNING_FLAG
,      WARNING_REASON_CODE
,      INCIDENT_ID
,      REPAIR_LINE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM CSD.CSD_BULK_RECEIVE_ITEMS_B;

Dependencies

[top of page]

CSD.CSD_BULK_RECEIVE_ITEMS_B does not reference any database object

CSD.CSD_BULK_RECEIVE_ITEMS_B is referenced by following:

SchemaAPPS
SynonymCSD_BULK_RECEIVE_ITEMS_B