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

TABLE: INV.MTL_CONSUMPTION_TRANSACTIONS

Object Details
Object Name: MTL_CONSUMPTION_TRANSACTIONS
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_CONSUMPTION_TRANSACTIONS
Subobject Name:
Status: VALID


MTL_CONSUMPTION_TRANSACTIONS contains information related to the change of ownership transactions that have occurred to your consigned inventory. The table is used by the "Create Consumption Advice" concurrent program. Each consumption advice line correspond to one or more lines in this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CONSUMPTION_PO_HEADER_ID NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONSUMPTION_PO_HEADER_ID
CONSUMPTION_PROCESSED_FLAG NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONSUMPTION_PROCESSED_FLAG
CONSUMPTION_RELEASE_ID NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONSUMPTION_RELEASE_ID
PO_DISTRIBUTION_ID NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_DISTRIBUTION_ID
TRANSACTION_ID NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes ID of the transaction. Linked to the transaction_id in MTL_MATERIAL_TRANSACTIONS.
CONSUMPTION_RELEASE_ID NUMBER

id of the related consumption advice if the document is a PO Release.
CONSUMPTION_PO_HEADER_ID NUMBER

id of the related consumption advice if the document is a standard PO.
CONSUMPTION_PROCESSED_FLAG VARCHAR2 (1)
indicates the status of the row. Values are : N = indicates that the row has not been processed by the "Create Consumption Advice", Y = indicates that a consumption advice has been created and E = indicates that an error has occured during the creation of the consumption advice.
REQUEST_ID NUMBER

request id
CREATED_BY NUMBER
Yes who column
PROGRAM_APPLICATION_ID NUMBER

who column
CREATION_DATE DATE
Yes who column
PROGRAM_ID NUMBER

who column
LAST_UPDATED_BY NUMBER
Yes who column
PROGRAM_UPDATE_DATE DATE

who column
LAST_UPDATE_DATE DATE
Yes who column
LAST_UPDATE_LOGIN NUMBER

who column
NET_QTY NUMBER

transaction quantity inclusive of corrections
BATCH_ID NUMBER

indicates the concurrent process the record belongs to
RATE NUMBER

exchange rate if the original blanket is in a foreign currency
RATE_TYPE VARCHAR2 (24)
Exchange rate type
TAX_CODE_ID NUMBER

tax code id
TAX_RATE NUMBER

tax rate
ERROR_CODE VARCHAR2 (30)
Reason for create consumption advice failure. Not null only if CONSUMPTION_PROCESSED_FLAG = E.
RECOVERABLE_TAX NUMBER

recoverable tax
NON_RECOVERABLE_TAX NUMBER

non recoverable tax
TAX_RECOVERY_RATE NUMBER

tax recovery rate
PARENT_TRANSACTION_ID NUMBER

parent transaction id. Only used for transfer to consigned transactions (corrections to transfer to regular stock)
CHARGE_ACCOUNT_ID NUMBER

charge account
VARIANCE_ACCOUNT_ID NUMBER

variance account
GLOBAL_AGREEMENT_FLAG VARCHAR2 (1)
indicates if the record is associated with a global agreement
NEED_BY_DATE DATE

The need by date is the transaction date.
ERROR_EXPLANATION VARCHAR2 (240)
Error explanation
SECONDARY_NET_QTY NUMBER

'This secondary transaction quantity inclusive of corrections
BLANKET_PRICE NUMBER

Blanket price
PO_DISTRIBUTION_ID NUMBER

PO distribution identifier
INTERFACE_DISTRIBUTION_REF VARCHAR2 (240)
Interface Distribution Reference
TRANSACTION_SOURCE_ID NUMBER

Blanket header identifier
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
ACCRUAL_ACCOUNT_ID NUMBER

Accrual account identifier
ORGANIZATION_ID NUMBER

Organization identifier
OWNING_ORGANIZATION_ID NUMBER

Vendor site identifier
TRANSACTION_DATE DATE

Transaction date
PO_LINE_ID NUMBER

PO_LINE_ID
Query Text

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


SELECT TRANSACTION_ID
,      CONSUMPTION_RELEASE_ID
,      CONSUMPTION_PO_HEADER_ID
,      CONSUMPTION_PROCESSED_FLAG
,      REQUEST_ID
,      CREATED_BY
,      PROGRAM_APPLICATION_ID
,      CREATION_DATE
,      PROGRAM_ID
,      LAST_UPDATED_BY
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      NET_QTY
,      BATCH_ID
,      RATE
,      RATE_TYPE
,      TAX_CODE_ID
,      TAX_RATE
,      ERROR_CODE
,      RECOVERABLE_TAX
,      NON_RECOVERABLE_TAX
,      TAX_RECOVERY_RATE
,      PARENT_TRANSACTION_ID
,      CHARGE_ACCOUNT_ID
,      VARIANCE_ACCOUNT_ID
,      GLOBAL_AGREEMENT_FLAG
,      NEED_BY_DATE
,      ERROR_EXPLANATION
,      SECONDARY_NET_QTY
,      BLANKET_PRICE
,      PO_DISTRIBUTION_ID
,      INTERFACE_DISTRIBUTION_REF
,      TRANSACTION_SOURCE_ID
,      INVENTORY_ITEM_ID
,      ACCRUAL_ACCOUNT_ID
,      ORGANIZATION_ID
,      OWNING_ORGANIZATION_ID
,      TRANSACTION_DATE
,      PO_LINE_ID
FROM INV.MTL_CONSUMPTION_TRANSACTIONS;

Dependencies

[top of page]

INV.MTL_CONSUMPTION_TRANSACTIONS does not reference any database object

INV.MTL_CONSUMPTION_TRANSACTIONS is referenced by following:

SchemaINV
ViewMTL_CONSUMPTION_TRANSACTIONS#