[Home] [Help] [Dependency Information]
Object Name: | POR_VIEW_LINE_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.POR_VIEW_LINE_DETAILS_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
The POR_VIEW_LINE_DETAILS_V view provides data to POR_VIEW_LINE_DETAILS_R region on View Line Details Page.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUISITION_LINE_ID | NUMBER | Yes | Requisition line unique identifier | |
REQUISITION_HEADER_ID | NUMBER | Yes | Requisition header unique identifier | |
ITEM_ID | NUMBER | Item unique identifier | ||
ITEM_NUMBER | VARCHAR2 | (40) | Item number | |
ITEM_REVISION | VARCHAR2 | (3) | Item revision | |
DESCRIPTION | VARCHAR2 | (240) | Yes | Item description |
CATEGORY_ID | NUMBER | Item category unique identifier | ||
CATEGORY | VARCHAR2 | (163) | Item category | |
CATEGORY_DESCRIPTION | VARCHAR2 | (240) | Item category description | |
NEED_BY_DATE | VARCHAR2 | (75) | Standard Who column | |
UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | Unit of measure | |
UNIT_PRICE | NUMBER | Unit price in functional currency | ||
RATE_PER_UNIT | NUMBER | Unit price in functional currency | ||
SERVICE_COST | NUMBER | Unit price in functional currency | ||
QUANTITY | NUMBER | Quantity ordered | ||
TAX_EXEMPT_FLAG | VARCHAR2 | (30) | Indicates whether the item is tax exempted or not | |
NEW_SUPPLIER_FLAG | VARCHAR2 | (80) | Yes | Indicates whether the supplier is new or not |
SUGGESTED_VENDOR_NAME | VARCHAR2 | (240) | Suggested vender name | |
SUGGESTED_VENDOR_PRODUCT_CODE | VARCHAR2 | (25) | Suggested supplier product number | |
SUGGESTED_VENDOR_LOCATION | VARCHAR2 | (240) | Suggested supplier site name | |
SUGGESTED_VENDOR_CONTACT | VARCHAR2 | (80) | Suggested supplier contacted name | |
SUGGESTED_VENDOR_PHONE | VARCHAR2 | (25) | Suggested supplier phone number | |
SUPPLIER_NUMBER | VARCHAR2 | (30) | Supplier number | |
SUPPLIER_DUNS | VARCHAR2 | (60) | Data Universal Numbering System Code | |
MANUFACTURER | VARCHAR2 | (240) | Manufacturer name | |
MANUFACTURER_PART_NUMBER | VARCHAR2 | (150) | Manufacturer part number | |
REQUESTER_ID | NUMBER | (9) | Yes | Requester unique identifier |
REQUESTER | VARCHAR2 | (240) | Requester name | |
REQUESTER_EMAIL | VARCHAR2 | (240) | Requester email | |
REQUESTER_PHONE | VARCHAR2 | (60) | Requester phone | |
REQUESTER_FAX | VARCHAR2 | (60) | Requester fax | |
DELIVER_TO_LOCATION_ID | NUMBER | Deliver-to location unique identifier | ||
LOCATION_CODE | VARCHAR2 | (60) | Yes | Location type |
DELIVER_TO_ORG_ID | NUMBER | Deliver-to organization unique identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization type | |
INV_REPLENISHMENT_FLAG | VARCHAR2 | (80) | Yes | Indicates whether the inventory is replenished or not |
DESTINATION_SUBINVENTORY | VARCHAR2 | (10) | Destination subinventory name | |
PROJECT_ID | NUMBER | Project unique identifier | ||
PROJECT | VARCHAR2 | (25) | Project name | |
TASK_ID | NUMBER | Task unique identifier | ||
TASK_NAME | VARCHAR2 | (278) | Task name | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Expenditure type | |
EXPENDITURE_ORG_ID | NUMBER | Expenditure prganization unique identifier | ||
EXPENDITURE_ORG | VARCHAR2 | (240) | Expenditure organization name | |
EXPENDITURE_ITEM_DATE | VARCHAR2 | (75) | Expenditure item date | |
NOTE_TO_APPROVER | VARCHAR2 | (4000) | Note to approver | |
NOTE_TO_AGENT | VARCHAR2 | (480) | Note to buyer | |
NOTE_TO_RECEIVER | VARCHAR2 | (480) | Note to receiver | |
NOTE_TO_VENDOR | VARCHAR2 | (480) | Note to supplier | |
LINE_TOTAL | VARCHAR2 | (4000) | Line total | |
CURRENCY_CODE | VARCHAR2 | (15) | Unique identifier for the currency | |
HAZARD_CLASS_ID | NUMBER | Hazard class unique identifier | ||
HAZARD_CLASS | VARCHAR2 | (40) | Hazard class | |
LINE_NUM | NUMBER | Yes | Line number | |
LINE_TYPE_ID | NUMBER | Yes | Line type identifier | |
LINE_TYPE | VARCHAR2 | (25) | Yes | Line type |
SOURCE_DOC_NUM | VARCHAR2 | (20) | source document number | |
SOURCE_DOC_LINE_NUM | NUMBER | Source document line number | ||
SOURCE_DOC_TYPE_CODE | VARCHAR2 | (25) | Source document type | |
UNSPSC_CODE | VARCHAR2 | (30) | Standard Product and Service Code | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
PCARD_FLAG | VARCHAR2 | (1) | Unused | |
CHARGE_ACCOUNT | VARCHAR2 | (155) | Charge account | |
CATALOG_TYPE | VARCHAR2 | (30) | Catalog type | |
PO_NUMBER | VARCHAR2 | (20) | PO number | |
PO_STATUS | VARCHAR2 | (80) | PO status | |
BUYER | VARCHAR2 | (240) | Buyer name |
Cut, paste (and edit) the following text to query this object:
SELECT REQUISITION_LINE_ID
, REQUISITION_HEADER_ID
, ITEM_ID
, ITEM_NUMBER
, ITEM_REVISION
, DESCRIPTION
, CATEGORY_ID
, CATEGORY
, CATEGORY_DESCRIPTION
, NEED_BY_DATE
, UNIT_MEAS_LOOKUP_CODE
, UNIT_PRICE
, RATE_PER_UNIT
, SERVICE_COST
, QUANTITY
, TAX_EXEMPT_FLAG
, NEW_SUPPLIER_FLAG
, SUGGESTED_VENDOR_NAME
, SUGGESTED_VENDOR_PRODUCT_CODE
, SUGGESTED_VENDOR_LOCATION
, SUGGESTED_VENDOR_CONTACT
, SUGGESTED_VENDOR_PHONE
, SUPPLIER_NUMBER
, SUPPLIER_DUNS
, MANUFACTURER
, MANUFACTURER_PART_NUMBER
, REQUESTER_ID
, REQUESTER
, REQUESTER_EMAIL
, REQUESTER_PHONE
, REQUESTER_FAX
, DELIVER_TO_LOCATION_ID
, LOCATION_CODE
, DELIVER_TO_ORG_ID
, ORGANIZATION_CODE
, INV_REPLENISHMENT_FLAG
, DESTINATION_SUBINVENTORY
, PROJECT_ID
, PROJECT
, TASK_ID
, TASK_NAME
, EXPENDITURE_TYPE
, EXPENDITURE_ORG_ID
, EXPENDITURE_ORG
, EXPENDITURE_ITEM_DATE
, NOTE_TO_APPROVER
, NOTE_TO_AGENT
, NOTE_TO_RECEIVER
, NOTE_TO_VENDOR
, LINE_TOTAL
, CURRENCY_CODE
, HAZARD_CLASS_ID
, HAZARD_CLASS
, LINE_NUM
, LINE_TYPE_ID
, LINE_TYPE
, SOURCE_DOC_NUM
, SOURCE_DOC_LINE_NUM
, SOURCE_DOC_TYPE_CODE
, UNSPSC_CODE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PCARD_FLAG
, CHARGE_ACCOUNT
, CATALOG_TYPE
, PO_NUMBER
, PO_STATUS
, BUYER
FROM APPS.POR_VIEW_LINE_DETAILS_V;
APPS.POR_VIEW_LINE_DETAILS_V is not referenced by any database object
|
|
|