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

VIEW: APPS.CSP_PICK_TRANSACTIONS_V

Object Details
Object Name: CSP_PICK_TRANSACTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSP.CSP_PICK_TRANSACTIONS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
TRANSACTION_HEADER_ID NUMBER

Transaction group identifier
TRANSACTION_TEMP_ID NUMBER

Transaction line identifier used to join to lot or serial table when under these controls
SOURCE_CODE VARCHAR2 (30)
Source identifier
SOURCE_LINE_ID NUMBER

Source line identifier
TRANSACTION_MODE NUMBER

Process mode code
LOCK_FLAG VARCHAR2 (1)
Row lock flag used by transaction manager
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
REVISION VARCHAR2 (3)
Inventory item revision code
ORGANIZATION_ID NUMBER
Yes Organization identifier
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory name
LOCATOR_ID NUMBER

Locator identifier
TRANSACTION_QUANTITY NUMBER
Yes Quantity entered at transaction time
PRIMARY_QUANTITY NUMBER
Yes Transaction quantity in terms of the primary uom of the item
TRANSACTION_UOM VARCHAR2 (3) Yes UOM used at the time of transaction
TRANSACTION_COST NUMBER

Transaction cost
TRANSACTION_TYPE_ID NUMBER
Yes Transaction type identifier
TRANSACTION_ACTION_ID NUMBER
Yes Transaction action identifier
TRANSACTION_SOURCE_TYPE_ID NUMBER
Yes Transaction source type identifier
TRANSACTION_SOURCE_ID NUMBER

Transaction source identifier
TRANSACTION_SOURCE_NAME VARCHAR2 (80)
Transaction source name
TRANSACTION_DATE DATE
Yes Transaction date
ACCT_PERIOD_ID NUMBER
Yes Accounting period identifier
DISTRIBUTION_ACCOUNT_ID NUMBER

Account identifier the transaction charged to
TRANSACTION_REFERENCE VARCHAR2 (240)
Transaction reference
REQUISITION_LINE_ID NUMBER

Requisition line identifier
REQUISITION_DISTRIBUTION_ID NUMBER

Requisition distribution identifier
REASON_ID NUMBER

Transaction reason identifier
LOT_NUMBER VARCHAR2 (80)
Lot number
LOT_EXPIRATION_DATE DATE

Lot expiration date
SERIAL_NUMBER VARCHAR2 (30)
Serial number
RECEIVING_DOCUMENT VARCHAR2 (10)
Receiving document
DEMAND_ID NUMBER

Demand identifier
RCV_TRANSACTION_ID NUMBER

Receiving transaction identifier
MOVE_TRANSACTION_ID NUMBER

Move transaction identifier
COMPLETION_TRANSACTION_ID NUMBER

Completion transaction identifier
WIP_ENTITY_TYPE NUMBER

WIP entity type code
SCHEDULE_ID NUMBER

WIP repetitive schedule identifier
REPETITIVE_LINE_ID NUMBER

Repetitive line identifier
EMPLOYEE_CODE VARCHAR2 (10)
Employee code
PRIMARY_SWITCH NUMBER

Primary assembly identifier
SCHEDULE_UPDATE_CODE NUMBER

Schedule update code
SETUP_TEARDOWN_CODE NUMBER

Setup teardown code
ITEM_ORDERING NUMBER

Item ordering
NEGATIVE_REQ_FLAG NUMBER

Negative requirement flag
OPERATION_SEQ_NUM NUMBER

Operation sequence number within a routing
PICKING_LINE_ID NUMBER

Picking line id
TRX_SOURCE_LINE_ID NUMBER

Line level transaction source identifier
TRX_SOURCE_DELIVERY_ID NUMBER

Delivery level transaction source identifier
PHYSICAL_ADJUSTMENT_ID NUMBER

Physical adjustment identifier
CYCLE_COUNT_ID NUMBER

Cycle count identifier
RMA_LINE_ID NUMBER

RMA line identifier
CUSTOMER_SHIP_ID NUMBER

Customer shipping identifier
CURRENCY_CODE VARCHAR2 (10)
Currency code
CURRENCY_CONVERSION_RATE NUMBER

