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_XLA_PM_RSRC_TXNS_V

Object Details

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

View Type

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

View for SLA ADR sources from Resource Transactions

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REFERENCE_NO	NUMBER		Yes	Reference Number
LEDGER_ID	NUMBER		Yes	Ledger Identifier
TRANSACTION_ID	NUMBER		Yes	Transaction Id
EVENT_CLASS_CODE	VARCHAR2	(50)	Yes	Event Class Code
OPERATING_UNIT	NUMBER			Operating Unit
TRANSACTION_DATE	DATE		Yes	Transaction Date
PRIMARY_QUANTITY	VARCHAR2	(44)		Transaction Quantity
PRIMARY_UOM_CODE	VARCHAR2	(3)		Primary unit of measure code
SECONDARY_UOM_CODE	VARCHAR2	(3)		Secondary Unit of Measure
TRANSACTION_UOM	VARCHAR2	(50)	Yes	Transaction Unit Of Measure
VALUATION_COST_TYPE_ID	NUMBER		Yes	Valuation Cost Type Identifier
VALUATION_COST_TYPE	VARCHAR2	(50)		Valuation Cost Type Code
SOURCE_DOCUMENT_ID	NUMBER			Source Document Id
SOURCE_LINE_ID	NUMBER			Source Document Line Level Id
LEGAL_ENTITY_ID	NUMBER		Yes	Legal Entity identifier
LEGAL_ENTITY_NAME	VARCHAR2	(240)	Yes	Legal Entity Name
INVENTORY_ITEM_ID	NUMBER			Inventory Item Id
ITEM_NUMBER	VARCHAR2	(40)		Item Number
ITEM_DESCRIPTION	VARCHAR2	(240)		Item Description
ORGANIZATION_ID	NUMBER		Yes	Organization Id
BATCH_ID	NUMBER	(10)	Yes	Batch Identifier
BATCH_NUMBER	VARCHAR2	(32)	Yes	Batch Number
ORGANIZATION_CODE	VARCHAR2	(3)		Organization Code
PLANT_CODE	VARCHAR2	(3)		Plant Code
BATCH_STATUS	VARCHAR2	(80)		Batch Status (pending, closed, completed)
BATCH_ACTUAL_START_DT	DATE			Batch Actual Start Date
BATCH_ACTUAL_CMPLT_DT	DATE			Batch Actual Completion Date
FORMULA	VARCHAR2	(75)		Formula
FORMULA_DESC	VARCHAR2	(240)		Formula Description
ROUTING_NO	VARCHAR2	(75)		Routing Number
ROUTING_DESC	VARCHAR2	(240)		Routing Description
RECIPE_NO	VARCHAR2	(75)		Recipe Number
RECIPE_DESC	VARCHAR2	(240)		Recipe Description
RESOURCES	VARCHAR2	(16)	Yes	Resources
RESOURCE_USAGE	VARCHAR2	(44)		Resource Usage
COST_ANALYSIS_CODE	VARCHAR2	(32)	Yes	Cost Analysis Code
USAGE_UM	VARCHAR2	(3)		Resource Usage UOM
COST_CMPNTCLS_ID	NUMBER	(10)	Yes	Cost Cmpntcls Identifier
COST_CMPNTCLS_CODE	VARCHAR2	(32)	Yes	Cost Cmpntcls Code
COST_CMPNTCLS_DESC	VARCHAR2	(240)	Yes	Cost Cmpntcls Desc

Query Text

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


SELECT REFERENCE_NO
,      LEDGER_ID
,      TRANSACTION_ID
,      EVENT_CLASS_CODE
,      OPERATING_UNIT
,      TRANSACTION_DATE
,      PRIMARY_QUANTITY
,      PRIMARY_UOM_CODE
,      SECONDARY_UOM_CODE
,      TRANSACTION_UOM
,      VALUATION_COST_TYPE_ID
,      VALUATION_COST_TYPE
,      SOURCE_DOCUMENT_ID
,      SOURCE_LINE_ID
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      ORGANIZATION_ID
,      BATCH_ID
,      BATCH_NUMBER
,      ORGANIZATION_CODE
,      PLANT_CODE
,      BATCH_STATUS
,      BATCH_ACTUAL_START_DT
,      BATCH_ACTUAL_CMPLT_DT
,      FORMULA
,      FORMULA_DESC
,      ROUTING_NO
,      ROUTING_DESC
,      RECIPE_NO
,      RECIPE_DESC
,      RESOURCES
,      RESOURCE_USAGE
,      COST_ANALYSIS_CODE
,      USAGE_UM
,      COST_CMPNTCLS_ID
,      COST_CMPNTCLS_CODE
,      COST_CMPNTCLS_DESC
FROM APPS.GMF_XLA_PM_RSRC_TXNS_V;

Dependencies

[top of page]

APPS.GMF_XLA_PM_RSRC_TXNS_V references the following:

APPS: CM_CMPT_MST; FND_DATE - show dependent code; FND_MESSAGE - show dependent code; GME_BATCH_HEADER_VW; GME_BATCH_STEP_RESOURCES; GME_RESOURCE_TXNS; GMF_XLA_EXTRACT_HEADERS; MTL_SYSTEM_ITEMS_B_KFV; XLE_ENTITY_PROFILES

APPS.GMF_XLA_PM_RSRC_TXNS_V is not referenced by any database object