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: ViewGMF.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:

SchemaAPPS
SynonymCM_CMPT_MST
PL/SQL PackageFND_DATE - show dependent code
PL/SQL PackageFND_MESSAGE - show dependent code
ViewGME_BATCH_HEADER_VW
SynonymGME_BATCH_STEP_RESOURCES
SynonymGME_RESOURCE_TXNS
SynonymGMF_XLA_EXTRACT_HEADERS
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymXLE_ENTITY_PROFILES

APPS.GMF_XLA_PM_RSRC_TXNS_V is not referenced by any database object