Currency conversion rate
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency conversion type
CURRENCY_CONVERSION_DATE DATE

Currency conversion date
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL transaction date
VENDOR_LOT_NUMBER VARCHAR2 (30)
Supplier lot number
ENCUMBRANCE_ACCOUNT NUMBER

Encumbrance account identifier
ENCUMBRANCE_AMOUNT NUMBER

Encumbrance amount
SHIP_TO_LOCATION NUMBER

Ship to location identifier
SHIPMENT_NUMBER VARCHAR2 (30)
Intransit shipment identifier
TRANSFER_COST NUMBER

Transfer cost
TRANSPORTATION_COST NUMBER

Transportation cost
TRANSPORTATION_ACCOUNT NUMBER

Transportation account
FREIGHT_CODE VARCHAR2 (30)
Freight identifier
CONTAINERS NUMBER

Containers
WAYBILL_AIRBILL VARCHAR2 (30)
Waybill / Airbill
EXPECTED_ARRIVAL_DATE DATE

Expected arrival date
TRANSFER_SUBINVENTORY VARCHAR2 (10)
Opposing subinventory identifier in transfer transactions
TRANSFER_ORGANIZATION NUMBER

Opposing organization identifier in transfer transactions
TRANSFER_TO_LOCATION NUMBER

Opposing locator identifier in transfer transactions
NEW_AVERAGE_COST NUMBER

New average cost used for average cost update
VALUE_CHANGE NUMBER

Value change used for average cost update
PERCENTAGE_CHANGE NUMBER

Percent change used for average cost update
MATERIAL_ALLOCATION_TEMP_ID NUMBER

Material allocation temporary identifier
DEMAND_SOURCE_HEADER_ID NUMBER

Demand source header identifier
DEMAND_SOURCE_LINE VARCHAR2 (30)
Demand source line identifier
DEMAND_SOURCE_DELIVERY VARCHAR2 (30)
Demand source delivery
ITEM_SEGMENTS VARCHAR2 (240)
Inventory item segments
ITEM_DESCRIPTION VARCHAR2 (240)
Inventory item description
ITEM_TRX_ENABLED_FLAG VARCHAR2 (1)
Inventory item transaction enabled flag
ITEM_LOCATION_CONTROL_CODE NUMBER

Inventory item locator control code
ITEM_RESTRICT_SUBINV_CODE NUMBER

Inventory item restrict subinventory code
ITEM_RESTRICT_LOCATORS_CODE NUMBER

Inventory item restrict locators code
ITEM_REVISION_QTY_CONTROL_CODE NUMBER

Inventory item revision control code
ITEM_PRIMARY_UOM_CODE VARCHAR2 (3)
Inventory item primary uom
ITEM_UOM_CLASS VARCHAR2 (10)
Inventory item uom class
ITEM_SHELF_LIFE_CODE NUMBER

Inventory item shelf life code
ITEM_SHELF_LIFE_DAYS NUMBER

Inventory item shelf life days
ITEM_LOT_CONTROL_CODE NUMBER

Inventory item lot control code
ITEM_SERIAL_CONTROL_CODE NUMBER

Inventory item serial control code
ITEM_INVENTORY_ASSET_FLAG VARCHAR2 (1)
Inventory item asset flag
ALLOWED_UNITS_LOOKUP_CODE NUMBER

Inventory item uom conversions type
DEPARTMENT_ID NUMBER

Department identifier
DEPARTMENT_CODE VARCHAR2 (10)
Department code
WIP_SUPPLY_TYPE NUMBER

WIP supply type
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supply subinventory
SUPPLY_LOCATOR_ID NUMBER

Supply locator identifier
VALID_SUBINVENTORY_FLAG VARCHAR2 (1)
Valid subinventory flag
VALID_LOCATOR_FLAG VARCHAR2 (1)
Valid locator flag
LOCATOR_SEGMENTS VARCHAR2 (240)
Locator segments
CURRENT_LOCATOR_CONTROL_CODE NUMBER

Inventory item locator control code
NUMBER_OF_LOTS_ENTERED NUMBER

