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

Object Details

Object Name:	GME_RESOURCE_TXNS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GME.GME_RESOURCE_TXNS_V
Subobject Name:
Status:	VALID

View Type

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

This view is used to retrieve Resource transaction for ERES event XML generation

[View Source]

Columns

Name	Datatype	Length	Comments
POC_TRANS_ID	NUMBER	(10)	Key identifying a POC transaction.
ORGN_CODE	VARCHAR2	(3)	Organization Code
DOC_TYPE	VARCHAR2	(4)	Type of document that created the POC transaction.FPO - Firm Planned Order
DOC_ID	NUMBER	(10)	Surrogate key of the document that created the POC transaction
LINE_TYPE	NUMBER	(5)	Type of line. Batch step line.
LINE_ID	NUMBER	(10)	Surrogate key of the document line that created the POC transaction. FK to GME_BATCH_STEP_RESOURCES.
RESOURCES	VARCHAR2	(16)	Resource used in the transaction
RESOURCE_USAGE	NUMBER		Quantity of the resource used
TRANS_DATE	DATE		Date of the POC transaction. GL uses this date to determine the period to post the resource cost.
TRANS_DATE_DT	VARCHAR2	(4000)	Transaction Date in User display format
COMPLETED_IND	NUMBER	(5)	Completed indicator. 0 = Pending, 1 = Completed.
EVENT_ID	NUMBER	(10)	Event id. FK to GME_BATCH_HISTORY
POSTED_IND	NUMBER	(5)	Posted indicator. 0 = Not posted 1 = Posted
OVERRIDED_PROTECTED_IND	VARCHAR2	(1)	N - Default; Cannot override values entered.Y - Allows values to be overridden.
REASON_ID	NUMBER		Reason code associated with the POC transaction
REASON_NAME	VARCHAR2	(30)	Reason Name associated with the POC transaction
START_DATE	DATE		Date/time the POC transaction started. Beginning of the resource transaction, needs to fall within the start date of the resources it is associated, GME_BATCH_RESOURCES
END_DATE	DATE		Date/time the POC transaction ended. End of the resource transaction, needs to fall within the end date of the resources it is associated, GME_BATCH_RESOURCES
START_DATE_DT	VARCHAR2	(4000)	Start Date in user display format
END_DATE_DT	VARCHAR2	(4000)	end date in user display format
INSTANCE_ID	NUMBER	(15)	Record the instance that was used for the usage
ORGANIZATION_ID	NUMBER	(10)	To identify the organization (Plant /Lab)
TRANS_QTY_UM	VARCHAR2	(4)	Transaction usage UOM

Query Text

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


SELECT POC_TRANS_ID
,      ORGN_CODE
,      DOC_TYPE
,      DOC_ID
,      LINE_TYPE
,      LINE_ID
,      RESOURCES
,      RESOURCE_USAGE
,      TRANS_DATE
,      TRANS_DATE_DT
,      COMPLETED_IND
,      EVENT_ID
,      POSTED_IND
,      OVERRIDED_PROTECTED_IND
,      REASON_ID
,      REASON_NAME
,      START_DATE
,      END_DATE
,      START_DATE_DT
,      END_DATE_DT
,      INSTANCE_ID
,      ORGANIZATION_ID
,      TRANS_QTY_UM
FROM APPS.GME_RESOURCE_TXNS_V;

Dependencies

[top of page]

APPS.GME_RESOURCE_TXNS_V references the following:

APPS: FND_DATE - show dependent code; FND_TIMEZONES - show dependent code; GME_RESOURCE_TXNS; GME_RESOURCE_TXNS_GTMP; MTL_PARAMETERS; MTL_TRANSACTION_REASONS

APPS.GME_RESOURCE_TXNS_V is not referenced by any database object