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

Object Details

Object Name:	PMI_REP_SALES_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMI_REP_SALES_DETAILS_V
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

PMI Sales Details Report view

[View Source]

Columns

Name	Datatype	Length	Comments
ITEM_ID	NUMBER	(10)	Item ID
ORDER_QUANTITY	NUMBER		Order Quantity
WAREHOUSE_SHIPPED_FROM	VARCHAR2	(4)	Warehouse Shipped From
EXTENDED_PRICE_BASE_CURRENCY	NUMBER		Extended Price Base Currency
CHARGES_BASE_CURRENCY	NUMBER		Charges in Base Currency
SALES_COMPANY	VARCHAR2	(4)	Sales Company
SALES_ORGANIZATION	VARCHAR2	(4)	Sales Organization
PERIOD_START_DATE	DATE		Period Start Date
OPERATING_UNIT_ID	NUMBER	(15)	Operating Unit ID
YEAR_ID	VARCHAR2	(31)	Year ID is combination (concatenated Period Set Name and Year name separated with a plus sign) Key used to Identify unique GL Year
QUARTER_ID	VARCHAR2	(31)	Quarter ID is combination (concatenated Period Set Name and Quarter name separated with a plus sign) Key used to Identify unique GL Quarter
PERIOD_ID	VARCHAR2	(31)	Period ID is combination Key (concatenated Period Set Name and period name separated with a plus sign) used to Identify unique GL Period

Query Text

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


SELECT ITEM_ID
,      ORDER_QUANTITY
,      WAREHOUSE_SHIPPED_FROM
,      EXTENDED_PRICE_BASE_CURRENCY
,      CHARGES_BASE_CURRENCY
,      SALES_COMPANY
,      SALES_ORGANIZATION
,      PERIOD_START_DATE
,      OPERATING_UNIT_ID
,      YEAR_ID
,      QUARTER_ID
,      PERIOD_ID
FROM APPS.PMI_REP_SALES_DETAILS_V;

Dependencies

[top of page]

APPS.PMI_REP_SALES_DETAILS_V references the following:

APPS: GL_PLCY_MST; GL_SETS_OF_BOOKS; GMICUOM - show dependent code; HR_OPERATING_UNITS; HR_SECURITY - show dependent code; IC_ITEM_MST_B; IC_WHSE_MST; MTL_SYSTEM_ITEMS_B; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OE_SYSTEM_PARAMETERS_ALL; OE_SYS_PARAMETERS - show dependent code; OP_ORDR_DTL; OP_ORDR_HDR; PMI_COMMON_PKG - show dependent code; PMI_GL_TIME_V; PMI_SALES_PKG - show dependent code; PMI_SECURITY_PKG - show dependent code; SY_ORGN_MST

APPS.PMI_REP_SALES_DETAILS_V is referenced by following:

APPS: PMI_REP_GROSS_MARGIN_V