Total lot records entered
WIP_COMMIT_FLAG VARCHAR2 (1)
WIP commit flag
NEXT_LOT_NUMBER VARCHAR2 (30)
Inventory item next lot number
LOT_ALPHA_PREFIX VARCHAR2 (30)
Inventory item lot prefix
NEXT_SERIAL_NUMBER VARCHAR2 (30)
Inventory item next valid serial number
SERIAL_ALPHA_PREFIX VARCHAR2 (30)
Inventory item serial prefix
SHIPPABLE_FLAG VARCHAR2 (1)
Inventory item shippable flag
POSTING_FLAG VARCHAR2 (1)
Posting flag
REQUIRED_FLAG VARCHAR2 (1)
Required flag
PROCESS_FLAG VARCHAR2 (1)
Row process flag used by Transaction Manager
ERROR_CODE VARCHAR2 (240)
Error code
ERROR_EXPLANATION VARCHAR2 (240)
Error explanation
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining 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
MOVEMENT_ID NUMBER

Movement statistics cross reference
RESERVATION_QUANTITY NUMBER

Reservation quantity
SHIPPED_QUANTITY NUMBER

Shipped quantity
TRANSACTION_LINE_NUMBER NUMBER

Transaction line number
TASK_ID NUMBER (15)
Task identifier
TO_TASK_ID NUMBER (15)
"To" task identifier
SOURCE_TASK_ID NUMBER

Source task identifier
PROJECT_ID NUMBER (15)
Project identifier
SOURCE_PROJECT_ID NUMBER

Source project identifier
PA_EXPENDITURE_ORG_ID NUMBER

Oracle projects related expenditure organization identifier
TO_PROJECT_ID NUMBER (15)
"To" project identifier
EXPENDITURE_TYPE VARCHAR2 (30)
Oracle projects related expenditure type
FINAL_COMPLETION_FLAG VARCHAR2 (1)
Indicates if job costs must be flushed out for this job completion
TRANSFER_PERCENTAGE NUMBER

Percentage of value to attribute to transfer costs in an inter-org transfer
TRANSACTION_SEQUENCE_ID NUMBER

Transaction sequence identifie
MATERIAL_ACCOUNT NUMBER

Specifies the material account
MATERIAL_OVERHEAD_ACCOUNT NUMBER

Specifies the material overhead account
RESOURCE_ACCOUNT NUMBER

Specifies the resource account
OUTSIDE_PROCESSING_ACCOUNT NUMBER

Specifies the account to be charged for outside processing
OVERHEAD_ACCOUNT NUMBER

Specifies the overhead account
FLOW_SCHEDULE VARCHAR2 (1)
Specifies whether the WIP transaction is a flow or schedule type transaction
COST_GROUP_ID NUMBER

Cost group identifier
DEMAND_CLASS VARCHAR2 (30)
The class to which the demand is tied
QA_COLLECTION_ID NUMBER

Quality results identifier
KANBAN_CARD_ID NUMBER

Kanban card identifier
OVERCOMPLETION_TRANSACTION_ID NUMBER

Overcompletion transaction identifier
OVERCOMPLETION_PRIMARY_QTY NUMBER

Overcompletion primary quantity
OVERCOMPLETION_TRANSACTION_QTY NUMBER

Overcompletion transaction quantity
END_ITEM_UNIT_NUMBER VARCHAR2 (60)
End item unit number
SCHEDULED_PAYBACK_DATE DATE

Standard Who column
LINE_TYPE_CODE NUMBER

Line type code
PARENT_TRANSACTION_TEMP_ID NUMBER

Parent transaction identifier
PUT_AWAY_STRATEGY_ID NUMBER

Put away strategy identifier
PUT_AWAY_RULE_ID NUMBER

Put away rule identifier
PICK_STRATEGY_ID NUMBER

Pick strategy identifier
PICK_RULE_ID NUMBER

Pick rule identifier
COMMON_BOM_SEQ_ID NUMBER

Bill identifier for the common BOM used
COMMON_ROUTING_SEQ_ID NUMBER

Routing identifier for the common routing used
COST_TYPE_ID NUMBER

Cost type
ORG_COST_GROUP_ID NUMBER

