1. Tables and Views for SCM
  2. EGP_ITEM_ORG_ASSOCIATIONS

EGP_ITEM_ORG_ASSOCIATIONS

Storage for Item and Organization Associations.

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

EGP_ITEM_ORG_ASSOCIATIONS_PK

ORGANIZATION_ID, INVENTORY_ITEM_ID

Columns

Name Datatype Length Precision Not-null Comments Status
INVENTORY_ITEM_ID NUMBER 18 Yes Attribute indicating the unique identifier of the item.
ORGANIZATION_ID NUMBER 18 Yes A organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting.
INVENTORY_ORGANIZATION_ID NUMBER 18 An Organization that tracks inventory transactions and balances, and/or that manufactures or distributes products. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes 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. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
ITEM_DEFINITION_ORG_ID NUMBER 18 Indicates which organization serves as the definition for all items in this organization. If self-referential, it is a definition organization. If it points to any other organization, it is a reference organization.
PUBLIC_FLAG VARCHAR2 1 This column indicates whether an item is public or private.
CHANGE_ROW_FLAG VARCHAR2 1 Yes This column indicates whether an item is prod or change row.

Foreign Keys

Table Foreign Table Foreign Key Column
inv_cc_entries_interface egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
inv_cycle_count_entries egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
mkl_dm_deal_prods egp_item_org_associations INVENTORY_ITEM_ID, INV_ORG_ID
inv_lpn_interface egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
zbs_referable_products egp_item_org_associations INVENTORY_ITEM_ID, INVENTORY_ORG_ID
mkt_tm_trmt_item_assoc egp_item_org_associations INVENTORY_ITEM_ID, INV_ORG_ID
zsp_product_groups egp_item_org_associations INVENTORY_ITEM_ID, INVENTORY_ORG_ID
inv_reservations_interface egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
inv_serial_numbers egp_item_org_associations INVENTORY_ITEM_ID, CURRENT_ORGANIZATION_ID
inv_license_plate_numbers egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
inv_item_loc_defaults egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
wsh_container_items egp_item_org_associations CONTAINER_ITEM_ID, MASTER_ORGANIZATION_ID
wsh_container_items egp_item_org_associations LOAD_ITEM_ID, MASTER_ORGANIZATION_ID
mkl_wsa_user_profiles egp_item_org_associations INVENTORY_ITEM_ID, INV_ORG_ID
inv_abc_compiles egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
inv_supply egp_item_org_associations ITEM_ID, TO_ORGANIZATION_ID
inv_reservations egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
mkl_lead_items_assoc egp_item_org_associations INVENTORY_ITEM_ID, INV_ORG_ID
zsf_fcst_item_detail egp_item_org_associations INVENTORY_ITEM_ID, INVENTORY_ORG_ID
inv_lot_item_controls egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
moo_revn_snapshots egp_item_org_associations INVENTORY_ITEM_ID, INVENTORY_ORG_ID
moo_revn egp_item_org_associations INVENTORY_ITEM_ID, INVENTORY_ORG_ID
inv_lpn_contents egp_item_org_associations LPN_CONTENT_ID, ORGANIZATION_ID
inv_consumption_rules egp_item_org_associations INVENTORY_ITEM_ID, FROM_ORGANIZATION_ID
inv_lot_numbers egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
loy_mem_vchr egp_item_org_associations PROD_ID, INV_ORG_ID
loy_txn egp_item_org_associations PROD_ID, INV_ORG_ID
qsc_prod_group_items egp_item_org_associations INVENTORY_ITEM_ID, INV_ORG_ID
inv_uom_usages egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
inv_transactions_interface egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
inv_txn_request_lines egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
loy_rdm_prod egp_item_org_associations PROD_ID, INV_ORG_ID
inv_item_sub_inventories egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
inv_physical_adjustments egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
inv_physical_inventory_tags egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
mkt_rm_resp_item_assoc egp_item_org_associations INVENTORY_ITEM_ID, INV_ORG_ID
inv_material_txns_temp egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
inv_pick_confirm_int egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID

Indexes

Index Uniqueness Tablespace Columns Status
EGP_ITEM_ORG_ASSOCATION_N3 Non Unique Default INVENTORY_ITEM_ID, DECODE("INVENTORY_ORGANIZATION_ID","ITEM_DEFINITION_ORG_ID","ORGANIZATION_ID","ITEM_DEFINITION_ORG_ID")
EGP_ITEM_ORG_ASSOCIATIONS_N1 Non Unique Default INVENTORY_ITEM_ID, INVENTORY_ORGANIZATION_ID
EGP_ITEM_ORG_ASSOCIATIONS_U1 Unique FUSION_TS_TX_IDX INVENTORY_ITEM_ID, ORGANIZATION_ID Obsolete
EGP_ITEM_ORG_ASSOCS_N2 Non Unique Default INVENTORY_ITEM_ID, ITEM_DEFINITION_ORG_ID
EGP_ITEM_ORG_ASSOC_N4 Non Unique Default ORGANIZATION_ID, DECODE("ORGANIZATION_ID","INVENTORY_ORGANIZATION_ID",1,0) Obsolete
EGP_ITEM_ORG_ASSOC_U2 Unique Default ORGANIZATION_ID, INVENTORY_ITEM_ID