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

Object Details

Object Name:	PJM_PROJECT_SO_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PJM.PJM_PROJECT_SO_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

PJM_PROJECT_SO_V returns project-related sales order information.
This view corresponds to the Sales Order Summary web inquiry region.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER			System-generated number that uniquely identifies a project or seiban
TASK_ID	NUMBER			System-generated number that uniquely identifies a task
HEADER_ID	NUMBER		Yes	Sales order header unique identifier
ORDER_NUMBER	NUMBER		Yes	Sales order number
PO_NUMBER	VARCHAR2	(50)		Purchase order number
ORDER_CATEGORY	VARCHAR2	(30)	Yes	Order category
ORDER_TYPE	VARCHAR2	(30)	Yes	Order type
ITEM_NUMBER	VARCHAR2	(40)		Item number
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		End item model/unit number
FREIGHT_TERMS	VARCHAR2	(4000)		Freight terms
PAYMENT_TERMS	VARCHAR2	(15)		Payment terms
CUSTOMER_ID	NUMBER	(15)		Customer unique identifier
CUSTOMER_NUMBER	VARCHAR2	(30)		Customer number
CUSTOMER_NAME	VARCHAR2	(360)		Customer name
ORDER_DATE	DATE			Date of the sales order
REQUEST_DATE	DATE			Request date
CANCELLED_FLAG	VARCHAR2	(1)		Flag indicating order has been cancelled
SHIP_TO_LOCATION	VARCHAR2	(4000)		Ship-to location
SHIP_TO_LOCATION_ID	NUMBER			Ship-to location unique identifier
SHIP_METHOD	VARCHAR2	(30)		Shipping method
SHIP_PRIORITY	VARCHAR2	(4000)		Shiment priority
ALLOW_PARTIAL_SHIP	VARCHAR2	(1)		Flag indicating partial shipment is allowed for this order
BILL_TO_LOCATION_ID	NUMBER			Bill-to location unique identifier
BILL_TO_LOCATION	VARCHAR2	(4000)		Bill-to location
ORDER_AMOUNT	VARCHAR2	(4000)		Sales order amount
ORDER_CURRENCY	VARCHAR2	(15)		Sales order currency
TAX_EXEMPT	VARCHAR2	(1)		Tax exempt indicator
ORG_ID	NUMBER			Operating Unit which performed this transaction

Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      HEADER_ID
,      ORDER_NUMBER
,      PO_NUMBER
,      ORDER_CATEGORY
,      ORDER_TYPE
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      END_ITEM_UNIT_NUMBER
,      FREIGHT_TERMS
,      PAYMENT_TERMS
,      CUSTOMER_ID
,      CUSTOMER_NUMBER
,      CUSTOMER_NAME
,      ORDER_DATE
,      REQUEST_DATE
,      CANCELLED_FLAG
,      SHIP_TO_LOCATION
,      SHIP_TO_LOCATION_ID
,      SHIP_METHOD
,      SHIP_PRIORITY
,      ALLOW_PARTIAL_SHIP
,      BILL_TO_LOCATION_ID
,      BILL_TO_LOCATION
,      ORDER_AMOUNT
,      ORDER_CURRENCY
,      TAX_EXEMPT
,      ORG_ID
FROM APPS.PJM_PROJECT_SO_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_SO_V references the following:

APPS: FND_CURRENCY_CACHE - show dependent code; MTL_SYSTEM_ITEMS_B; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OE_SOLD_TO_ORGS_V; OE_TRANSACTION_TYPES_TL; PJM_INQUIRY - show dependent code; RA_TERMS_TL

APPS.PJM_PROJECT_SO_V is not referenced by any database object