[Home] [Help] [Dependency Information]
Object Name: | JAI_CMN_INVENTORY_ORGS# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_UNIT_ID | NUMBER | (15) | Yes | |
ORGANIZATION_ID | NUMBER | (15) | Yes | |
LOCATION_ID | NUMBER | (15) | Yes | |
SCRAP_COST_ACCOUNT_ID | NUMBER | (15) | ||
EXCISE_RETURN_DAYS | NUMBER | (15) | ||
EXCISE_DUTY_REGION | VARCHAR2 | (50) | ||
EXCISE_DUTY_ZONE | VARCHAR2 | (50) | ||
EXCISE_DUTY_REG_NO | VARCHAR2 | (50) | ||
EXCISE_DUTY_RANGE | VARCHAR2 | (50) | ||
EXCISE_DUTY_DIVISION | VARCHAR2 | (50) | ||
EXCISE_DUTY_CIRCLE | VARCHAR2 | (50) | ||
EXCISE_DUTY_COMM | VARCHAR2 | (50) | ||
EC_CODE | VARCHAR2 | (50) | ||
ST_REG_NO | VARCHAR2 | (50) | ||
CST_REG_NO | VARCHAR2 | (50) | ||
EXCISE_EXPENSE_ACCOUNT | NUMBER | (15) | ||
EXCISE_PAID_ACCOUNT | NUMBER | (15) | ||
EXCISE_RCVBLE_ACCOUNT | NUMBER | (15) | ||
PAN_NO | VARCHAR2 | (30) | ||
TAN_NO | VARCHAR2 | (30) | ||
WARD_NO | VARCHAR2 | (50) | ||
MODVAT_RM_ACCOUNT_ID | NUMBER | (15) | ||
MODVAT_CG_ACCOUNT_ID | NUMBER | (15) | ||
MODVAT_PLA_ACCOUNT_ID | NUMBER | (15) | ||
BOE_ACCOUNT_ID | NUMBER | (15) | ||
PREF_RG23A | NUMBER | (9) | ||
PREF_RG23C | NUMBER | (9) | ||
PREF_PLA | NUMBER | (9) | ||
OSP_RETURN_DAYS | NUMBER | (15) | ||
OSP_EXCISE_PERCENT | NUMBER | |||
SALES_RETURN_DAYS | NUMBER | (15) | ||
RECEIPT_MODIFY_FLAG | VARCHAR2 | (1) | ||
SSI_UNIT_FLAG | VARCHAR2 | (1) | ||
DAYS_ALLOWED_173L | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
TR_EXCISE_DUTY_REGION | VARCHAR2 | (50) | ||
TR_EXCISE_DUTY_ZONE | VARCHAR2 | (50) | ||
TR_EXCISE_DUTY_REG_NO | VARCHAR2 | (50) | ||
TR_EXCISE_DUTY_RANGE | VARCHAR2 | (50) | ||
TR_EXCISE_DUTY_DIVISION | VARCHAR2 | (50) | ||
TR_EXCISE_DUTY_CIRCLE | VARCHAR2 | (50) | ||
TR_EXCISE_DUTY_COMM | VARCHAR2 | (50) | ||
TR_EC_CODE | VARCHAR2 | (50) | ||
TRADING | VARCHAR2 | (2) | ||
MANUFACTURING | VARCHAR2 | (2) | ||
EXCISE_23D_ACCOUNT | NUMBER | (15) | ||
MODVAT_REVERSE_ACCOUNT_ID | NUMBER | (15) | ||
MODVAT_REVERSE_PERCENT | NUMBER | (15) | ||
CUSTOMS_WRITE_OFF_ACCOUNT | NUMBER | (15) | ||
CENVAT_RCVBLE_ACCOUNT | NUMBER | (15) | ||
MASTER_ORG_FLAG | VARCHAR2 | (1) | ||
MASTER_ORGANIZATION_ID | NUMBER | (15) | ||
RTV_ACCOUNT_FLAG | VARCHAR2 | (1) | ||
RTV_EXPENSE_ACCOUNT_ID | NUMBER | (15) | ||
COST_FLAG | VARCHAR2 | (1) | ||
EXPORT_ORIENTED_UNIT | VARCHAR2 | (2) | ||
EXCISE_INVNO_AT_EC_CODE | VARCHAR2 | (2) | ||
VAT_REG_NO | VARCHAR2 | (50) | ||
CURRENT_NUMBER | NUMBER | |||
JUMP_BY | NUMBER | |||
PREFIX | VARCHAR2 | (50) | ||
EXCISE_IN_RG23D | VARCHAR2 | (2) | ||
ORDER_PRICE_EXCISE_INCLUSIVE | VARCHAR2 | (2) | ||
RG_ROUNDING_ACCOUNT_ID | NUMBER | (15) | ||
CESS_PAID_PAYABLE_ACCOUNT_ID | NUMBER | (15) | ||
EXCISE_EDU_CESS_RM_ACCOUNT | NUMBER | (15) | ||
EXCISE_EDU_CESS_CG_ACCOUNT | NUMBER | (15) | ||
EXCISE_EDU_CESS_RCVBLE_ACCNT | NUMBER | (15) | ||
EXCISE_EDU_CESS_RND_ACCNT | NUMBER | (15) | ||
DEFAULT_LOCATION_BILL_ONLY | NUMBER | |||
TAX_CHANGE_ON_OPEN_INT_RECPTS | VARCHAR2 | (2) | ||
TAX_CHANGE_ON_WMS_RECPTS | VARCHAR2 | (2) | ||
VAT_RETURN_DAYS | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER | |||
DSPTCH_EXCEED_ORG_QTY_FLAG | VARCHAR2 | (1) | ||
QUANTITY_REGISTER_UPDATE_EVENT | VARCHAR2 | (30) | ||
SH_CESS_CG_ACCOUNT_ID | NUMBER | |||
SH_CESS_PAID_PAYABLE_ACCT_ID | NUMBER | |||
SH_CESS_RCVBLE_ACCT_ID | NUMBER | |||
SH_CESS_RM_ACCOUNT | NUMBER | |||
SH_CESS_RND_ACCOUNT_ID | NUMBER | |||
EXC_SHPT_WO_EXC_TAX_FLAG | VARCHAR2 | (1) | ||
ALLOW_NEGATIVE_RG_FLAG | VARCHAR2 | (1) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
CENVAT_CR_REVRSL_FLAG | VARCHAR2 | (1) |
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
, EXC_SHPT_WO_EXC_TAX_FLAG
, ALLOW_NEGATIVE_RG_FLAG
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, CENVAT_CR_REVRSL_FLAG
FROM JA.JAI_CMN_INVENTORY_ORGS#;
|
|
|