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.

VIEW: JA.JAI_CMN_INVENTORY_ORGS#

Source

View Text - Preformatted


select ORG_UNIT_ID ORG_UNIT_ID, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, SCRAP_COST_ACCOUNT_ID SCRAP_COST_ACCOUNT_ID, EXCISE_RETURN_DAYS EXCISE_RETURN_DAYS, EXCISE_DUTY_REGION EXCISE_DUTY_REGION, EXCISE_DUTY_ZONE EXCISE_DUTY_ZONE, EXCISE_DUTY_REG_NO EXCISE_DUTY_REG_NO, EXCISE_DUTY_RANGE EXCISE_DUTY_RANGE, EXCISE_DUTY_DIVISION EXCISE_DUTY_DIVISION, EXCISE_DUTY_CIRCLE EXCISE_DUTY_CIRCLE, EXCISE_DUTY_COMM EXCISE_DUTY_COMM, EC_CODE EC_CODE, ST_REG_NO ST_REG_NO, CST_REG_NO CST_REG_NO, EXCISE_EXPENSE_ACCOUNT EXCISE_EXPENSE_ACCOUNT, EXCISE_PAID_ACCOUNT EXCISE_PAID_ACCOUNT, EXCISE_RCVBLE_ACCOUNT EXCISE_RCVBLE_ACCOUNT, PAN_NO PAN_NO, TAN_NO TAN_NO, WARD_NO WARD_NO, MODVAT_RM_ACCOUNT_ID MODVAT_RM_ACCOUNT_ID, MODVAT_CG_ACCOUNT_ID MODVAT_CG_ACCOUNT_ID, MODVAT_PLA_ACCOUNT_ID MODVAT_PLA_ACCOUNT_ID, BOE_ACCOUNT_ID BOE_ACCOUNT_ID, PREF_RG23A PREF_RG23A, PREF_RG23C PREF_RG23C, PREF_PLA PREF_PLA, OSP_RETURN_DAYS OSP_RETURN_DAYS, OSP_EXCISE_PERCENT OSP_EXCISE_PERCENT, SALES_RETURN_DAYS SALES_RETURN_DAYS, RECEIPT_MODIFY_FLAG RECEIPT_MODIFY_FLAG, SSI_UNIT_FLAG SSI_UNIT_FLAG, DAYS_ALLOWED_173L DAYS_ALLOWED_173L, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TR_EXCISE_DUTY_REGION TR_EXCISE_DUTY_REGION, TR_EXCISE_DUTY_ZONE TR_EXCISE_DUTY_ZONE, TR_EXCISE_DUTY_REG_NO TR_EXCISE_DUTY_REG_NO, TR_EXCISE_DUTY_RANGE TR_EXCISE_DUTY_RANGE, TR_EXCISE_DUTY_DIVISION TR_EXCISE_DUTY_DIVISION, TR_EXCISE_DUTY_CIRCLE TR_EXCISE_DUTY_CIRCLE, TR_EXCISE_DUTY_COMM TR_EXCISE_DUTY_COMM, TR_EC_CODE TR_EC_CODE, TRADING TRADING, MANUFACTURING MANUFACTURING, EXCISE_23D_ACCOUNT EXCISE_23D_ACCOUNT, MODVAT_REVERSE_ACCOUNT_ID MODVAT_REVERSE_ACCOUNT_ID, MODVAT_REVERSE_PERCENT MODVAT_REVERSE_PERCENT, CUSTOMS_WRITE_OFF_ACCOUNT CUSTOMS_WRITE_OFF_ACCOUNT, CENVAT_RCVBLE_ACCOUNT CENVAT_RCVBLE_ACCOUNT, MASTER_ORG_FLAG MASTER_ORG_FLAG, MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID, RTV_ACCOUNT_FLAG RTV_ACCOUNT_FLAG, RTV_EXPENSE_ACCOUNT_ID RTV_EXPENSE_ACCOUNT_ID, COST_FLAG COST_FLAG, EXPORT_ORIENTED_UNIT EXPORT_ORIENTED_UNIT, EXCISE_INVNO_AT_EC_CODE EXCISE_INVNO_AT_EC_CODE, VAT_REG_NO VAT_REG_NO, CURRENT_NUMBER CURRENT_NUMBER, JUMP_BY JUMP_BY, PREFIX PREFIX, EXCISE_IN_RG23D EXCISE_IN_RG23D, ORDER_PRICE_EXCISE_INCLUSIVE ORDER_PRICE_EXCISE_INCLUSIVE, RG_ROUNDING_ACCOUNT_ID RG_ROUNDING_ACCOUNT_ID, CESS_PAID_PAYABLE_ACCOUNT_ID CESS_PAID_PAYABLE_ACCOUNT_ID, EXCISE_EDU_CESS_RM_ACCOUNT EXCISE_EDU_CESS_RM_ACCOUNT, EXCISE_EDU_CESS_CG_ACCOUNT EXCISE_EDU_CESS_CG_ACCOUNT, EXCISE_EDU_CESS_RCVBLE_ACCNT EXCISE_EDU_CESS_RCVBLE_ACCNT, EXCISE_EDU_CESS_RND_ACCNT EXCISE_EDU_CESS_RND_ACCNT, DEFAULT_LOCATION_BILL_ONLY DEFAULT_LOCATION_BILL_ONLY, TAX_CHANGE_ON_OPEN_INT_RECPTS TAX_CHANGE_ON_OPEN_INT_RECPTS, TAX_CHANGE_ON_WMS_RECPTS TAX_CHANGE_ON_WMS_RECPTS, VAT_RETURN_DAYS VAT_RETURN_DAYS, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, DSPTCH_EXCEED_ORG_QTY_FLAG DSPTCH_EXCEED_ORG_QTY_FLAG, QUANTITY_REGISTER_UPDATE_EVENT QUANTITY_REGISTER_UPDATE_EVENT, SH_CESS_CG_ACCOUNT_ID SH_CESS_CG_ACCOUNT_ID, SH_CESS_PAID_PAYABLE_ACCT_ID SH_CESS_PAID_PAYABLE_ACCT_ID, SH_CESS_RCVBLE_ACCT_ID SH_CESS_RCVBLE_ACCT_ID, SH_CESS_RM_ACCOUNT SH_CESS_RM_ACCOUNT, SH_CESS_RND_ACCOUNT_ID SH_CESS_RND_ACCOUNT_ID, EXC_SHPT_WO_EXC_TAX_FLAG EXC_SHPT_WO_EXC_TAX_FLAG, ALLOW_NEGATIVE_RG_FLAG ALLOW_NEGATIVE_RG_FLAG, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, CENVAT_CR_REVRSL_FLAG CENVAT_CR_REVRSL_FLAG from "JA"."JAI_CMN_INVENTORY_ORGS"

View Text - HTML Formatted

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