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.GMF_SUBLEDGER_REP_V

Object Details

Object Name:	GMF_SUBLEDGER_REP_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

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

Subledger Report View

[View Source]

Columns

Name	Datatype	Length	Comments
REFERENCE_NO	NUMBER		Reference Number
HEADER_ID	NUMBER		Header Identifier
EVENT_ID	NUMBER		SLA Event Identifier
LEGAL_ENTITY_ID	NUMBER		Legal Entity
LEDGER_ID	NUMBER		Ledger Identifier
OPERATING_UNIT	NUMBER		Operating Unit
BASE_CURRENCY	VARCHAR2	(50)	Base Currency
VALUATION_COST_TYPE	VARCHAR2	(50)	Valuation Cost Type Code
VALUATION_COST_TYPE_ID	NUMBER		Valuation Cost Type Identifier
INVENTORY_ITEM_ID	NUMBER		Inventory Item Identifier
ORGANIZATION_ID	NUMBER		Organization Identifier
ITEM_REVISION	VARCHAR2	(3)	Inventory Item Revision
LOT_NUMBER	VARCHAR2	(80)	Lot Number (for future use)
TRANSACTION_SOURCE_TYPE_ID	NUMBER		Transaction Source Type Identifier
TRANSACTION_ACTION_ID	NUMBER		Transaction Action Identifier
TRANSACTION_TYPE_ID	NUMBER		Transaction Type Identifier
ENTITY_CODE	VARCHAR2	(50)	Entity Code
EVENT_CLASS	VARCHAR2	(50)	Event Class Code
EVENT_TYPE	VARCHAR2	(50)	Event Type Code
TRANSACTION_ID	NUMBER		Transaction Identifier from MTL_MATERIAL_TRANSACTIONS table
TRANSACTION_DATE	DATE		Transaction Date
TRANSACTION_QUANTITY	NUMBER		Transaction Quantity
TRANSACTION_UOM	VARCHAR2	(50)	Transaction Unit Of Measure
CM_ADJUSTMENT_TYPE	VARCHAR2	(23)	adjustment type
CM_ADJUST_COST	NUMBER		adjustment cost
CM_REASON_CODE	VARCHAR2	(4)	costing reason code
CM_PERIOD_CODE	VARCHAR2	(10)	costing period code
CM_CALENDAR_CODE	VARCHAR2	(10)	calendar code
CM_LOT_NUMBER	VARCHAR2	(80)	lot number
IN_SUBINVENTORY_CODE	VARCHAR2	(10)	subinventory code
PM_BATCH_NUMBER	VARCHAR2	(32)	batch number
PM_BATCH_STATUS	VARCHAR2	(80)	batch status (wip, completed, closed)
PM_ACTUAL_START_DATE	DATE		batch actual start date
PM_ACTUAL_CMPLT_DATE	DATE		batch actual completion date
PM_FORMULA_NO	VARCHAR2	(32)	batch formula number
PM_FORMULA_VERS	NUMBER		batch formula version
PM_ROUTING_NO	VARCHAR2	(32)	batch routing number
PM_ROUTING_VERS	NUMBER		batch routing version
PM_RECIPE_NO	VARCHAR2	(32)	batch recipe number
PM_RECIPE_VERSION	NUMBER		batch recipe version
PM_RESOURCES	VARCHAR2	(16)	batch resources
PO_PURCHASE_NUMBER	VARCHAR2	(30)	purchase order number
PO_SUPPLIER_NAME	VARCHAR2	(240)	supplier name
PO_RECEIPT_NUMBER	VARCHAR2	(30)	purchase order receipt number
PO_RECEIPT_LINE_NUMBER	NUMBER		purchase order receipt line number
OM_ORDER_NUMBER	NUMBER		sales order Number
OM_CUSTOMER_NUMBER	VARCHAR2	(30)	customer number
OM_CUSTOMER_NAME	VARCHAR2	(360)	customer name
OM_LINE_NUMBER	NUMBER		sales order line number
OM_SHIPMENT_NUMBER	VARCHAR2	(30)	sales order shipment number

Query Text

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


SELECT REFERENCE_NO
,      HEADER_ID
,      EVENT_ID
,      LEGAL_ENTITY_ID
,      LEDGER_ID
,      OPERATING_UNIT
,      BASE_CURRENCY
,      VALUATION_COST_TYPE
,      VALUATION_COST_TYPE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ITEM_REVISION
,      LOT_NUMBER
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_TYPE_ID
,      ENTITY_CODE
,      EVENT_CLASS
,      EVENT_TYPE
,      TRANSACTION_ID
,      TRANSACTION_DATE
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      CM_ADJUSTMENT_TYPE
,      CM_ADJUST_COST
,      CM_REASON_CODE
,      CM_PERIOD_CODE
,      CM_CALENDAR_CODE
,      CM_LOT_NUMBER
,      IN_SUBINVENTORY_CODE
,      PM_BATCH_NUMBER
,      PM_BATCH_STATUS
,      PM_ACTUAL_START_DATE
,      PM_ACTUAL_CMPLT_DATE
,      PM_FORMULA_NO
,      PM_FORMULA_VERS
,      PM_ROUTING_NO
,      PM_ROUTING_VERS
,      PM_RECIPE_NO
,      PM_RECIPE_VERSION
,      PM_RESOURCES
,      PO_PURCHASE_NUMBER
,      PO_SUPPLIER_NAME
,      PO_RECEIPT_NUMBER
,      PO_RECEIPT_LINE_NUMBER
,      OM_ORDER_NUMBER
,      OM_CUSTOMER_NUMBER
,      OM_CUSTOMER_NAME
,      OM_LINE_NUMBER
,      OM_SHIPMENT_NUMBER
FROM APPS.GMF_SUBLEDGER_REP_V;

Dependencies

[top of page]

APPS.GMF_SUBLEDGER_REP_V references the following:

APPS: AP_INVOICE_DISTRIBUTIONS_ALL; CM_ADJS_DTL; FND_DATE - show dependent code; FND_MESSAGE - show dependent code; GL_ALOC_DTL; GME_BATCH_HEADER_VW; GME_RESOURCE_TXNS; GMF_INVOICE_DISTRIBUTIONS; GMF_LOT_COST_ADJUSTMENTS; GMF_LOT_COST_ADJUSTMENT_DTLS; GMF_PERIOD_BALANCES; GMF_PERIOD_STATUSES; GMF_RCV_ACCOUNTING_TXNS; GMF_XLA_EXTRACT_HEADERS; HZ_CUST_ACCOUNTS; HZ_PARTIES; MTL_MATERIAL_TRANSACTIONS; MTL_TRANSACTION_LOT_NUMBERS; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; PO_DISTRIBUTIONS_ALL; PO_HEADERS_ALL; PO_LINES_ALL; PO_VENDORS; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS

APPS.GMF_SUBLEDGER_REP_V is not referenced by any database object