[Home] [Help] [Dependency Information]
Object Name: | POA_DBI_PLL_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | POA_DBI_PLL_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
POA_DBI_POD_F
PO_COMMODITY_CATEGORIES
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_LOCATION_ID | NUMBER | Line location id of PO Shipments | ||
BUYER_ID | NUMBER | Yes | Buyer on the PO Header | |
CATEGORY_ID | NUMBER | Category on the PO Line Identifier | ||
PO_ITEM_ID | NUMBER | Yes | Purchased item identifier | |
ORDER_TYPE | VARCHAR2 | (25) | Specifies whether the PO line is of amount or quantity type | |
ITEM_ID | NUMBER | Item id on the PO Line | ||
BASE_UOM_CONV_RATE | NUMBER | Rate to convert from UOM on PO line to Base uom of the item | ||
EXPECTED_DATE | DATE | Date when shipment is expected | ||
DAYS_LATE_RECEIPT_ALLOWED | NUMBER | Number of days late when the receipt is valid | ||
DAYS_EARLY_RECEIPT_ALLOWED | NUMBER | Number of Days early when the receipt is valid | ||
BASE_UOM | VARCHAR2 | (25) | UOM of the item as specified in the inventory setup | |
PRICE_OVERRIDE | NUMBER | Price specified on the PO Shipment | ||
MATCHING_BASIS | VARCHAR2 | (30) | Specifies if the Line type is Quantity or Amount | |
RECEIVING_ROUTING_ID | NUMBER | Type of receipt specified on the Shipment | ||
COMMODITY_ID | NUMBER | Commodity Identifer | ||
PAYMENT_TYPE | VARCHAR2 | (30) | Payment Type | |
SHIPMENT_TYPE | VARCHAR2 | (25) | Shipment Type | |
COMPLEX_WORK_FLAG | VARCHAR2 | (1) | Complex Work Flag | |
FUNC_CUR_CODE | VARCHAR2 | (25) | Functional Currency Code | |
CNT | NUMBER | Number of distributions |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_LOCATION_ID
, BUYER_ID
, CATEGORY_ID
, PO_ITEM_ID
, ORDER_TYPE
, ITEM_ID
, BASE_UOM_CONV_RATE
, EXPECTED_DATE
, DAYS_LATE_RECEIPT_ALLOWED
, DAYS_EARLY_RECEIPT_ALLOWED
, BASE_UOM
, PRICE_OVERRIDE
, MATCHING_BASIS
, RECEIVING_ROUTING_ID
, COMMODITY_ID
, PAYMENT_TYPE
, SHIPMENT_TYPE
, COMPLEX_WORK_FLAG
, FUNC_CUR_CODE
, CNT
FROM APPS.POA_DBI_PLL_MV;
|
|
|