eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JA.JAI_CMN_INVENTORY_ORGS

Object Details

Object Name:	JAI_CMN_INVENTORY_ORGS
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_CMN_INVENTORY_ORGS
Subobject Name:
Status:	VALID

Setup table, which stores information of Organizations/Locations, EC Code and also Accounting Information for Localization.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_INVENTORY_ORGS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORG_UNIT_ID
JAI_CMN_INVENTORY_ORGS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
JAI_CMN_INVENTORY_ORGS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_UNIT_ID	NUMBER	(15)	Yes	Indicates a Unique Field for each Record.
ORGANIZATION_ID	NUMBER	(15)	Yes	Organization Identifier.
LOCATION_ID	NUMBER	(15)	Yes	Location Identifier.
SCRAP_COST_ACCOUNT_ID	NUMBER	(15)		Indicates the Scrap Cost Account Identifier.
EXCISE_RETURN_DAYS	NUMBER	(15)		Indicates the Days for Excise Return.
EXCISE_DUTY_REGION	VARCHAR2	(50)		Indicates the Excise Duty Region for Manufacturing Organization.
EXCISE_DUTY_ZONE	VARCHAR2	(50)		Indicates the Excise Duty Zone for Manufacturing Organization.
EXCISE_DUTY_REG_NO	VARCHAR2	(50)		Indicates the Excise Duty Registration No for Manufacturing Organization.
EXCISE_DUTY_RANGE	VARCHAR2	(50)		Indicates the Excise Duty Range for Manufacturing Organization.
EXCISE_DUTY_DIVISION	VARCHAR2	(50)		Indicates the Excise Duty Division for Manufacturing Organization.
EXCISE_DUTY_CIRCLE	VARCHAR2	(50)		Indicates the Excise Duty Circle for Manufacturing Organization.
EXCISE_DUTY_COMM	VARCHAR2	(50)		Indicates the Excise Duty Commissionerate for Manufacturing Organization.
EC_CODE	VARCHAR2	(50)		Indicates the EC Code for Manufacturing Organization.
ST_REG_NO	VARCHAR2	(50)		Indicates the Sales Tax Registration No for the Organization.
CST_REG_NO	VARCHAR2	(50)		Indicates the Central Sales Tax Registration No for the Organization.
EXCISE_EXPENSE_ACCOUNT	NUMBER	(15)		Indicates the Excise Expense Account.
EXCISE_PAID_ACCOUNT	NUMBER	(15)		Indicates the Excise Paid Account.
EXCISE_RCVBLE_ACCOUNT	NUMBER	(15)		Indicates the Excise Receivable Account.
PAN_NO	VARCHAR2	(30)		Indicates the Permanent Account Number of the Organization.
TAN_NO	VARCHAR2	(30)		Indicates the Tax Account Number of the Organization.
WARD_NO	VARCHAR2	(50)		Indicates the Ward Number of the Organization.
MODVAT_RM_ACCOUNT_ID	NUMBER	(15)		Indicates the Modvat (Raw Materials) Account Identifier.
MODVAT_CG_ACCOUNT_ID	NUMBER	(15)		Indicates the Modvat (Capital Goods) Account Identifier.
MODVAT_PLA_ACCOUNT_ID	NUMBER	(15)		Indicates the Modvat (PLA) Account Identifier.
BOE_ACCOUNT_ID	NUMBER	(15)		Indicates the Bill of Entry Account Identifier.
PREF_RG23A	NUMBER	(9)		The Preference for RG23A Register (Possible Values 1,2,3,Null).
PREF_RG23C	NUMBER	(9)		The Preference for RG23C Register (Possible Values 1,2,3,Null).
PREF_PLA	NUMBER	(9)		The Preference for PLA Register (Possible Values 1,2,3,Null).
OSP_RETURN_DAYS	NUMBER	(15)		Indicates the Days before which the Material is to be Returned for Outside Processing.
OSP_EXCISE_PERCENT	NUMBER			Indicates the Excise Percent for the Outside Processing Transaction.
SALES_RETURN_DAYS	NUMBER	(15)		Indicates the Days for the Sales Return.
RECEIPT_MODIFY_FLAG	VARCHAR2	(1)		Indicates whether the Receipt Created in this Organization can be Modified or not(Possible Values Y and N).
SSI_UNIT_FLAG	VARCHAR2	(1)		This column is being used for tracking allow negative PLA flag.
DAYS_ALLOWED_173L	NUMBER	(15)		Indicates the Days Allowed for 173L.
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
TR_EXCISE_DUTY_REGION	VARCHAR2	(50)		Indicates the Excise Region for Trading Organization.
TR_EXCISE_DUTY_ZONE	VARCHAR2	(50)		Indicates the Excise Zone for Trading Organization.
TR_EXCISE_DUTY_REG_NO	VARCHAR2	(50)		Indicates the Excise Registration Number for Trading Organization.
TR_EXCISE_DUTY_RANGE	VARCHAR2	(50)		Indicates the Excise Range for Trading Organization.
TR_EXCISE_DUTY_DIVISION	VARCHAR2	(50)		Indicates the Excise Division for Trading Organization.
TR_EXCISE_DUTY_CIRCLE	VARCHAR2	(50)		Indicates the Excise Circle for Trading Organization.
TR_EXCISE_DUTY_COMM	VARCHAR2	(50)		Indicates the Excise Commissionerate for Trading Organization.
TR_EC_CODE	VARCHAR2	(50)		Indicates the EC code for Trading Organization.
TRADING	VARCHAR2	(2)		Indicates whether it is a Trading Organization(Possible Values Y,N or Null).
MANUFACTURING	VARCHAR2	(2)		Indicates whether it is a Manufacturing Organization(Possible Values Y,N or Null).
EXCISE_23D_ACCOUNT	NUMBER	(15)		Indicates the RG23D Account.
MODVAT_REVERSE_ACCOUNT_ID	NUMBER	(15)		Indicates the Modvat Reversal Account Identifier.
MODVAT_REVERSE_PERCENT	NUMBER	(15)		Indicates the Modvat Reverse Percent.
CUSTOMS_WRITE_OFF_ACCOUNT	NUMBER	(15)		Customs Write Off Account.
CENVAT_RCVBLE_ACCOUNT	NUMBER	(15)		Cenvat Receivable Account.
MASTER_ORG_FLAG	VARCHAR2	(1)		Master Org Flag(Possible Values Y and N).
MASTER_ORGANIZATION_ID	NUMBER	(15)		Master Organization Identifier.
RTV_ACCOUNT_FLAG	VARCHAR2	(1)		RTV Account Flag(Possible Values Y and N).
RTV_EXPENSE_ACCOUNT_ID	NUMBER	(15)		RTV Expense Account Identifier.
COST_FLAG	VARCHAR2	(1)		Cost Flag (Possible Values Y and N).
EXPORT_ORIENTED_UNIT	VARCHAR2	(2)		Indicates whether the Organization-Location Combination is an Export Oriented Unit (Possible Values Y and N).
EXCISE_INVNO_AT_EC_CODE	VARCHAR2	(2)		Indicates whether Excise Invoice Number is to be Generated at EC Code Level(Possible Values Y and N).
VAT_REG_NO	VARCHAR2	(50)		VAT Registration Number of the Organization.
CURRENT_NUMBER	NUMBER			The Current Number for VAT Invoice Number.
JUMP_BY	NUMBER			The Increment Number for VAT Invoice Number.
PREFIX	VARCHAR2	(50)		The Prefix for VAT Invoice Number.
EXCISE_IN_RG23D	VARCHAR2	(2)		Indicates whether Excise needs to be added to Inventory cost or should be accounted. (Possible Values are Y and N)
ORDER_PRICE_EXCISE_INCLUSIVE	VARCHAR2	(2)		Indicates whether Order Price includes the excise type of taxes
RG_ROUNDING_ACCOUNT_ID	NUMBER	(15)		RG Rounding account identifier
CESS_PAID_PAYABLE_ACCOUNT_ID	NUMBER	(15)		Indicates the Cess Account
EXCISE_EDU_CESS_RM_ACCOUNT	NUMBER	(15)		Excise Education Cess account for RM Items
EXCISE_EDU_CESS_CG_ACCOUNT	NUMBER	(15)		Excise Education Cess account for CG Items
EXCISE_EDU_CESS_RCVBLE_ACCNT	NUMBER	(15)		Intermediate account for Excise amount incase of CG items and ISO cases
EXCISE_EDU_CESS_RND_ACCNT	NUMBER	(15)		Indicates the Rounding account for Excise
DEFAULT_LOCATION_BILL_ONLY	NUMBER			Location Used for AR Invoice created through Bill Only work flow
TAX_CHANGE_ON_OPEN_INT_RECPTS	VARCHAR2	(2)		If value is "Y", taxes will be allowed to changed on receipts imported through Receipts Open Interface. If "N", taxes will not be allowed to change
TAX_CHANGE_ON_WMS_RECPTS	VARCHAR2	(2)		If value is "Y", taxes will be allowed to changed on receipts created from Warehouse Management. If "N", taxes will not be allowed to change
VAT_RETURN_DAYS	NUMBER	(15)		RMA Credit can be availed only if it happened before this many number of days after shipment
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
DSPTCH_EXCEED_ORG_QTY_FLAG	VARCHAR2	(1)		Flag which indicates whether dispatch quantity can exceed original quantity
QUANTITY_REGISTER_UPDATE_EVENT	VARCHAR2	(30)		Indicates the event when quantity register should be updated
SH_CESS_CG_ACCOUNT_ID	NUMBER			Indicates the SH Cess accounting code combination identifier for Capital Goods
SH_CESS_PAID_PAYABLE_ACCT_ID	NUMBER			Indicates the SH Cess payable accounting code combination identifier
SH_CESS_RCVBLE_ACCT_ID	NUMBER			Indicates the SH Cess receivable accounting code combination identifier
SH_CESS_RM_ACCOUNT	NUMBER			Indicates the SH Cess accounting code combination identifier for Raw Materials
SH_CESS_RND_ACCOUNT_ID	NUMBER			Indicates the SH Cess rounding accounting code combination identifier

