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

Object Details

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

View Type

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

Details of all shipped sales orders which are associated to corresponding GL periods.

[View Source]

Columns

Name	Datatype	Length	Comments
ORDER_SOURCE_SYSTEM	CHAR	(4)	This column is to Identify source of order is it OPM OP or OM
PRICE_ID	NUMBER		Price ID
PRICE_SELECTED_IND	NUMBER		Price Selection Indicator
ORDER_ID	NUMBER		Order ID
ORDER_NO	VARCHAR2	(40)	Order Number
ORDER_DATE	DATE		Order Date
ORDER_STATUS	NUMBER		Order Status
LINE_ID	NUMBER		Line ID
LINE_NO	NUMBER		Line Number
LINE_STATUS	NUMBER		Line Status
ITEM_ID	NUMBER	(10)	Item ID
ITEM_NO	VARCHAR2	(32)	Item Number
ITEM_DESCRIPTION	VARCHAR2	(70)	Item Description
ITEM_UOM	VARCHAR2	(4)	Item UOM
SALES_CLASS	VARCHAR2	(8)	Sales Class
ORDER_QUANTITY	NUMBER		Order Quantity
ORDER_QUANTITY_ITEM_UOM	NUMBER		Order Quantity in Item UOM
ORDER_UOM	VARCHAR2	(4)	Order UOM
BILLING_CUSTOMER_CLASS	VARCHAR2	(0)	Billing Customer Class
BILLING_CUSTOMER_ID	NUMBER	(15)	Billing Customer ID
BILLING_CUSTOMER_NO	VARCHAR2	(4000)	Billing Customer Number
BILLING_CUSTOMER_NAME	VARCHAR2	(360)	Billing Customer Name
BILLING_CUSTOMER_ADDID	NUMBER	(15)	Billing Customer Address ID
BILLING_CUSTOMER_CITY	VARCHAR2	(70)	Billing Customer City
BILLING_CUSTOMER_STATE	VARCHAR2	(60)	Billing Customer State
BILLING_CUSTOMER_COUNTRY	VARCHAR2	(60)	Billing Customer Address
SHIPPING_CUSTOMER_CLASS	VARCHAR2	(0)	Shipping Customer Class
SHIPPING_CUSTOMER_ID	NUMBER	(15)	Shipping Customer ID
SHIPPING_CUSTOMER_NO	VARCHAR2	(4000)	Shipping Customer Number
SHIPPING_CUSTOMER_NAME	VARCHAR2	(360)	Shipping Customer Name
SHIPPING_CUSTOMER_ADDID	NUMBER		Shipping Customer Address ID
SHIPPING_CUSTOMER_CITY	VARCHAR2	(70)	Shipping Customer City
SHIPPING_CUSTOMER_STATE	VARCHAR2	(60)	Shipping Customer State
SHIPPING_CUSTOMER_COUNTRY	VARCHAR2	(60)	Shipping Customer Address
SHIPPER_CODE	VARCHAR2	(30)	Shipper Code
SHIPPING_METHOD	VARCHAR2	(30)	Shipping Method
WAREHOUSE_SHIPPED_TO	VARCHAR2	(40)	Warehouse Shipped To
WAREHOUSE_SHIPPED_FROM	VARCHAR2	(4)	Warehouse Shipped From
SHIPPING_ORGANIZATION	VARCHAR2	(4)	Shipping Organization
SHIPPING_ORGANIZATION_NAME	VARCHAR2	(40)	Shipping Organization Name
SHIPPING_COMPANY	VARCHAR2	(4)	Shipping Company
SHIPPING_STATUS	NUMBER		Shipping Status
BASE_PRICE	NUMBER		Base Price
NET_PRICE	NUMBER		Net Price
EXTENDED_PRICE	NUMBER		Extended Price
EXTENDED_PRICE_BASE_CURRENCY	NUMBER		Extended Price Base Currency
CHARGES_BASE_CURRENCY	NUMBER		Charges in Base Currency
PRICING_UOM	VARCHAR2	(4)	Pricing UOM
BILLING_CURRENCY	VARCHAR2	(15)	Billing Currency
BASE_CURRENCY	VARCHAR2	(15)	Base Currency
EXCHANGE_RATE	NUMBER		Exchange Rate
REQUESTED_SHIPDATE	DATE		Requested Ship date of order
PROMISED_SHIPDATE	DATE		Promised Ship date of order
LIST_PRICE	NUMBER		List Price
SCHEDULED_SHIPDATE	DATE		Scheduled Ship date of order
ACTUAL_SHIPDATE	DATE		Actual ship date of order
REQUIRED_DELIVERY_DATE	DATE		Required Delivery Date
ACTUAL_DELIVERY_DATE	DATE		Actual Delivery Date
QC_GRADE_WANTED	VARCHAR2	(150)	QC grade Wanted from customer
SALES_REPRESENTATIVE	VARCHAR2	(40)	Sales Representative Code
SALES_REP_NAME	VARCHAR2	(240)	Sales Representative Name
COMMISSION_CODE	VARCHAR2	(8)	Commission Code
NET_COMMISSION	NUMBER		Net commission on line
NET_TAX	NUMBER		Net Tax on order line
CUSTOMER_PO_NO	VARCHAR2	(50)	Customer Purchase order Number
SALES_COMPANY	VARCHAR2	(4)	Sales Company
SALES_ORGANIZATION	VARCHAR2	(4)	Sales Organization
SALES_ORGANIZATION_NAME	VARCHAR2	(240)	Sales Organization Name
FISCAL_YEAR	NUMBER	(15)	Fiscal Year in which order falls
PERIOD_CODE	NUMBER	(15)	Period Code in which order falls
PERIOD_NAME	VARCHAR2	(15)	Period name
PERIOD_START_DATE	DATE		Period Start Date
PERIOD_END_DATE	DATE		Period End date
CREATION_DATE	DATE		Order Detail creation date
LAST_UPDATE_DATE	DATE		Order Detail Last Update Date
CREATED_BY	NUMBER		Order Details Created By
LAST_UPDATED_BY	NUMBER		Order Detail Last update by
OPERATING_UNIT_ID	NUMBER	(15)
OPERATING_UNIT_NAME	VARCHAR2	(240)	Operating Unit Name