Organization's cost group identifier
MOVE_ORDER_LINE_ID NUMBER

Move order line identifier that this transaction line is tied to
TASK_GROUP_ID NUMBER

Task group identifier for this task
PICK_SLIP_NUMBER NUMBER

Pick slip number for the transaction line
RESERVATION_ID NUMBER

Reservation identifier
TRANSACTION_STATUS NUMBER

Indicates if the transaction has to be processed or just saved. NULL or 1 is default behavior. 2 is save only. 3 is ready to process
FROM_SUBINV_LOC_TYPE NUMBER

Locator type for source subinventory
TO_SUBINV_LOC_TYPE NUMBER

Locator type for the destination subinventory
PICKLIST_LINE_ID NUMBER (35) Yes Picklist line identifier
PICKLIST_LINE_NUMBER NUMBER (35) Yes Picklist line number
PICKLIST_HEADER_ID NUMBER (35) Yes Picklist header identifier
PICK_UOM_CODE VARCHAR2 (3) Yes Uom code used for the pick
QUANTITY_PICKED NUMBER (35) Yes Quantity picked
STANDARD_OPERATION_ID NUMBER

Standard operation identifier
TASK_PRIORITY NUMBER

Task priority
WMS_TASK_TYPE NUMBER

(for future use only)
PARENT_LINE_ID NUMBER

(for future use only)
Query Text

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