Query Text

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


SELECT ORG_UNIT_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      SCRAP_COST_ACCOUNT_ID
,      EXCISE_RETURN_DAYS
,      EXCISE_DUTY_REGION
,      EXCISE_DUTY_ZONE
,      EXCISE_DUTY_REG_NO
,      EXCISE_DUTY_RANGE
,      EXCISE_DUTY_DIVISION
,      EXCISE_DUTY_CIRCLE
,      EXCISE_DUTY_COMM
,      EC_CODE
,      ST_REG_NO
,      CST_REG_NO
,      EXCISE_EXPENSE_ACCOUNT
,      EXCISE_PAID_ACCOUNT
,      EXCISE_RCVBLE_ACCOUNT
,      PAN_NO
,      TAN_NO
,      WARD_NO
,      MODVAT_RM_ACCOUNT_ID
,      MODVAT_CG_ACCOUNT_ID
,      MODVAT_PLA_ACCOUNT_ID
,      BOE_ACCOUNT_ID
,      PREF_RG23A
,      PREF_RG23C
,      PREF_PLA
,      OSP_RETURN_DAYS
,      OSP_EXCISE_PERCENT
,      SALES_RETURN_DAYS
,      RECEIPT_MODIFY_FLAG
,      SSI_UNIT_FLAG
,      DAYS_ALLOWED_173L
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TR_EXCISE_DUTY_REGION
,      TR_EXCISE_DUTY_ZONE
,      TR_EXCISE_DUTY_REG_NO
,      TR_EXCISE_DUTY_RANGE
,      TR_EXCISE_DUTY_DIVISION
,      TR_EXCISE_DUTY_CIRCLE
,      TR_EXCISE_DUTY_COMM
,      TR_EC_CODE
,      TRADING
,      MANUFACTURING
,      EXCISE_23D_ACCOUNT
,      MODVAT_REVERSE_ACCOUNT_ID
,      MODVAT_REVERSE_PERCENT
,      CUSTOMS_WRITE_OFF_ACCOUNT
,      CENVAT_RCVBLE_ACCOUNT
,      MASTER_ORG_FLAG
,      MASTER_ORGANIZATION_ID
,      RTV_ACCOUNT_FLAG
,      RTV_EXPENSE_ACCOUNT_ID
,      COST_FLAG
,      EXPORT_ORIENTED_UNIT
,      EXCISE_INVNO_AT_EC_CODE
,      VAT_REG_NO
,      CURRENT_NUMBER
,      JUMP_BY
,      PREFIX
,      EXCISE_IN_RG23D
,      ORDER_PRICE_EXCISE_INCLUSIVE
,      RG_ROUNDING_ACCOUNT_ID
,      CESS_PAID_PAYABLE_ACCOUNT_ID
,      EXCISE_EDU_CESS_RM_ACCOUNT
,      EXCISE_EDU_CESS_CG_ACCOUNT
,      EXCISE_EDU_CESS_RCVBLE_ACCNT
,      EXCISE_EDU_CESS_RND_ACCNT
,      DEFAULT_LOCATION_BILL_ONLY
,      TAX_CHANGE_ON_OPEN_INT_RECPTS
,      TAX_CHANGE_ON_WMS_RECPTS
,      VAT_RETURN_DAYS
,      OBJECT_VERSION_NUMBER
,      DSPTCH_EXCEED_ORG_QTY_FLAG
,      QUANTITY_REGISTER_UPDATE_EVENT
,      SH_CESS_CG_ACCOUNT_ID
,      SH_CESS_PAID_PAYABLE_ACCT_ID
,      SH_CESS_RCVBLE_ACCT_ID
,      SH_CESS_RM_ACCOUNT
,      SH_CESS_RND_ACCOUNT_ID
FROM JA.JAI_CMN_INVENTORY_ORGS;

Dependencies

[top of page]

JA.JAI_CMN_INVENTORY_ORGS does not reference any database object

JA.JAI_CMN_INVENTORY_ORGS is referenced by following:

APPS: JAI_CMN_INVENTORY_ORGS