[Home] [Help] [Dependency Information]
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 |
MultiLingual view (a language resolved view of the data.)
PMI Sales Details Report view
Name | Datatype | Length | Mandatory | 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 |
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;
|
|
|