[Home] [Help]
[Dependency Information]
VIEW: APPS.POA_PURCHASE_SALES_V
Object Details
Object Name: | POA_PURCHASE_SALES_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.POA_PURCHASE_SALES_V
|
---|
Subobject Name: | |
Status: | VALID |
***** Warning: Oracle Internal Use Only *****
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
PURCHASE_AMOUNT |
NUMBER |
|
|
|
SALES_AMOUNT |
NUMBER |
|
|
|
MONTH_BUCKET |
VARCHAR2 |
(14) |
|
|
TRANSACTION_DATE |
DATE |
|
|
|
OU_ID |
NUMBER |
|
|
|
ITEM_ID |
NUMBER |
|
|
|
CURRENCY |
VARCHAR2 |
(15) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT PURCHASE_AMOUNT
, SALES_AMOUNT
, MONTH_BUCKET
, TRANSACTION_DATE
, OU_ID
, ITEM_ID
, CURRENCY
FROM APPS.POA_PURCHASE_SALES_V;
Dependencies
[top of page]
APPS.POA_PURCHASE_SALES_V references the following:
-
APPS
-
INV_CONVERT
- show dependent code
-
OE_ORDER_LINES_ALL
-
PO_HEADERS_ALL
-
PO_LINES_ALL
-
PO_LINE_LOCATIONS_ALL
-
RCV_TRANSACTIONS
-
WSH_DELIVERY_ASSIGNMENTS
-
WSH_DELIVERY_DETAILS_OB_GRP_V
-
WSH_NEW_DELIVERIES_OB_GRP_V
APPS.POA_PURCHASE_SALES_V is referenced by following:
-
APPS
-
POA_BIS_ALERTS
- show dependent code