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).
UNPLANNED_RECEIPT_FLAG VARCHAR2 (3)
Unplanned Receipt Flag
ORDER_HEADER_ID NUMBER

Matching order header
ORDER_LINE_ID NUMBER

Matching order line
UNDER_RECEIPT_FLAG VARCHAR2 (3)
Under receipt flag
OVER_RECEIPT_FLAG VARCHAR2 (3)
Over receipt flag
UNDER_RECEIPT_QTY NUMBER

Under receipt qty
OVER_RECEIPT_QTY NUMBER

over receipt qty
EXTERNAL_REFERENCE VARCHAR2 (30)
External ref
OM_CROSS_REFERENCE VARCHAR2 (30)
OM Cross ref (Not user)
LOT_NUMBER VARCHAR2 (30)
Lot Number
ITEM_REVISION VARCHAR2 (3)
Item revision
SUBINVENTORY VARCHAR2 (30)
Subinventory
LOCATOR_ID NUMBER

Locator information
RCV_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Receiving Flex
RCV_ATTRIBUTE1 VARCHAR2 (150)
Receiving DFF Attribute
RCV_ATTRIBUTE2 VARCHAR2 (150)
Receiving DFF Attribute
RCV_ATTRIBUTE3 VARCHAR2 (240)
Receiving DFF Attribute
RCV_ATTRIBUTE4 VARCHAR2 (150)
Receiving DFF Attribute
RCV_ATTRIBUTE5 VARCHAR2 (150)
Receiving DFF Attribute
RCV_ATTRIBUTE6 VARCHAR2 (150)
Receiving DFF Attribute
RCV_ATTRIBUTE7 VARCHAR2 (150)
Receiving DFF Attribute
RCV_ATTRIBUTE8 VARCHAR2 (150)
Receiving DFF Attribute
RCV_ATTRIBUTE9 VARCHAR2 (150)
Receiving DFF Attribute
RCV_ATTRIBUTE10 VARCHAR2 (150)
Receiving DFF Attribute
RCV_ATTRIBUTE11 VARCHAR2 (150)
Receiving DFF Attribute
RCV_ATTRIBUTE12 VARCHAR2 (150)
Receiving DFF Attribute
RCV_ATTRIBUTE13 VARCHAR2 (150)
Receiving DFF Attribute
RCV_ATTRIBUTE14 VARCHAR2 (150)
Receiving DFF Attribute
RCV_ATTRIBUTE15 VARCHAR2 (150)
Receiving DFF Attribute
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
,      UNPLANNED_RECEIPT_FLAG
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      UNDER_RECEIPT_FLAG
,      OVER_RECEIPT_FLAG
,      UNDER_RECEIPT_QTY
,      OVER_RECEIPT_QTY
,      EXTERNAL_REFERENCE
,      OM_CROSS_REFERENCE
,      LOT_NUMBER
,      ITEM_REVISION
,      SUBINVENTORY
,      LOCATOR_ID
,      RCV_ATTRIBUTE_CATEGORY
,      RCV_ATTRIBUTE1
,      RCV_ATTRIBUTE2
,      RCV_ATTRIBUTE3
,      RCV_ATTRIBUTE4
,      RCV_ATTRIBUTE5
,      RCV_ATTRIBUTE6
,      RCV_ATTRIBUTE7
,      RCV_ATTRIBUTE8
,      RCV_ATTRIBUTE9
,      RCV_ATTRIBUTE10
,      RCV_ATTRIBUTE11
,      RCV_ATTRIBUTE12
,      RCV_ATTRIBUTE13
,      RCV_ATTRIBUTE14
,      RCV_ATTRIBUTE15
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:

SchemaCSD
ViewCSD_BULK_RECEIVE_ITEMS_B#