Query Text

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


SELECT ORDER_SOURCE_SYSTEM
,      PRICE_ID
,      PRICE_SELECTED_IND
,      ORDER_ID
,      ORDER_NO
,      ORDER_DATE
,      ORDER_STATUS
,      LINE_ID
,      LINE_NO
,      LINE_STATUS
,      ITEM_ID
,      ITEM_NO
,      ITEM_DESCRIPTION
,      ITEM_UOM
,      SALES_CLASS
,      ORDER_QUANTITY
,      ORDER_QUANTITY_ITEM_UOM
,      ORDER_UOM
,      BILLING_CUSTOMER_CLASS
,      BILLING_CUSTOMER_ID
,      BILLING_CUSTOMER_NO
,      BILLING_CUSTOMER_NAME
,      BILLING_CUSTOMER_ADDID
,      BILLING_CUSTOMER_CITY
,      BILLING_CUSTOMER_STATE
,      BILLING_CUSTOMER_COUNTRY
,      SHIPPING_CUSTOMER_CLASS
,      SHIPPING_CUSTOMER_ID
,      SHIPPING_CUSTOMER_NO
,      SHIPPING_CUSTOMER_NAME
,      SHIPPING_CUSTOMER_ADDID
,      SHIPPING_CUSTOMER_CITY
,      SHIPPING_CUSTOMER_STATE
,      SHIPPING_CUSTOMER_COUNTRY
,      SHIPPER_CODE
,      SHIPPING_METHOD
,      WAREHOUSE_SHIPPED_TO
,      WAREHOUSE_SHIPPED_FROM
,      SHIPPING_ORGANIZATION
,      SHIPPING_ORGANIZATION_NAME
,      SHIPPING_COMPANY
,      SHIPPING_STATUS
,      BASE_PRICE
,      NET_PRICE
,      EXTENDED_PRICE
,      EXTENDED_PRICE_BASE_CURRENCY
,      CHARGES_BASE_CURRENCY
,      PRICING_UOM
,      BILLING_CURRENCY
,      BASE_CURRENCY
,      EXCHANGE_RATE
,      REQUESTED_SHIPDATE
,      PROMISED_SHIPDATE
,      LIST_PRICE
,      SCHEDULED_SHIPDATE
,      ACTUAL_SHIPDATE
,      REQUIRED_DELIVERY_DATE
,      ACTUAL_DELIVERY_DATE
,      QC_GRADE_WANTED
,      SALES_REPRESENTATIVE
,      SALES_REP_NAME
,      COMMISSION_CODE
,      NET_COMMISSION
,      NET_TAX
,      CUSTOMER_PO_NO
,      SALES_COMPANY
,      SALES_ORGANIZATION
,      SALES_ORGANIZATION_NAME
,      FISCAL_YEAR
,      PERIOD_CODE
,      PERIOD_NAME
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
FROM APPS.PMIFV_SALES_DETAILS_V;

Dependencies

[top of page]

APPS.PMIFV_SALES_DETAILS_V references the following:

APPS: FND_PROFILE - show dependent code; GL_PERIODS; GL_PLCY_MST; GL_SETS_OF_BOOKS; GMICUOM - show dependent code; HR_OPERATING_UNITS; IC_ITEM_MST; IC_WHSE_MST; MTL_SYSTEM_ITEMS; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OE_SYSTEM_PARAMETERS_ALL; OE_SYS_PARAMETERS - show dependent code; OP_CUST_MST; OP_ORDR_DTL; OP_ORDR_HDR; OP_SLSR_MST; PMI_COMMON_PKG - show dependent code; PMI_GL_CALENDAR_V; PMI_HZ_PARTY_V; PMI_SALES_PKG - show dependent code; PMI_SECURITY_PKG - show dependent code; RA_SALESREPS_ALL; SY_ADDR_MST; SY_ORGN_MST

APPS.PMIFV_SALES_DETAILS_V is not referenced by any database object