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_SO_TXNS_V

Object Details

Object Name:	GMF_XLA_SO_TXNS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.GMF_XLA_SO_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 Sales Order Transactions

[View Source]

Columns

Name	Datatype	Length	Comments
REFERENCE_NO	NUMBER		Reference Number
LEDGER_ID	NUMBER		Ledger Identifier
TRANSACTION_ID	NUMBER		Transaction Identifier
EVENT_CLASS_CODE	VARCHAR2	(50)	Event Class Code
OPERATING_UNIT	NUMBER		Operating Unit
TRANSACTION_DATE	DATE		Transaction Date
PRIMARY_QUANTITY	NUMBER		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)	Transaction Unit Of Measure
VALUATION_COST_TYPE_ID	NUMBER		Valuation Cost Type Identifier
VALUATION_COST_TYPE	VARCHAR2	(50)	Valuation Cost Type Code
LOT_NUMBER	VARCHAR2	(80)	Lot Number (for future use)
SOURCE_DOCUMENT_ID	NUMBER		Source Document Id
SOURCE_LINE_ID	NUMBER		Source Document Line Level Id
LEGAL_ENTITY_ID	NUMBER		Legal Entity Identifier
LEGAL_ENTITY_NAME	VARCHAR2	(240)	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		Organization Id
ORGANIZATION_CODE	VARCHAR2	(3)	Organization Code
ORDER_NUMBER	NUMBER		Order Number
ORDERED_DATE	DATE		Ordered Date
ORDER_STATUS_CODE	VARCHAR2	(30)	Order Status Code
ORDER_LINE_NUMBER	NUMBER		Order Line Number
ORDERED_QUANTITY	NUMBER		Ordered Quantity
UNIT_SELLING_PRICE	NUMBER		Unit Selling Price
ORDER_LINE_STATUS	VARCHAR2	(30)	Order Line Status
SHIPMENT_NUMBER	VARCHAR2	(30)	Shipment Number
CUSTOMER_NUMBER	VARCHAR2	(30)	Customer Number
CUSTOMER_NAME	VARCHAR2	(360)	Customer Name

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
,      LOT_NUMBER
,      SOURCE_DOCUMENT_ID
,      SOURCE_LINE_ID
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORDER_NUMBER
,      ORDERED_DATE
,      ORDER_STATUS_CODE
,      ORDER_LINE_NUMBER
,      ORDERED_QUANTITY
,      UNIT_SELLING_PRICE
,      ORDER_LINE_STATUS
,      SHIPMENT_NUMBER
,      CUSTOMER_NUMBER
,      CUSTOMER_NAME
FROM APPS.GMF_XLA_SO_TXNS_V;

Dependencies

[top of page]

APPS.GMF_XLA_SO_TXNS_V references the following:

APPS: GMF_XLA_EXTRACT_HEADERS; HZ_PARTIES; MTL_MATERIAL_TRANSACTIONS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_B; MTL_TRANSACTION_LOT_NUMBERS; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; RCV_TRANSACTIONS; XLE_ENTITY_PROFILES

APPS.GMF_XLA_SO_TXNS_V is not referenced by any database object