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: APPS.GL_SUBR_TST_VW

Object Details

Object Name:	GL_SUBR_TST_VW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.GL_SUBR_TST_VW
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

OBSOLETE:GL Subsidiary Ledger Test View

[View Source]

Columns

Name	Datatype	Length	Comments
SOURCE	NUMBER		OBSOLETE deprecated
SUBLEDGER_ID	NUMBER		OBSOLETE deprecated
CO_CODE	VARCHAR2	(4)	OBSOLETE deprecated
FISCAL_YEAR	NUMBER		OBSOLETE deprecated
PERIOD	NUMBER		OBSOLETE deprecated
SUB_EVENT_CODE	VARCHAR2	(4)	OBSOLETE deprecated
VOUCHER_ID	NUMBER		OBSOLETE deprecated
DOC_TYPE	VARCHAR2	(4)	OBSOLETE deprecated
DOC_ID	NUMBER		OBSOLETE deprecated
LINE_ID	NUMBER		OBSOLETE deprecated
ACCT_TTL_CODE	VARCHAR2	(4)	OBSOLETE deprecated
ACCTG_UNIT_NO	VARCHAR2	(240)	OBSOLETE deprecated
ACCT_NO	VARCHAR2	(240)	OBSOLETE deprecated
DEBIT_CREDIT_SIGN	NUMBER		OBSOLETE deprecated
ACCTG_UNIT_DESC	VARCHAR2	(70)	OBSOLETE deprecated
ACCT_DESC	VARCHAR2	(70)	OBSOLETE deprecated
AMOUNT_BASE	NUMBER		OBSOLETE deprecated
AMOUNT_TRANS	NUMBER		OBSOLETE deprecated
CURRENCY_BASE	VARCHAR2	(4)	OBSOLETE deprecated
CURRENCY_TRANS	VARCHAR2	(4)	OBSOLETE deprecated
JV_QUANTITY	NUMBER		OBSOLETE deprecated
JV_QUANTITY_UM	VARCHAR2	(4)	OBSOLETE deprecated
SUB_EVENT_DESC	VARCHAR2	(70)	OBSOLETE deprecated
TRANS_SOURCE_CODE	VARCHAR2	(4)	OBSOLETE deprecated
TRANS_SOURCE_DESC	VARCHAR2	(70)	OBSOLETE deprecated
GL_TRANS_DATE	DATE		OBSOLETE deprecated
ORGN_CODE	VARCHAR2	(16)	OBSOLETE deprecated
DOC_NO	VARCHAR2	(40)	OBSOLETE deprecated
DOC_DATE	DATE		OBSOLETE deprecated
LINE_NO	VARCHAR2	(150)	OBSOLETE deprecated
RESOURCE_ITEM_NO	VARCHAR2	(32)	OBSOLETE deprecated
RESOURCE_ITEM_NO_DESC	VARCHAR2	(240)	OBSOLETE deprecated
TRANS_DATE	DATE		OBSOLETE deprecated
WHSE_CODE	VARCHAR2	(4)	OBSOLETE deprecated
TRANS_QTY_USAGE	NUMBER		OBSOLETE deprecated
TRANS_QTY_USAGE_UM	VARCHAR2	(25)	OBSOLETE deprecated
REFERENCE_NO	NUMBER		OBSOLETE deprecated

Query Text

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


SELECT SOURCE
,      SUBLEDGER_ID
,      CO_CODE
,      FISCAL_YEAR
,      PERIOD
,      SUB_EVENT_CODE
,      VOUCHER_ID
,      DOC_TYPE
,      DOC_ID
,      LINE_ID
,      ACCT_TTL_CODE
,      ACCTG_UNIT_NO
,      ACCT_NO
,      DEBIT_CREDIT_SIGN
,      ACCTG_UNIT_DESC
,      ACCT_DESC
,      AMOUNT_BASE
,      AMOUNT_TRANS
,      CURRENCY_BASE
,      CURRENCY_TRANS
,      JV_QUANTITY
,      JV_QUANTITY_UM
,      SUB_EVENT_DESC
,      TRANS_SOURCE_CODE
,      TRANS_SOURCE_DESC
,      GL_TRANS_DATE
,      ORGN_CODE
,      DOC_NO
,      DOC_DATE
,      LINE_NO
,      RESOURCE_ITEM_NO
,      RESOURCE_ITEM_NO_DESC
,      TRANS_DATE
,      WHSE_CODE
,      TRANS_QTY_USAGE
,      TRANS_QTY_USAGE_UM
,      REFERENCE_NO
FROM APPS.GL_SUBR_TST_VW;

Dependencies

[top of page]

APPS.GL_SUBR_TST_VW references the following:

APPS: CR_RSRC_MST; GL_ACCT_MST; GL_ACCT_TTL; GL_ACCU_MST; GL_SEVT_MST; GL_SRCE_MST; GL_SUBR_TST; GME_BATCH_HEADER; GME_BATCH_STEP_RESOURCES; GME_MATERIAL_DETAILS; GMF_LOT_COST_ADJUSTMENTS; GMI_DISCRETE_TRANSFERS; GMI_DISCRETE_TRANSFER_LINES; IC_ADJS_JNL; IC_ITEM_MST; IC_JRNL_MST; IC_TRAN_CMP; IC_TRAN_PND; IC_TRAN_PND_OM_VW1; IC_WHSE_MST; IC_XFER_MST; OP_BILL_LAD; OP_ORDR_DTL; PO_RECV_DTL; PO_RECV_HDR; PO_RTRN_DTL; PO_RTRN_HDR; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS; SY_UOMS_MST

APPS.GL_SUBR_TST_VW is referenced by following:

APPS: GMF_SUBLEDGER_REPORT - show dependent code; PMITS_TEST_SUBLEDGER_V