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]

VIEW: JA.JAI_CMN_RG_23D_TRXS#

Object Details

Object Name:	JAI_CMN_RG_23D_TRXS#
Object Type:	VIEW
Owner:	JA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
REGISTER_ID	NUMBER	(15)	Yes
ORGANIZATION_ID	NUMBER	(15)	Yes
LOCATION_ID	NUMBER	(15)	Yes
SLNO	NUMBER	(15)	Yes
FIN_YEAR	NUMBER	(9)	Yes
TRANSACTION_TYPE	VARCHAR2	(10)
QUANTITY_RECEIVED	NUMBER
INVENTORY_ITEM_ID	NUMBER	(15)	Yes
SUBINVENTORY	VARCHAR2	(10)
REFERENCE_LINE_ID	NUMBER	(15)
PRIMARY_UOM_CODE	VARCHAR2	(3)
TRANSACTION_UOM_CODE	VARCHAR2	(3)
CUSTOMER_ID	NUMBER	(15)
BILL_TO_SITE_ID	NUMBER	(15)
SHIP_TO_SITE_ID	NUMBER	(15)
QUANTITY_ISSUED	NUMBER
REGISTER_CODE	VARCHAR2	(30)
RELEASED_DATE	DATE
COMM_INVOICE_NO	VARCHAR2	(30)
COMM_INVOICE_DATE	DATE
RECEIPT_BOE_NUM	VARCHAR2	(150)
OTH_RECEIPT_DATE	DATE
OTH_RECEIPT_QUANTITY	NUMBER
REMARKS	VARCHAR2	(100)
QTY_TO_ADJUST	NUMBER
RATE_PER_UNIT	NUMBER
EXCISE_DUTY_RATE	NUMBER
CHARGE_ACCOUNT_ID	NUMBER	(15)
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
LAST_UPDATED_BY	NUMBER	(15)
DUTY_AMOUNT	NUMBER
RECEIPT_DATE	DATE
GOODS_ISSUE_ID	NUMBER	(15)
GOODS_ISSUE_DATE	DATE
GOODS_ISSUE_QUANTITY	NUMBER
TRANSACTION_DATE	DATE
OPENING_BALANCE_QTY	NUMBER
CLOSING_BALANCE_QTY	NUMBER
BASIC_ED	NUMBER
ADDITIONAL_ED	NUMBER
OTHER_ED	NUMBER
CVD	NUMBER
VENDOR_ID	NUMBER	(15)
VENDOR_SITE_ID	NUMBER	(15)
RECEIPT_NUM	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
CONSIGNEE	VARCHAR2	(2)
MANUFACTURER_NAME	VARCHAR2	(100)
MANUFACTURER_ADDRESS	VARCHAR2	(150)
MANUFACTURER_RATE_AMT_PER_UNIT	VARCHAR2	(50)
QTY_RECEIVED_FROM_MANUFACTURER	NUMBER
TOT_AMT_PAID_TO_MANUFACTURER	NUMBER
REF_LINE_NO	NUMBER	(4)
BOL_ID	NUMBER	(10)
BOLLINE_NO	NUMBER	(5)
OTHER_TAX_CREDIT	NUMBER
OTHER_TAX_DEBIT	NUMBER
RECEIPT_REF	NUMBER	(15)
OTH_RECEIPT_ID_REF	NUMBER	(15)
TRANSACTION_SOURCE_NUM	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER
ADDITIONAL_CVD	NUMBER

Query Text

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


SELECT REGISTER_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      SLNO
,      FIN_YEAR
,      TRANSACTION_TYPE
,      QUANTITY_RECEIVED
,      INVENTORY_ITEM_ID
,      SUBINVENTORY
,      REFERENCE_LINE_ID
,      PRIMARY_UOM_CODE
,      TRANSACTION_UOM_CODE
,      CUSTOMER_ID
,      BILL_TO_SITE_ID
,      SHIP_TO_SITE_ID
,      QUANTITY_ISSUED
,      REGISTER_CODE
,      RELEASED_DATE
,      COMM_INVOICE_NO
,      COMM_INVOICE_DATE
,      RECEIPT_BOE_NUM
,      OTH_RECEIPT_DATE
,      OTH_RECEIPT_QUANTITY
,      REMARKS
,      QTY_TO_ADJUST
,      RATE_PER_UNIT
,      EXCISE_DUTY_RATE
,      CHARGE_ACCOUNT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      DUTY_AMOUNT
,      RECEIPT_DATE
,      GOODS_ISSUE_ID
,      GOODS_ISSUE_DATE
,      GOODS_ISSUE_QUANTITY
,      TRANSACTION_DATE
,      OPENING_BALANCE_QTY
,      CLOSING_BALANCE_QTY
,      BASIC_ED
,      ADDITIONAL_ED
,      OTHER_ED
,      CVD
,      VENDOR_ID
,      VENDOR_SITE_ID
,      RECEIPT_NUM
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      CONSIGNEE
,      MANUFACTURER_NAME
,      MANUFACTURER_ADDRESS
,      MANUFACTURER_RATE_AMT_PER_UNIT
,      QTY_RECEIVED_FROM_MANUFACTURER
,      TOT_AMT_PAID_TO_MANUFACTURER
,      REF_LINE_NO
,      BOL_ID
,      BOLLINE_NO
,      OTHER_TAX_CREDIT
,      OTHER_TAX_DEBIT
,      RECEIPT_REF
,      OTH_RECEIPT_ID_REF
,      TRANSACTION_SOURCE_NUM
,      OBJECT_VERSION_NUMBER
,      ADDITIONAL_CVD
FROM JA.JAI_CMN_RG_23D_TRXS#;

Dependencies

[top of page]

JA.JAI_CMN_RG_23D_TRXS# references the following:

JA: JAI_CMN_RG_23D_TRXS

JA.JAI_CMN_RG_23D_TRXS# is referenced by following:

APPS: JAI_CMN_RG_23D_TRXS