FND Design Data [Home] [Help]

Table: JAI_CMN_INVENTORY_ORGS

Product: JA - Asia/Pacific Localizations
Description: Setup table for India Org and Locations to store EC Code and accounting info.
Implementation/DBA Data: TableJA.JAI_CMN_INVENTORY_ORGS
Primary Key: JAI_CMN_INVENTORY_ORGS_PK
  1. ColumnORG_UNIT_ID
Primary Key: JAI_CMN_INVENTORY_ORGS_UK1
  1. ColumnORGANIZATION_ID
  2. ColumnLOCATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JAI_CMN_INVENTORY_ORGS FK Joins to TableHR_ALL_ORGANIZATION_UNITS JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID
JAI_CMN_INVENTORY_ORGS FK Joins to TableGL_CODE_COMBINATIONS JAI_CMN_INVENTORY_ORGS.RTV_EXPENSE_ACCOUNT_ID
JAI_CMN_INVENTORY_ORGS FK Joins to TableGL_CODE_COMBINATIONS JAI_CMN_INVENTORY_ORGS.MODVAT_REVERSE_ACCOUNT_ID
JAI_CMN_INVENTORY_ORGS FK Joins to TableHR_ALL_ORGANIZATION_UNITS JAI_CMN_INVENTORY_ORGS.MASTER_ORGANIZATION_ID
JAI_CMN_INVENTORY_ORGS FK Joins to TableHR_LOCATIONS_ALL JAI_CMN_INVENTORY_ORGS.LOCATION_ID
JAI_CMN_INVENTORY_ORGS FK Joins to TableGL_CODE_COMBINATIONS JAI_CMN_INVENTORY_ORGS.SCRAP_COST_ACCOUNT_ID
JAI_CMN_INVENTORY_ORGS FK Joins to TableGL_CODE_COMBINATIONS JAI_CMN_INVENTORY_ORGS.MODVAT_RM_ACCOUNT_ID
JAI_CMN_INVENTORY_ORGS FK Joins to TableGL_CODE_COMBINATIONS JAI_CMN_INVENTORY_ORGS.MODVAT_CG_ACCOUNT_ID
JAI_CMN_INVENTORY_ORGS FK Joins to TableGL_CODE_COMBINATIONS JAI_CMN_INVENTORY_ORGS.MODVAT_PLA_ACCOUNT_ID
JAI_CMN_INVENTORY_ORGS FK Joins to TableGL_CODE_COMBINATIONS JAI_CMN_INVENTORY_ORGS.BOE_ACCOUNT_ID
JAI_CMN_INVENTORY_ORGS FK Joins to TableGL_CODE_COMBINATIONS JAI_CMN_INVENTORY_ORGS.RG_ROUNDING_ACCOUNT_ID
JAI_CMN_INVENTORY_ORGS FK Joins to TableGL_CODE_COMBINATIONS JAI_CMN_INVENTORY_ORGS.CESS_PAID_PAYABLE_ACCOUNT_ID
TableJAI_CMN_RG_BALANCES FK Joins to JAI_CMN_INVENTORY_ORGS JAI_CMN_RG_BALANCES.ORG_UNIT_ID
TableJAI_CMN_RG_OTH_BALANCES FK Joins to JAI_CMN_INVENTORY_ORGS JAI_CMN_RG_OTH_BALANCES.ORG_UNIT_ID
TableJAI_OM_OE_BOND_REG_HDRS FK Joins to JAI_CMN_INVENTORY_ORGS JAI_OM_OE_BOND_REG_HDRS.ORGANIZATION_ID
JAI_OM_OE_BOND_REG_HDRS.LOCATION_ID
TableJAI_OM_WSH_LINES_ALL FK Joins to JAI_CMN_INVENTORY_ORGS JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID
JAI_OM_WSH_LINES_ALL.LOCATION_ID