[Home] [Help] [Dependency Information]
Object Name: | POR_LINES_ALL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.POR_LINES_ALL_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
The POR_LINES_V returns all the data that is used to define a requisition line. It also includes manufacturer, delivery, organization, buyer information.
This view does not stripe by org.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUISITION_HEADER_ID | NUMBER | Yes | Requisition header unique identifier | |
REQUISITION_LINE_ID | NUMBER | Yes | Requisition line unique identifier | |
LINE_NUM | NUMBER | Yes | Line number | |
LINE_TYPE_ID | NUMBER | Yes | Line type | |
LINE_TYPE | VARCHAR2 | (25) | Yes | Line Type |
ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Yes | Order Type Lookup Code |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Yes | Item Description |
ITEM_ID | NUMBER | Item ID | ||
ITEM_NUMBER | VARCHAR2 | (40) | Item number | |
ITEM_REVISION | VARCHAR2 | (3) | Item revision | |
CATEGORY_ID | NUMBER | Yes | Category ID | |
CATEGORY | VARCHAR2 | (163) | Category name | |
CATALOG_TYPE | VARCHAR2 | (30) | Category type | |
CATALOG_SOURCE | VARCHAR2 | (30) | Catalog source | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
CURRENCY_UNIT_PRICE | NUMBER | Currency unit price | ||
NEGOTIATION_NUMBER | VARCHAR2 | (83) | Negotiation number | |
SO_CREATION_DATE | DATE | Sales Order Creation Date | ||
SHIPMENT_NUMBER | VARCHAR2 | (4000) | Shipment number | |
MANUFACTURER_NAME | VARCHAR2 | (240) | manufacture name | |
MANUFACTURER_PART_NUMBER | VARCHAR2 | (30) | manufacturer part number | |
MUST_USE_SUGG_VENDOR_FLAG | VARCHAR2 | (1) | Flag indicates must use suggest vendor | |
DELIVER_TO_LOCATION_ID | NUMBER | Yes | Deliver to location ID | |
DELIVER_TO_LOCATION | VARCHAR2 | (60) | Yes | Deliver to location name |
DELIVER_TO_ORG_ID | NUMBER | Deliver to org ID | ||
DELIVER_TO_ORG_CODE | VARCHAR2 | (3) | Deliver to org code | |
DESTINATION_SUBINVENTORY | VARCHAR2 | (10) | Destination Subinventory | |
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Destination type code | |
DESTINATION_TYPE | VARCHAR2 | (80) | Destination type | |
REQUESTER_EMAIL | VARCHAR2 | (240) | Requester Email | |
REQUESTER_FAX | VARCHAR2 | (60) | Requester FAX | |
REQUESTER_ID | NUMBER | (9) | Yes | Requester ID |
DELIVER_TO_REQUESTER | VARCHAR2 | (240) | Deliver to requester | |
REQUESTER_PHONE | VARCHAR2 | (60) | Requester phone | |
ENCUMBERED_FLAG | VARCHAR2 | (1) | encumbered flag | |
HAZARD_CLASS_ID | NUMBER | Hazard class ID | ||
HAZARD_CLASS | VARCHAR2 | (40) | Hazard class | |
JUSTIFICATION | VARCHAR2 | (480) | Justification | |
MODIFIED_BY_AGENT_FLAG | VARCHAR2 | (1) | Modified by agent flag | |
NEED_BY_DATE | DATE | standard who column | ||
NOTE_TO_AGENT | VARCHAR2 | (480) | Note to agent | |
NOTE_TO_RECEIVER | VARCHAR2 | (480) | Note to receiver | |
NOTE_TO_VENDOR | VARCHAR2 | (480) | Note to vendor | |
ON_RFQ_FLAG | VARCHAR2 | (1) | on RFQ flag | |
ORG_ID | NUMBER | org ID | ||
ORG_CODE | VARCHAR2 | (3) | org code | |
PARENT_REQ_LINE_ID | NUMBER | parent requisition line ID | ||
LINE_LOCATION_ID | NUMBER | line location ID | ||
QUANTITY_CANCELLED | NUMBER | quantity cancelled | ||
QUANTITY_DELIVERED | NUMBER | quantity delivered | ||
QUANTITY | NUMBER | Quantity | ||
QUANTITY_RECEIVED | NUMBER | Quantity Received | ||
RATE | NUMBER | Rate | ||
RATE_DATE | DATE | Rate Date | ||
RATE_TYPE | VARCHAR2 | (30) | Rate type | |
RFQ_REQUIRED_FLAG | VARCHAR2 | (1) | RFQ required flag | |
SOURCE_ORGANIZATION_ID | NUMBER | Source organization ID | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
SOURCE_REQ_LINE_ID | NUMBER | Source requisition line ID | ||
SOURCE_SUBINVENTORY | VARCHAR2 | (10) | Source subinventory | |
SOURCE_TYPE_CODE | VARCHAR2 | (25) | Yes | Source type code |
SOURCE_TYPE | VARCHAR2 | (80) | Source type | |
UNSPSC_CODE | VARCHAR2 | (30) | UNSPSC code | |
OTHER_CATEGORY_CODE | VARCHAR2 | (30) | Other category code | |
SUGGESTED_BUYER_ID | NUMBER | (9) | Suggested buyer ID | |
SUGGESTED_BUYER | VARCHAR2 | (240) | Suggested buyer name | |
BLANKET_PO_HEADER_ID | NUMBER | Blanket PO header ID | ||
DOCUMENT_NUM | VARCHAR2 | (20) | Document number | |
BLANKET_PO_LINE_NUM | NUMBER | Blanket PO line number | ||
DOCUMENT_TYPE_CODE | VARCHAR2 | (25) | Document type code | |
DOCUMENT_TYPE | VARCHAR2 | (30) | Document type | |
SUPPLIER_DUNS | VARCHAR2 | (60) | Supplier DUNS number | |
SUPPLIER_ITEM_NUMBER | VARCHAR2 | (25) | Supplier item number | |
TAX_STATUS_INDICATOR | VARCHAR2 | (30) | Tax status indicator | |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | USSGL transaction code | |
PCARD_FLAG | VARCHAR2 | (1) | PCARD flag | |
TRANSACTION_REASON_CODE | VARCHAR2 | (25) | Transaction reason code | |
UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | Unit of measure lookup code | |
UNIT_PRICE | NUMBER | Unit price | ||
URGENT_FLAG | VARCHAR2 | (1) | Urgent flag | |
VENDOR_CONTACT_ID | NUMBER | Vendor contact ID | ||
SUGGESTED_VENDOR_CONTACT | VARCHAR2 | (80) | Suggested vendor contact | |
SUGGESTED_VENDOR_PHONE | VARCHAR2 | (25) | suggested vendor phone | |
VENDOR_ID | NUMBER | vendor ID | ||
SUGGESTED_VENDOR_NAME | VARCHAR2 | (240) | Suggested vendor name | |
SUGGESTED_VENDOR_LOCATION | VARCHAR2 | (240) | Suggested vendor location | |
VENDOR_SITE_ID | NUMBER | Vendor site ID | ||
VENDOR_SITE_CODE | VARCHAR2 | (240) | Vendor site code | |
NEW_SUPPLIER_FLAG | VARCHAR2 | (1) | flag to indicate new supplier | |
AUTO_RECEIVE_FLAG | VARCHAR2 | (1) | flag to indicate auto receive | |
AGENT_RETURN_NOTE | VARCHAR2 | (480) | Agent return note | |
CANCEL_DATE | DATE | Cancel date | ||
CANCEL_FLAG | VARCHAR2 | (1) | Cancel flag | |
CANCEL_FLAG_DISPLAY | VARCHAR2 | (80) | Display for cancel flag | |
CANCEL_REASON | VARCHAR2 | (240) | Cancel reason | |
CLOSED_CODE | VARCHAR2 | (25) | Closed code | |
CLOSED_CODE_DISPLAY | VARCHAR2 | (80) | Display for closed code | |
CLOSED_DATE | DATE | Closed date | ||
CLOSED_REASON | VARCHAR2 | (240) | Closed reason | |
DESTINATION_CONTEXT | VARCHAR2 | (30) | Destination context | |
UN_NUMBER_ID | NUMBER | UN number ID | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Attribute 1 | |
ATTRIBUTE2 | VARCHAR2 | (150) | Attribute 2 | |
ATTRIBUTE3 | VARCHAR2 | (150) | Attribute 3 | |
ATTRIBUTE4 | VARCHAR2 | (150) | Attribute 4 | |
ATTRIBUTE5 | VARCHAR2 | (150) | Attribute 5 | |
ATTRIBUTE6 | VARCHAR2 | (150) | Attribute 6 | |
ATTRIBUTE7 | VARCHAR2 | (150) | Attribute 7 | |
ATTRIBUTE8 | VARCHAR2 | (150) | Attribute 8 | |
ATTRIBUTE9 | VARCHAR2 | (150) | Attribute 9 | |
ATTRIBUTE10 | VARCHAR2 | (150) | Attribute 10 | |
ATTRIBUTE11 | VARCHAR2 | (150) | Attribute 11 | |
ATTRIBUTE12 | VARCHAR2 | (150) | Attribute 12 | |
ATTRIBUTE13 | VARCHAR2 | (150) | Attribute 13 | |
ATTRIBUTE14 | VARCHAR2 | (150) | Attribute 14 | |
ATTRIBUTE15 | VARCHAR2 | (150) | Attribute 15 | |
ITEM_SOURCE_ID | NUMBER | Item source ID | ||
SUPPLIER_REF_NUMBER | VARCHAR2 | (150) | Supplier reference number | |
WIP_ENTITY_ID | NUMBER | WIP Entity Identification | ||
WIP_OPERATION_SEQ_NUM | NUMBER | WIP Operation Sequence Number |
Cut, paste (and edit) the following text to query this object:
SELECT REQUISITION_HEADER_ID
, REQUISITION_LINE_ID
, LINE_NUM
, LINE_TYPE_ID
, LINE_TYPE
, ORDER_TYPE_LOOKUP_CODE
, ITEM_DESCRIPTION
, ITEM_ID
, ITEM_NUMBER
, ITEM_REVISION
, CATEGORY_ID
, CATEGORY
, CATALOG_TYPE
, CATALOG_SOURCE
, CURRENCY_CODE
, CURRENCY_UNIT_PRICE
, NEGOTIATION_NUMBER
, SO_CREATION_DATE
, SHIPMENT_NUMBER
, MANUFACTURER_NAME
, MANUFACTURER_PART_NUMBER
, MUST_USE_SUGG_VENDOR_FLAG
, DELIVER_TO_LOCATION_ID
, DELIVER_TO_LOCATION
, DELIVER_TO_ORG_ID
, DELIVER_TO_ORG_CODE
, DESTINATION_SUBINVENTORY
, DESTINATION_TYPE_CODE
, DESTINATION_TYPE
, REQUESTER_EMAIL
, REQUESTER_FAX
, REQUESTER_ID
, DELIVER_TO_REQUESTER
, REQUESTER_PHONE
, ENCUMBERED_FLAG
, HAZARD_CLASS_ID
, HAZARD_CLASS
, JUSTIFICATION
, MODIFIED_BY_AGENT_FLAG
, NEED_BY_DATE
, NOTE_TO_AGENT
, NOTE_TO_RECEIVER
, NOTE_TO_VENDOR
, ON_RFQ_FLAG
, ORG_ID
, ORG_CODE
, PARENT_REQ_LINE_ID
, LINE_LOCATION_ID
, QUANTITY_CANCELLED
, QUANTITY_DELIVERED
, QUANTITY
, QUANTITY_RECEIVED
, RATE
, RATE_DATE
, RATE_TYPE
, RFQ_REQUIRED_FLAG
, SOURCE_ORGANIZATION_ID
, ORGANIZATION_CODE
, SOURCE_REQ_LINE_ID
, SOURCE_SUBINVENTORY
, SOURCE_TYPE_CODE
, SOURCE_TYPE
, UNSPSC_CODE
, OTHER_CATEGORY_CODE
, SUGGESTED_BUYER_ID
, SUGGESTED_BUYER
, BLANKET_PO_HEADER_ID
, DOCUMENT_NUM
, BLANKET_PO_LINE_NUM
, DOCUMENT_TYPE_CODE
, DOCUMENT_TYPE
, SUPPLIER_DUNS
, SUPPLIER_ITEM_NUMBER
, TAX_STATUS_INDICATOR
, USSGL_TRANSACTION_CODE
, PCARD_FLAG
, TRANSACTION_REASON_CODE
, UNIT_MEAS_LOOKUP_CODE
, UNIT_PRICE
, URGENT_FLAG
, VENDOR_CONTACT_ID
, SUGGESTED_VENDOR_CONTACT
, SUGGESTED_VENDOR_PHONE
, VENDOR_ID
, SUGGESTED_VENDOR_NAME
, SUGGESTED_VENDOR_LOCATION
, VENDOR_SITE_ID
, VENDOR_SITE_CODE
, NEW_SUPPLIER_FLAG
, AUTO_RECEIVE_FLAG
, AGENT_RETURN_NOTE
, CANCEL_DATE
, CANCEL_FLAG
, CANCEL_FLAG_DISPLAY
, CANCEL_REASON
, CLOSED_CODE
, CLOSED_CODE_DISPLAY
, CLOSED_DATE
, CLOSED_REASON
, DESTINATION_CONTEXT
, UN_NUMBER_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ITEM_SOURCE_ID
, SUPPLIER_REF_NUMBER
, WIP_ENTITY_ID
, WIP_OPERATION_SEQ_NUM
FROM APPS.POR_LINES_ALL_V;
APPS.POR_LINES_ALL_V is not referenced by any database object
|
|
|