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_LED_VW

Object Details

Object Name:	GL_SUBR_LED_VW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.GL_SUBR_LED_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 View

[View Source]

Columns

Name	Datatype	Length	Comments
SOURCE	NUMBER		source
SUBLEDGER_ID	NUMBER	(10)	Subledger Id
CO_CODE	VARCHAR2	(4)	Co Code
FISCAL_YEAR	NUMBER	(5)	Fiscal Year
PERIOD	NUMBER	(5)	Period
SUB_EVENT_CODE	VARCHAR2	(4)	Sub Event Code
VOUCHER_ID	NUMBER	(10)	Voucher Id
DOC_TYPE	VARCHAR2	(4)	Doc Type
DOC_ID	NUMBER	(10)	Doc Id
LINE_ID	NUMBER	(10)	OBSOLETE
ACCT_TTL_CODE	VARCHAR2	(4)	OBSOLETE
ACCTG_UNIT_NO	VARCHAR2	(240)	OBSOLETE
ACCT_NO	VARCHAR2	(240)	OBSOLETE
DEBIT_CREDIT_SIGN	NUMBER	(5)	OBSOLETE
ACCTG_UNIT_DESC	VARCHAR2	(70)	OBSOLETE
ACCT_DESC	VARCHAR2	(70)	OBSOLETE
AMOUNT_BASE	NUMBER		OBSOLETE
AMOUNT_TRANS	NUMBER		OBSOLETE
CURRENCY_BASE	VARCHAR2	(4)	OBSOLETE
CURRENCY_TRANS	VARCHAR2	(4)	OBSOLETE
JV_QUANTITY	NUMBER		OBSOLETE
JV_QUANTITY_UM	VARCHAR2	(4)	OBSOLETE
SUB_EVENT_DESC	VARCHAR2	(70)	OBSOLETE
TRANS_SOURCE_CODE	VARCHAR2	(4)	OBSOLETE
TRANS_SOURCE_DESC	VARCHAR2	(70)	OBSOLETE
GL_TRANS_DATE	DATE		OBSOLETE
ORGN_CODE	VARCHAR2	(16)	OBSOLETE
DOC_NO	VARCHAR2	(40)	OBSOLETE
DOC_DATE	DATE		OBSOLETE
LINE_NO	VARCHAR2	(150)	OBSOLETE
RESOURCE_ITEM_NO	VARCHAR2	(32)	OBSOLETE
RESOURCE_ITEM_NO_DESC	VARCHAR2	(70)	OBSOLETE
TRANS_DATE	DATE		OBSOLETE
WHSE_CODE	VARCHAR2	(4)	OBSOLETE
TRANS_QTY_USAGE	NUMBER		OBSOLETE
TRANS_QTY_USAGE_UM	VARCHAR2	(25)	OBSOLETE
REFERENCE_NO	NUMBER	(10)	OBSOLETE

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_LED_VW;

Dependencies

[top of page]

APPS.GL_SUBR_LED_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_LED; 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_LED_VW is referenced by following:

APPS: GMF_SUBLEDGER_REPORT - show dependent code; PMITS_FINAL_SUBLEDGER_V