SELECT ROW_ID
,      TRANSACTION_HEADER_ID
,      TRANSACTION_TEMP_ID
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      TRANSACTION_MODE
,      LOCK_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      INVENTORY_ITEM_ID
,      REVISION
,      ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      TRANSACTION_QUANTITY
,      PRIMARY_QUANTITY
,      TRANSACTION_UOM
,      TRANSACTION_COST
,      TRANSACTION_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_NAME
,      TRANSACTION_DATE
,      ACCT_PERIOD_ID
,      DISTRIBUTION_ACCOUNT_ID
,      TRANSACTION_REFERENCE
,      REQUISITION_LINE_ID
,      REQUISITION_DISTRIBUTION_ID
,      REASON_ID
,      LOT_NUMBER
,      LOT_EXPIRATION_DATE
,      SERIAL_NUMBER
,      RECEIVING_DOCUMENT
,      DEMAND_ID
,      RCV_TRANSACTION_ID
,      MOVE_TRANSACTION_ID
,      COMPLETION_TRANSACTION_ID
,      WIP_ENTITY_TYPE
,      SCHEDULE_ID
,      REPETITIVE_LINE_ID
,      EMPLOYEE_CODE
,      PRIMARY_SWITCH
,      SCHEDULE_UPDATE_CODE
,      SETUP_TEARDOWN_CODE
,      ITEM_ORDERING
,      NEGATIVE_REQ_FLAG
,      OPERATION_SEQ_NUM
,      PICKING_LINE_ID
,      TRX_SOURCE_LINE_ID
,      TRX_SOURCE_DELIVERY_ID
,      PHYSICAL_ADJUSTMENT_ID
,      CYCLE_COUNT_ID
,      RMA_LINE_ID
,      CUSTOMER_SHIP_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      USSGL_TRANSACTION_CODE
,      VENDOR_LOT_NUMBER
,      ENCUMBRANCE_ACCOUNT
,      ENCUMBRANCE_AMOUNT
,      SHIP_TO_LOCATION
,      SHIPMENT_NUMBER
,      TRANSFER_COST
,      TRANSPORTATION_COST
,      TRANSPORTATION_ACCOUNT
,      FREIGHT_CODE
,      CONTAINERS
,      WAYBILL_AIRBILL
,      EXPECTED_ARRIVAL_DATE
,      TRANSFER_SUBINVENTORY
,      TRANSFER_ORGANIZATION
,      TRANSFER_TO_LOCATION
,      NEW_AVERAGE_COST
,      VALUE_CHANGE
,      PERCENTAGE_CHANGE
,      MATERIAL_ALLOCATION_TEMP_ID
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE
,      DEMAND_SOURCE_DELIVERY
,      ITEM_SEGMENTS
,      ITEM_DESCRIPTION
,      ITEM_TRX_ENABLED_FLAG
,      ITEM_LOCATION_CONTROL_CODE
,      ITEM_RESTRICT_SUBINV_CODE
,      ITEM_RESTRICT_LOCATORS_CODE
,      ITEM_REVISION_QTY_CONTROL_CODE
,      ITEM_PRIMARY_UOM_CODE
,      ITEM_UOM_CLASS
,      ITEM_SHELF_LIFE_CODE
,      ITEM_SHELF_LIFE_DAYS
,      ITEM_LOT_CONTROL_CODE
,      ITEM_SERIAL_CONTROL_CODE
,      ITEM_INVENTORY_ASSET_FLAG
,      ALLOWED_UNITS_LOOKUP_CODE
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      WIP_SUPPLY_TYPE
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      VALID_SUBINVENTORY_FLAG
,      VALID_LOCATOR_FLAG
,      LOCATOR_SEGMENTS
,      CURRENT_LOCATOR_CONTROL_CODE
,      NUMBER_OF_LOTS_ENTERED
,      WIP_COMMIT_FLAG
,      NEXT_LOT_NUMBER
,      LOT_ALPHA_PREFIX
,      NEXT_SERIAL_NUMBER
,      SERIAL_ALPHA_PREFIX
,      SHIPPABLE_FLAG
,      POSTING_FLAG
,      REQUIRED_FLAG
,      PROCESS_FLAG
,      ERROR_CODE
,      ERROR_EXPLANATION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      MOVEMENT_ID
,      RESERVATION_QUANTITY
,      SHIPPED_QUANTITY
,      TRANSACTION_LINE_NUMBER
,      TASK_ID
,      TO_TASK_ID
,      SOURCE_TASK_ID
,      PROJECT_ID
,      SOURCE_PROJECT_ID
,      PA_EXPENDITURE_ORG_ID
,      TO_PROJECT_ID
,      EXPENDITURE_TYPE
,      FINAL_COMPLETION_FLAG
,      TRANSFER_PERCENTAGE
,      TRANSACTION_SEQUENCE_ID
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      OVERHEAD_ACCOUNT
,      FLOW_SCHEDULE
,      COST_GROUP_ID
,      DEMAND_CLASS
,      QA_COLLECTION_ID
,      KANBAN_CARD_ID
,      OVERCOMPLETION_TRANSACTION_ID
,      OVERCOMPLETION_PRIMARY_QTY
,      OVERCOMPLETION_TRANSACTION_QTY
,      END_ITEM_UNIT_NUMBER
,      SCHEDULED_PAYBACK_DATE
,      LINE_TYPE_CODE
,      PARENT_TRANSACTION_TEMP_ID
,      PUT_AWAY_STRATEGY_ID
,      PUT_AWAY_RULE_ID
,      PICK_STRATEGY_ID
,      PICK_RULE_ID
,      COMMON_BOM_SEQ_ID
,      COMMON_ROUTING_SEQ_ID
,      COST_TYPE_ID
,      ORG_COST_GROUP_ID
,      MOVE_ORDER_LINE_ID
,      TASK_GROUP_ID
,      PICK_SLIP_NUMBER
,      RESERVATION_ID
,      TRANSACTION_STATUS
,      FROM_SUBINV_LOC_TYPE
,      TO_SUBINV_LOC_TYPE
,      PICKLIST_LINE_ID
,      PICKLIST_LINE_NUMBER
,      PICKLIST_HEADER_ID
,      PICK_UOM_CODE
,      QUANTITY_PICKED
,      STANDARD_OPERATION_ID
,      TASK_PRIORITY
,      WMS_TASK_TYPE
,      PARENT_LINE_ID
FROM APPS.CSP_PICK_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.CSP_PICK_TRANSACTIONS_V references the following:

SchemaAPPS
SynonymCSP_PICKLIST_HEADERS
SynonymCSP_PICKLIST_LINES
SynonymMTL_MATERIAL_TRANSACTIONS_TEMP
SynonymMTL_SECONDARY_INVENTORIES

APPS.CSP_PICK_TRANSACTIONS_V is not referenced by any database object