[Home] [Help] [Dependency Information]
Object Name: | PO_REQUISITION_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.PO_REQUISITION_LINES_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
REQUISITION_HEADER_ID | NUMBER | Yes | ||
REQUISITION_LINE_ID | NUMBER | Yes | ||
LINE_NUM | NUMBER | Yes | ||
LINE_TYPE | VARCHAR2 | (25) | Yes | |
LINE_TYPE_ID | NUMBER | Yes | ||
ITEM_ID | NUMBER | |||
ITEM_REVISION | VARCHAR2 | (3) | ||
CATEGORY_ID | NUMBER | Yes | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | Yes | |
QUANTITY | NUMBER | |||
QUANTITY_RECEIVED | NUMBER | |||
QUANTITY_DELIVERED | NUMBER | |||
QUANTITY_CANCELLED | NUMBER | |||
UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | ||
UNIT_PRICE | NUMBER | |||
NEED_BY_DATE | DATE | |||
SUGGESTED_BUYER | VARCHAR2 | (240) | ||
NOTE_TO_AGENT | VARCHAR2 | (480) | ||
SUGGESTED_VENDOR_NAME | VARCHAR2 | (240) | ||
SUGGESTED_VENDOR_LOCATION | VARCHAR2 | (240) | ||
SUGGESTED_VENDOR_CONTACT | VARCHAR2 | (80) | ||
SUGGESTED_VENDOR_PHONE | VARCHAR2 | (25) | ||
RFQ_REQUIRED_FLAG | VARCHAR2 | (1) | ||
ON_RFQ_FLAG | VARCHAR2 | (1) | ||
CANCEL_FLAG | VARCHAR2 | (1) | ||
MODIFIED_BY_AGENT_FLAG | VARCHAR2 | (1) | ||
UN_NUMBER | VARCHAR2 | (25) | ||
HAZARD_CLASS | VARCHAR2 | (40) | ||
TRANSACTION_REASON | VARCHAR2 | (80) | ||
REFERENCE_NUM | VARCHAR2 | (25) | ||
URGENT | VARCHAR2 | (1) | ||
JUSTIFICATION | VARCHAR2 | (480) | ||
NOTE_TO_RECEIVER | VARCHAR2 | (480) | ||
ENCUMBERED_FLAG | VARCHAR2 | (1) | ||
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | ||
SOURCE_TYPE_CODE | VARCHAR2 | (25) | Yes | |
REQUESTOR | VARCHAR2 | (240) | ||
DEST_ORGANIZATION | VARCHAR2 | (240) | Yes | |
DELIVER_TO_LOCATION | VARCHAR2 | (60) | ||
DEST_SUBINVENTORY | VARCHAR2 | (10) | ||
SOURCE_ORGANIZATION | VARCHAR2 | (240) | ||
SOURCE_SUBINVENTORY | VARCHAR2 | (10) | ||
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 | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
OUTSIDE_OP_LINE_TYPE | VARCHAR2 | (1) | ||
DELIVER_TO_LOCATION_ID | NUMBER | Yes | ||
TO_PERSON_ID | NUMBER | (9) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
SUGGESTED_VENDOR_PRODUCT_CODE | VARCHAR2 | (25) | ||
UN_NUMBER_ID | NUMBER | |||
HAZARD_CLASS_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
RATE | NUMBER | |||
RATE_TYPE | VARCHAR2 | (30) | ||
RATE_DATE | DATE | |||
CURRENCY_UNIT_PRICE | NUMBER | |||
SUGGESTED_BUYER_ID | NUMBER | (9) | ||
CLOSED_CODE | VARCHAR2 | (25) | ||
LINE_LOCATION_ID | NUMBER | |||
PARENT_REQ_LINE_ID | NUMBER | |||
PURCHASING_AGENT_ID | NUMBER | (9) | ||
DOCUMENT_TYPE_CODE | VARCHAR2 | (25) | ||
BLANKET_PO_HEADER_ID | NUMBER | |||
BLANKET_PO_LINE_NUM | NUMBER | |||
CANCEL_REASON | VARCHAR2 | (240) | ||
CANCEL_DATE | DATE | |||
AGENT_RETURN_NOTE | VARCHAR2 | (480) | ||
CHANGED_AFTER_RESEARCH_FLAG | VARCHAR2 | (1) | ||
VENDOR_ID | NUMBER | |||
VENDOR_SITE_ID | NUMBER | |||
VENDOR_CONTACT_ID | NUMBER | |||
RESEARCH_AGENT_ID | NUMBER | (9) | ||
ON_LINE_FLAG | VARCHAR2 | (1) | ||
WIP_ENTITY_ID | NUMBER | |||
WIP_LINE_ID | NUMBER | |||
WIP_REPETITIVE_SCHEDULE_ID | NUMBER | |||
WIP_OPERATION_SEQ_NUM | NUMBER | |||
WIP_RESOURCE_SEQ_NUM | NUMBER | |||
DESTINATION_CONTEXT | VARCHAR2 | (30) | ||
INVENTORY_SOURCE_CONTEXT | VARCHAR2 | (30) | ||
VENDOR_SOURCE_CONTEXT | VARCHAR2 | (30) | ||
BOM_RESOURCE_ID | NUMBER | |||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | ||
CLOSED_REASON | VARCHAR2 | (240) | ||
CLOSED_DATE | DATE | |||
TRANSACTION_REASON_CODE | VARCHAR2 | (25) | ||
SOURCE_REQ_LINE_ID | NUMBER | |||
DEST_ORGANIZATION_ID | NUMBER | |||
SOURCE_ORGANIZATION_ID | NUMBER | |||
ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Yes | |
RATE_TYPE_DISP | VARCHAR2 | (30) | ||
SOURCE_DOCUMENT_TYPE | VARCHAR2 | (80) | ||
DESTINATION_CUSTOMER_ID | NUMBER | |||
DESTINATION_ADDRESS_ID | NUMBER | |||
DESTINATION_USE_ID | NUMBER | |||
SOURCE_TYPE_DISP | VARCHAR2 | (80) | Yes | |
DESTINATION_TYPE_DISP | VARCHAR2 | (80) | Yes | |
INVENTORY_ASSET_FLAG | VARCHAR2 | (1) | ||
INTERNAL_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | ||
OUTSIDE_OP_UOM_TYPE | VARCHAR2 | (25) | ||
ALLOW_ITEM_DESC_UPDATE_FLAG | VARCHAR2 | (1) | ||
ALLOWED_UNITS_LOOKUP_CODE | NUMBER | |||
PURCHASING_ENABLED_FLAG | VARCHAR2 | (1) | ||
INV_PLANNED_ITEM_FLAG | VARCHAR2 | (1) | ||
MRP_PLANNED_ITEM_FLAG | VARCHAR2 | (1) | ||
ASSET_INVENTORY | NUMBER | |||
SOURCE_DOCUMENT | VARCHAR2 | (20) | ||
CHARGE_ACCOUNT_ID | NUMBER | |||
DEST_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
TAX_NAME | VARCHAR2 | (0) | ||
TAX_USER_OVERRIDE_FLAG | VARCHAR2 | (1) | ||
TAX_CODE_ID | NUMBER | |||
OKE_CONTRACT_HEADER_ID | NUMBER | |||
OKE_CONTRACT_VERSION_ID | NUMBER | |||
ITEM_SOURCE_ID | NUMBER | |||
SUPPLIER_REF_NUMBER | VARCHAR2 | (150) | ||
SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
SECONDARY_QUANTITY | NUMBER | |||
PREFERRED_GRADE | VARCHAR2 | (150) | ||
SECONDARY_QUANTITY_RECEIVED | NUMBER | |||
SECONDARY_QUANTITY_CANCELLED | NUMBER | |||
AUCTION_HEADER_ID | NUMBER | Identifier for the auction header | ||
AUCTION_DISPLAY_NUMBER | VARCHAR2 | (40) | Auction display number | |
AUCTION_LINE_NUMBER | NUMBER | identifier for the auction line number | ||
REQS_IN_POOL_FLAG | VARCHAR2 | (1) | Requisition demand flag | |
AMOUNT | NUMBER | Line Amount | ||
CURRENCY_AMOUNT | NUMBER | Foreign Currency Line amount | ||
PURCHASE_BASIS | VARCHAR2 | (30) | Yes | Purchase basis of the line |
DROP_SHIP_FLAG | VARCHAR2 | (1) | Indicates whether the Shipment has a backing Sales Order Line. | |
SUGGESTED_VENDOR_CONTACT_FAX | VARCHAR2 | (25) | Supplier fax information | |
SUGGESTED_VENDOR_CONTACT_EMAIL | VARCHAR2 | (2000) | Supplier Email information | |
MATCHING_BASIS | VARCHAR2 | (30) | Yes | Matching basis of the line |
BASE_UNIT_PRICE | NUMBER | Base Unit Price | ||
NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | (1) | ||
TRACKING_SECONDARY_DEFAULT_IND | VARCHAR2 | (30) | ||
GRADE_CONTROL_FLAG | VARCHAR2 | (1) | ||
AT_SOURCING_FLAG | VARCHAR2 | (1) | ||
ORG_ID | NUMBER | Organization identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, REQUISITION_HEADER_ID
, REQUISITION_LINE_ID
, LINE_NUM
, LINE_TYPE
, LINE_TYPE_ID
, ITEM_ID
, ITEM_REVISION
, CATEGORY_ID
, ITEM_DESCRIPTION
, QUANTITY
, QUANTITY_RECEIVED
, QUANTITY_DELIVERED
, QUANTITY_CANCELLED
, UNIT_MEAS_LOOKUP_CODE
, UNIT_PRICE
, NEED_BY_DATE
, SUGGESTED_BUYER
, NOTE_TO_AGENT
, SUGGESTED_VENDOR_NAME
, SUGGESTED_VENDOR_LOCATION
, SUGGESTED_VENDOR_CONTACT
, SUGGESTED_VENDOR_PHONE
, RFQ_REQUIRED_FLAG
, ON_RFQ_FLAG
, CANCEL_FLAG
, MODIFIED_BY_AGENT_FLAG
, UN_NUMBER
, HAZARD_CLASS
, TRANSACTION_REASON
, REFERENCE_NUM
, URGENT
, JUSTIFICATION
, NOTE_TO_RECEIVER
, ENCUMBERED_FLAG
, DESTINATION_TYPE_CODE
, SOURCE_TYPE_CODE
, REQUESTOR
, DEST_ORGANIZATION
, DELIVER_TO_LOCATION
, DEST_SUBINVENTORY
, SOURCE_ORGANIZATION
, SOURCE_SUBINVENTORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, OUTSIDE_OP_LINE_TYPE
, DELIVER_TO_LOCATION_ID
, TO_PERSON_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, SUGGESTED_VENDOR_PRODUCT_CODE
, UN_NUMBER_ID
, HAZARD_CLASS_ID
, CURRENCY_CODE
, RATE
, RATE_TYPE
, RATE_DATE
, CURRENCY_UNIT_PRICE
, SUGGESTED_BUYER_ID
, CLOSED_CODE
, LINE_LOCATION_ID
, PARENT_REQ_LINE_ID
, PURCHASING_AGENT_ID
, DOCUMENT_TYPE_CODE
, BLANKET_PO_HEADER_ID
, BLANKET_PO_LINE_NUM
, CANCEL_REASON
, CANCEL_DATE
, AGENT_RETURN_NOTE
, CHANGED_AFTER_RESEARCH_FLAG
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CONTACT_ID
, RESEARCH_AGENT_ID
, ON_LINE_FLAG
, WIP_ENTITY_ID
, WIP_LINE_ID
, WIP_REPETITIVE_SCHEDULE_ID
, WIP_OPERATION_SEQ_NUM
, WIP_RESOURCE_SEQ_NUM
, DESTINATION_CONTEXT
, INVENTORY_SOURCE_CONTEXT
, VENDOR_SOURCE_CONTEXT
, BOM_RESOURCE_ID
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, CLOSED_REASON
, CLOSED_DATE
, TRANSACTION_REASON_CODE
, SOURCE_REQ_LINE_ID
, DEST_ORGANIZATION_ID
, SOURCE_ORGANIZATION_ID
, ORDER_TYPE_LOOKUP_CODE
, RATE_TYPE_DISP
, SOURCE_DOCUMENT_TYPE
, DESTINATION_CUSTOMER_ID
, DESTINATION_ADDRESS_ID
, DESTINATION_USE_ID
, SOURCE_TYPE_DISP
, DESTINATION_TYPE_DISP
, INVENTORY_ASSET_FLAG
, INTERNAL_ORDER_ENABLED_FLAG
, OUTSIDE_OP_UOM_TYPE
, ALLOW_ITEM_DESC_UPDATE_FLAG
, ALLOWED_UNITS_LOOKUP_CODE
, PURCHASING_ENABLED_FLAG
, INV_PLANNED_ITEM_FLAG
, MRP_PLANNED_ITEM_FLAG
, ASSET_INVENTORY
, SOURCE_DOCUMENT
, CHARGE_ACCOUNT_ID
, DEST_ORGANIZATION_CODE
, TAX_NAME
, TAX_USER_OVERRIDE_FLAG
, TAX_CODE_ID
, OKE_CONTRACT_HEADER_ID
, OKE_CONTRACT_VERSION_ID
, ITEM_SOURCE_ID
, SUPPLIER_REF_NUMBER
, SECONDARY_UNIT_OF_MEASURE
, SECONDARY_QUANTITY
, PREFERRED_GRADE
, SECONDARY_QUANTITY_RECEIVED
, SECONDARY_QUANTITY_CANCELLED
, AUCTION_HEADER_ID
, AUCTION_DISPLAY_NUMBER
, AUCTION_LINE_NUMBER
, REQS_IN_POOL_FLAG
, AMOUNT
, CURRENCY_AMOUNT
, PURCHASE_BASIS
, DROP_SHIP_FLAG
, SUGGESTED_VENDOR_CONTACT_FAX
, SUGGESTED_VENDOR_CONTACT_EMAIL
, MATCHING_BASIS
, BASE_UNIT_PRICE
, NEGOTIATED_BY_PREPARER_FLAG
, TRACKING_SECONDARY_DEFAULT_IND
, GRADE_CONTROL_FLAG
, AT_SOURCING_FLAG
, ORG_ID
FROM APPS.PO_REQUISITION_LINES_V;
|
|
|