DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PMI_REP_GROSS_MARGIN_V

Object Details
Object Name: PMI_REP_GROSS_MARGIN_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPMI.PMI_REP_GROSS_MARGIN_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


PMI Gross Margin Report view


[View Source]

Columns
Name Datatype Length Mandatory Comments
OPERATING_UNIT_ID NUMBER (15)
Operating Unit ID
SALES_COMPANY VARCHAR2 (4)
Sales Company
SALES_ORGANIZATION VARCHAR2 (4)
Sales Organization
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
REVENUE NUMBER

Sales Revenue in Base Currency
DISCOUNT NUMBER

Charges or Discounts in Base Currency
COGS NUMBER

Cost of Goods Sold in Base Currency
MARGIN NUMBER

Margin in Base Currency
Query Text

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


SELECT OPERATING_UNIT_ID
,      SALES_COMPANY
,      SALES_ORGANIZATION
,      YEAR_ID
,      QUARTER_ID
,      PERIOD_ID
,      REVENUE
,      DISCOUNT
,      COGS
,      MARGIN
FROM APPS.PMI_REP_GROSS_MARGIN_V;

Dependencies

[top of page]

APPS.PMI_REP_GROSS_MARGIN_V references the following:

SchemaAPPS
PL/SQL PackageGMICUOM - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageOE_SYS_PARAMETERS - show dependent code
PL/SQL PackagePMI_COMMON_PKG - show dependent code
ViewPMI_REP_SALES_DETAILS_V
PL/SQL PackagePMI_SALES_PKG - show dependent code
PL/SQL PackagePMI_SECURITY_PKG - show dependent code

APPS.PMI_REP_GROSS_MARGIN_V is not referenced by any database object