CSE_ASSETS_GT
This is a global temporary table that is used in the processing for genealogy integration.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments | Status |
---|---|---|---|---|---|
GTT_ASSET_ID | NUMBER | 18 | The internal primay key to be used in the current session for the asset that is to be processed. | ||
PARENT_GTT_ASSET_ID | NUMBER | 18 | Reference to an in process asset that is also avaialble in this session. | ||
GTT_TXN_ID | NUMBER | 18 | The transaction reference of the asset that is being processed in this same session. | ||
GTT_REF_DOC_ID | NUMBER | 18 | A recerence document identifier associated to the Asset. | ||
GTT_SRC_DOC_ID | NUMBER | 18 | A source document identifier associated to the asset. | ||
GTT_GROUP_ID | NUMBER | 18 | The group id that groups the assets that is being processed in this session. | ||
TRANSACTION_QTY | NUMBER | The transaction quantity of the asset. | |||
QTY_PER_PARENT | NUMBER | The quantity per parent. This is used in the sales order fulfillment processing. | |||
ASSET_TRACKED_FLAG | VARCHAR2 | 1 | The asset tracked flag from the item master, denormalized here for processing. | ||
ENABLE_GENEALOGY_TRACKING_FLAG | VARCHAR2 | 1 | The genealogy tracking flag from the item master, denormalized here for processing. | ||
PRIMARY_UOM_CODE | VARCHAR2 | 3 | The primary unit of measure code from the item master, denormalized here for processing. | ||
ASSET_ID | NUMBER | 18 | Unique identifier and Primary Key for the asset. System Generated using the Fusion Global Unique ID generator | ||
ASSET_OVN | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
ASSET_NUMBER | VARCHAR2 | 80 | An user identifier for the asset object. This is the user primary key for the asset. If user does not enter a value then it is system generated using the Asset Document Number Sequence. | ||
ASSET_TAG | VARCHAR2 | 240 | Asset Tag. This is an additional way of identifying the asset. | ||
BOM_ITEM_TYPE | NUMBER | The bom item type as defined in the item master, denormalized here for processing. | |||
PICK_COMPONENTS_FLAG | VARCHAR2 | 1 | The pick components flag as defined in the item master. | ||
REPLENISH_TO_ORDER_FLAG | VARCHAR2 | 1 | The replenish to order flag as defined in the item master. | ||
ITEM_ID | NUMBER | 18 | Item identifier of the Asset that is being processed. | ||
ITEM_ORGANIZATION_ID | NUMBER | 18 | The organization id where this product instance is instantiated. This is usually the context organization when done from the workarea landing page. However transactional instantians will inherit the organization context of the transaction. | ||
ITEM_REVISION | VARCHAR2 | 18 | The current revision of the product. As captured from the latest transaction. | ||
SERIAL_NUMBER | VARCHAR2 | 80 | The Serial Number of the product. Which uniquely identifies the product instance that is either manufactured as an end assembly product or as components bought from the supplier. | ||
LOT_NUMBER | VARCHAR2 | 80 | The unique lot number at the product instance level that tracks the batch of assemblies that are manufactured or procured from supplier. | ||
GEN_OBJECT_ID | NUMBER | 18 | Genealogy Object Identifier. The foreign key to the genealogy object. | ||
QUANTITY | NUMBER | Product Instance Quantity. It is always 1 for the serialized product instance. For the lot, it is the lot quantity at the tracked location. | |||
UOM_CODE | VARCHAR2 | 3 | The primary unit of measure that tracks the product instance quantity. | ||
SECONDARY_QUANTITY | NUMBER | This is the secondary quantity captured when the item supports dual units of measure. | |||
SECONDARY_UOM_CODE | VARCHAR2 | 3 | The unit of measure code for the secondary quantity. This is captured only when the item supports dual units of measure. | ||
STATUS_CODE | VARCHAR2 | 30 | The status of the Asset. Product instance when tracked in the Inventory or WIP location may not have a status to be tracked. | ||
ACTIVE_END_DATE | TIMESTAMP | The date when the asset is terminated. | |||
CURRENT_LOCATION_CONTEXT | VARCHAR2 | 80 | The current location context. This identifies the asset being located in the work center, inventory, wip job or in a customer location. | ||
CURRENT_LOCATION_ID | NUMBER | 18 | Current Location Identifier. The address location identifier. | ||
LOCATION_ORGANIZATION_ID | NUMBER | 18 | The organization id where the asset is located now. This works in conjunction with the other location columns like the work_center_id and the subinventory and locator. | ||
SUBINVENTORY_CODE | VARCHAR2 | 30 | Subinventory Identifier. The inventory warehouse location. | ||
INVENTORY_LOCATOR_ID | NUMBER | 18 | The inventory item locator identifier. | ||
WORK_ORDER_ID | NUMBER | 18 | Work Order Reference when the component is issues to the work order. | ||
WORK_ORDER_OPERATION_ID | NUMBER | 18 | Work Order Operation Identifier. When the processing involves a manufacturing Work Order. | ||
WORK_CENTER_ID | NUMBER | 18 | Work Center Identifier. The foreign key to the work center entity. | ||
PARTIALLY_FINISHED_FLAG | VARCHAR2 | 1 | Flag indicating whether the assembly serail is still a partially finished assembly. | ||
UNASSIGNED_FLAG | VARCHAR2 | 1 | A flag that indicates whether the asset is assigned to the parent during the manufacturing process. | ||
SORDER_SOURCE_SYSTEM_TYPE | VARCHAR2 | 30 | The sales order source system where the order is captured. | ||
SALES_ORDER_SOURCE_SYSTEM | VARCHAR2 | 30 | The source sales order system from which the order is captured. | ||
SALES_ORDER_NUMBER | VARCHAR2 | 120 | The user key to the sales order business object | ||
SALES_ORDER_ID | NUMBER | 18 | Sales Order Identifier. Foreign key to the FOM Sales Order Entity. | ||
SALES_ORDER_LINE_NUMBER | VARCHAR2 | 120 | The user key to the sales order lines entity. | ||
SALES_ORDER_LINE_ID | NUMBER | 18 | Sales Order Line Identifier. Foreign key to the FOM Sales Order Lines entity. | ||
FULFILL_LINE_ID | NUMBER | 18 | The distributed order orchestration fulfillment line reference. | ||
OM_MAP_ID | NUMBER | 18 | The mapping identifier from the user configured service map for processing asset data from order fulfillments. | ||
PARENT_FULFILL_LINE_ID | NUMBER | 18 | The parent fulfillment line reference in the context of the asset that was fulfilled by distributed order orchestration's fulfillment line. | ||
ROOT_PAR_FULFILL_LINE_ID | NUMBER | 18 | The root parent fulfillment line identifier. | ||
PARENT_ORDER_LINE_NUMBER | VARCHAR2 | 120 | The order line number of the parent order line. When assets are created from om integration, the parent order line reference is provided, we capture that against the asset. | ||
PARENT_ORDER_LINE_ID | NUMBER | 18 | The order line identifier of the parent order line. When assets are created from om integration, the parent order line reference is provided, we capture that against the asset. | ||
RMA_SOURCE_SYSTEM_TYPE | VARCHAR2 | 30 | The return order source system type. | ||
RMA_ORDER_SOURCE_SYSTEM | VARCHAR2 | 30 | The return order source system. | ||
RMA_ORDER_NUMBER | VARCHAR2 | 120 | The return sales order number. | ||
RMA_ORDER_ID | NUMBER | 18 | The return sales order identifier. | ||
RMA_ORDER_LINE_NUMBER | VARCHAR2 | 120 | The return sales order line number. | ||
RMA_ORDER_LINE_ID | NUMBER | 18 | The return sales order line identifier. | ||
RMA_FULFILL_LINE_ID | NUMBER | 18 | The return sales order fulfillment line identifier. | ||
RMA_PAR_FULFILL_LINE_ID | NUMBER | 18 | The return sales oder fulfillment line identifier's parent. | ||
RMA_ROOT_PAR_FULFILL_LINE_ID | NUMBER | 18 | The root parent fulfillment line identifier of the return sales order fulfillment line. | ||
RMA_PAR_ORDER_LINE_NUMBER | VARCHAR2 | 120 | The parent line of the return sales order line. | ||
RMA_PAR_ORDER_LINE_ID | NUMBER | 18 | The parent line identifier of the return sales order line. | ||
INSTALLED_LOCATION_CONTEXT | VARCHAR2 | 80 | The installed location context. The type of location where the asset is installed. | ||
INSTALLED_LOCATION_ID | NUMBER | 18 | Installed Location Identifier. Foreign key to either the hr location or hz location. | ||
SHIPMENT_DATE | DATE | Date when the asset is shipped to the customer. | |||
INSTALLED_DATE | DATE | Date when the asset is installed. | |||
IN_SERVICE_DATE | DATE | Date when the asset is placed in service. | |||
PURCHASE_DATE | DATE | Procurement Date. Date when the asset is procured from the Supplier. | |||
ORIGINATION_DATE | TIMESTAMP | The original creation date of the Lot Number or Serial Number. | |||
SOLD_BY_BUSINESS_UNIT_ID | NUMBER | 18 | Sold By Business Unit Identifier | ||
REGISTERED_FLAG | VARCHAR2 | 1 | Flag to indicate if the customer asset is registered or not. | ||
CUSTOMER_ASSET_START_DATE | TIMESTAMP | The date when the customer asset was instantiated. Either during the creation of the asset when the item was set to track customer assets only or updated to the customer asset when the item is enabled for lifecycle tracking. | |||
CUSTOMER_ASSET_END_DATE | TIMESTAMP | The date when the asset is no longer a customer asset. Either during the return of the asset back to the enterprise for good or when manually terminated from being a customer asset. | |||
CUSTOMER_ID | NUMBER | 18 | Customer Identifier. This is the sold to party id for which the asset is sold to. Sales order issue inventory transaction populates this value by reading this from the shipping details table. | ||
CUSTOMER_PARTY_TYPE | VARCHAR2 | 30 | The party type of the customer. It could be an Organization Party or Person Party. | ||
CUSTOMER_SITE_PARTY_ID | NUMBER | 18 | The ship to party identifier captured at ths shiment transaction. | ||
CUSTOMER_SITE_ID | NUMBER | 18 | Customer Site Identifier. This is the ship to party site id of the customer that bought the customer asset. | ||
CUSTOMER_BILLING_PARTY_ID | NUMBER | 18 | The billing party that bought the asset. | ||
CUST_BILLING_PARTY_SITE_ID | NUMBER | 18 | Customer Billing Party Site Identifier captured for the Customer Asset. | ||
CUSTOMER_ACCOUNT_ID | NUMBER | 18 | The billing customer account identifier. | ||
CUSTOMER_ACCOUNT_SITE_ID | NUMBER | 18 | The customer account site identifier. | ||
CUST_ACCOUNT_SITE_USE_ID | NUMBER | 18 | Customer Account Site Use Identifier for the Customer Asset. | ||
SUPPLIER_ID | NUMBER | 18 | Supplier Identifier. The supplier from whom the asset was purchased. | ||
SUPPLIER_SITE_ID | NUMBER | 18 | Supplier Site Identifier. The primary key of the supplier site. | ||
NEW_WO_ALLOWED_FLAG | VARCHAR2 | 1 | This flag denotes whether the asset is maintainable or not. When the asset is not maintainable (New WO Allowed Flag = 'N'), a new work order cannot be created for the asset. | ||
DFLT_WO_TYPE | VARCHAR2 | 30 | The work order type captured at the asset for the purpose of defaulting in the work order when created. | ||
DFLT_WO_SUB_TYPE | VARCHAR2 | 30 | The work order sub type captured at the asset for the purpose of defaulting in the work order when created. | ||
MAINTAINABLE_FLAG | VARCHAR2 | 1 | Flag indicating whether the asset is used to drive maintenance management functions. | ||
OWNED_BY | VARCHAR2 | 1 | Who is the owner of the asset. Values are 'E' for Enterprise and 'C' for Customer. | ||
USED_BY | VARCHAR2 | 1 | Who is the user of the asset. Values are 'E' for Enterprise and 'C' for Customer. | ||
LOGICAL_FLAG | VARCHAR2 | 1 | Flag to indicate if this asset is for the purpose of logically grouping the tangible or software assets underneath the option class or model to project a sales view of the asset tree. More specifically to present the "As Sold" view. | ||
REGISTRATION_DATE | DATE | Date when the asset is registered as a customer asset. | |||
SPLIT_FROM_ASSET_ID | NUMBER | 18 | For non serial assets, when assets are split during partial return, the new asset created with the remaining quantity will have the split from asset reference. | ||
MERGED_TO_ASSET_ID | NUMBER | 18 | Asset that this Transacted Asset is merging to. | ||
CASCADED_FROM_ASSET_ID | NUMBER | 18 | The parent asset from which the location information is cascaded from. | ||
RETURNED_FROM_PARENT_ASSET_ID | NUMBER | 18 | The parent asset refernce is captured and is stored here when the rma receipt happens for the component. This will be used to rebuild the configuration upon shipment of the replacement. This column is used only for staged transactions. | ||
ACTUAL_RETURNED_ASSET_ID | NUMBER | 18 | The actual asset that was returned for the staged inbound transaction. Used for component replacement functionality from service logistics. | ||
ACTUAL_SHIPPED_ASSET_ID | NUMBER | 18 | The actual asset that was shipped for the staged outbound transaction. Used for component replacement functionality from service logistics. | ||
SHIPMENT_ID | NUMBER | 18 | From Outbound Shipments, the delivery_id is captured in this. From Inbound Receipts, the shipment_lind_id is captured here. This is an internal column used for processing. | ||
EXTERNAL_LOCATION | VARCHAR2 | 240 | An external location which is defined in the third party system and is not a defined location either in TCA or HR fusion system is captured in this column. A free format non translatable value is captured. | ||
CURRENCY_CODE | VARCHAR2 | 15 | currency code for the extensibility | ||
CORP_CURRENCY_CODE | VARCHAR2 | 15 | corporate currency code for extensibility | ||
CURCY_CONV_RATE_TYPE | VARCHAR2 | 30 | currency conversion rate type for extensibility | ||
IOT_ENABLED_FLAG | VARCHAR2 | 1 | This flag indicates whether the asset is enabled to be synced to the IOT application. IOT enabled assets will be automatically synced to the IOT application when the SCM cloud env is wired to the native Oracle Asset Monitoring IOT app. | ||
BOM_EXPLOSION_FLAG | VARCHAR2 | 1 | This flag indicates whether this root asset is exploded to create the component assets using the primary item structure of the item at the root asset. This flag is only applicable at the root asset. | ||
COMPONENT_SEQUENCE_ID | NUMBER | 18 | The Bill Of Material Compenent Sequence Identifier. This will be populated when component assets are created using a bom explosion. | ||
QUANTITY_PER_ASSEMBLY | NUMBER | When this asset is created as a component asset as part of BOM explosion, the quantity per assembly from the item structure is captured here. Asset will be created with the extended quantity for the item structure component. | |||
EXT_SYSTEM_PACKING_UNIT | VARCHAR2 | 150 | The external system packing unit. | ||
DESCRIPTION_ASSET_FLAG | VARCHAR2 | 1 | Flag indicating whether the asset created is based just on the description and not an item or product. It is a free format way of defining an asset by not associating it to a product. | ||
COMPETITOR_ASSET_FLAG | VARCHAR2 | 1 | Flag indicating that this asset is created in the repository just as a competitor asset to aid in the cross selling and up selling functional flows in CRM. | ||
RETURN_ORDER_ID | NUMBER | 18 | The return order header identifier. Populated internally by the rma receiving transaction. | ||
RETURN_ORDER_LINE_ID | NUMBER | 18 | The return order line identifier. Populated internally by the rma receiving transaction. | ||
RETURN_ORDER_FULFILL_LINE_ID | NUMBER | 18 | The return order fulfillment line identifier. Populated internally by the rma receiving transaction. | ||
ASSET_QTY | NUMBER | Asset Quantity. This is an interim column used in the processing logic. | |||
SPLIT_FROM_GTT_ASSET_ID | NUMBER | 18 | The split from asset id that is recorded in the interim session based processing. | ||
ACTION_CODE | VARCHAR2 | 120 | The action code as identified by the preprocessor. | ||
SERIAL_CONTROL_CODE | NUMBER | The serial control policy of the item, denormalized here for processing. | |||
LOT_CONTROL_CODE | NUMBER | The lot control policy of the item, denormalized here for processing. | |||
ITEM_SUB_TYPE_CODE | VARCHAR2 | 120 | The item sub type code as derived by the fulfillment engine. | ||
LINE_TYPE_CODE | VARCHAR2 | 120 | The sales order line type code to identify if the sales order is outbound or inbound. | ||
SRC_DEST_TYPE_CODE | VARCHAR2 | 1 | The flag indicating whether the temp asset is used as a source asset or destination asset. | ||
FOREIGNKEY_GTT_ASSET_ID | NUMBER | 18 | A reference to another asset that is being processed in this session. | ||
CONFIG_INVENTORY_ITEM_ID | NUMBER | 18 | Configured Item's identifier. | ||
MATCH_FOUND | VARCHAR2 | 1 | This flag indicates whether a match is found already or not. | ||
SHIPMENT_NUMBER | VARCHAR2 | 30 | The shipment number that is used as the handle in the movement of products from one organization to another using an intransit stop. | ||
TRANSACTED_ASSET_ID | NUMBER | 18 | The foriegn key to the intersection entity cse_transacted_assets. This entity is a many to many entity that links transactions and assets. | ||
EVENT_RAISED_FLAG | VARCHAR2 | 1 | Flag indicating whether an asset event was raised or not. | ||
CONFIGURATOR_PATH | VARCHAR2 | 2000 | Configurator runtime representation of the Inventory Item Id path to the component. Path format is "." Separated inventory item id. For multi-instantiable components instances are denoted by [<instance number>]. | ||
CONFIG_HEADER_ID | NUMBER | 18 | Header identifier of the configuration. | ||
CONFIG_REVISION_NUMBER | NUMBER | 18 | Revision number of the configuration. | ||
CRITICALITY_CODE | VARCHAR2 | 30 | The criticality of the asset. Maintenance activities and performance metrics are defined based on the criticality of the asset. | ||
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of manufacture used to stripe Inventory transactions | ||
INV_PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe Inventory transactions | Active | |
INV_TASK_ID | NUMBER | 18 | Identifier of the task used to stripe Inventory transactions | Active | |
INV_STRIPING_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for Inventory striping attributes | ||
INV_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality | ||
INV_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality | ||
INV_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
INV_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
INV_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
INV_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
INV_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
INV_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
INV_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
INV_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
INV_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
INV_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CSE_ASSETS_GT_N01 | Non Unique | GTT_TXN_ID |