[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | POFV_REQUISITION_LINES |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PO.POFV_REQUISITION_LINES
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
This shows item information for a good or service on a requisition.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REQUISITION_LINE_ID | NUMBER | Yes | ||
| LINE_NUMBER | NUMBER | Yes | ||
| REQUISITION_ID | NUMBER | Yes | ||
| REQUISITION_DOCUMENT_NUMBER | VARCHAR2 | (20) | Yes | |
| OPERATING_UNIT_ID | NUMBER | |||
| OPERATING_UNIT_NAME | VARCHAR2 | (240) | Yes | |
| _LA:DOCUMENT_TYPE | CHAR | (72) | ||
| LINE_TYPE | VARCHAR2 | (25) | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Yes | |
| UNIT_PRICE | NUMBER | |||
| REQUESTED_QUANTITY | NUMBER | |||
| DELIVERED_QUANTITY | NUMBER | |||
| RECEIVED_QUANTITY | NUMBER | |||
| CANCELLED_QUANTITY | NUMBER | |||
| NEED_BY_DATE | DATE | |||
| _LA:DESTINATION_TYPE | CHAR | (77) | ||
| _LA:CANCEL_FLAG | CHAR | (57) | ||
| CANCEL_DATE | DATE | |||
| CANCEL_REASON | VARCHAR2 | (240) | ||
| _LA:CLOSURE_STATUS | CHAR | (65) | ||
| CLOSED_DATE | DATE | |||
| CLOSED_REASON | VARCHAR2 | (240) | ||
| CURRENCY_CONVERSION_RATE | NUMBER | |||
| CURRENCY_CONVERSION_RATE_DATE | DATE | |||
| FOREIGN_CURRENCY_UNIT_PRICE | NUMBER | |||
| _LA:ENCUMBERED_FLAG | CHAR | (61) | ||
| JUSTIFICATION | VARCHAR2 | (480) | ||
| _LA:MODIFIED_BY_BUYER_FLAG | CHAR | (68) | ||
| _LA:ON_RFQ_FLAG | CHAR | (57) | ||
| BUYER_NOTE | VARCHAR2 | (480) | ||
| RECEIVER_NOTE | VARCHAR2 | (480) | ||
| REFERENCE_NUMBER | VARCHAR2 | (25) | ||
| _LA:RFQ_REQUIRED_FLAG | CHAR | (63) | ||
| _LA:SOURCE_DOCUMENT_TYPE | CHAR | (78) | ||
| _LA:REQUISITION_SOURCE_TYPE | CHAR | (79) | ||
| SUGGESTED_SUPPLIER | VARCHAR2 | (240) | ||
| SUGGESTED_SUPPLIER_SITE | VARCHAR2 | (240) | ||
| SUGGESTED_SUPPLIER_CONTACT | VARCHAR2 | (80) | ||
| SUGGESTED_SUPPLIER_PHONE | VARCHAR2 | (25) | ||
| SUGGESTED_VENDOR_CONTACT_FAX | VARCHAR2 | (25) | Supplier fax information | |
| SUGGESTED_VENDOR_CONTACT_EMAIL | VARCHAR2 | (2000) | Supplier Email information | |
| SUGGESTED_SUPPLIER_PRODUCT_NUM | VARCHAR2 | (25) | ||
| SOURCE_SUBINVENTORY | VARCHAR2 | (10) | ||
| TRANSACTION_REASON | VARCHAR2 | (25) | ||
| _LA:URGENT_FLAG | CHAR | (57) | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
| _DF | CHAR | (30) | ||
| ITEM_ID | NUMBER | |||
| _KF:ITEM_NUMBER::_CO | CHAR | (15) | ||
| ITEM_REVISION | VARCHAR2 | (3) | ||
| ITEM_ORGANIZATION_ID | NUMBER | |||
| ITEM_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
| CATEGORY_ID | NUMBER | Yes | ||
| _KF:CATEGORY::_CO | CHAR | (15) | ||
| UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
| UOM_CLASS | VARCHAR2 | (10) | ||
| UOM_DESCRIPTION | VARCHAR2 | (50) | ||
| DESTINATION_ORGANIZATION_ID | NUMBER | |||
| DESTINATION_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
| DESTINATION_ORGANIZATION_NAME | VARCHAR2 | (240) | ||
| DESTINATION_SUBINVENTORY | VARCHAR2 | (10) | ||
| HAZARD_CLASS_ID | NUMBER | |||
| HAZARD_CLASS | VARCHAR2 | (40) | ||
| UN_NUMBER_ID | NUMBER | |||
| UN_NUMBER | VARCHAR2 | (25) | ||
| CURRENCY_CODE | VARCHAR2 | (15) | ||
| CURRENCY | VARCHAR2 | (80) | ||
| CURRENCY_CONVERSION_RATE_TYPE | VARCHAR2 | (30) | ||
| RATE_TYPE_NAME | VARCHAR2 | (30) | ||
| RATE_TYPE_DESCRIPTION | VARCHAR2 | (240) | ||
| DELIVER_TO_LOCATION_ID | NUMBER | Yes | ||
| DELIVER_TO_LOCATION | VARCHAR2 | (60) | ||
| DELIVER_TO_PERSON_ID | NUMBER | (9) | Yes | |
| DELIVER_TO_PERSON | VARCHAR2 | (240) | ||
| SUGGESTED_BUYER_ID | NUMBER | (9) | ||
| SUGGESTED_BUYER_EMP_NUMBER | VARCHAR2 | (30) | ||
| SUGGESTED_BUYER_NAME | VARCHAR2 | (240) | ||
| SOURCE_ORGANIZATION_ID | NUMBER | |||
| SOURCE_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
| SOURCE_ORGANIZATION_NAME | VARCHAR2 | (240) | ||
| MODIFICATION_BUYER_ID | NUMBER | (9) | ||
| MODIFICATION_BUYER_EMP_NUMBER | VARCHAR2 | (30) | ||
| MODIFICATION_BUYER_NAME | VARCHAR2 | (240) | ||
| SOURCE_DOCUMENT_ID | NUMBER | |||
| SOURCE_DOCUMENT_NUMBER | VARCHAR2 | (20) | ||
| SOURCE_DOCUMENT_LINE_NUMBER | NUMBER | |||
| SHIPMENT_ID | NUMBER | |||
| SHIPMENT_NUMBER | NUMBER | |||
| PARENT_REQUISITION_LINE_ID | NUMBER | |||
| PARENT_REQUISITION_LINE_NUMBER | NUMBER | |||
| BILL_OF_MATERIAL_RESOURCE_ID | NUMBER | |||
| BILL_OF_MATERIAL_RESOURCE | VARCHAR2 | (10) | ||
| WIP_ENTITY_ID | NUMBER | |||
| WIP_JOB_NAME | VARCHAR2 | (240) | ||
| WIP_LINE_ID | NUMBER | |||
| WIP_LINE_CODE | VARCHAR2 | (10) | ||
| WIP_REPETITIVE_SCHEDULE_ID | NUMBER | |||
| WIP_OPERATION_SEQUENCE_NUMBER | NUMBER | |||
| WIP_RESOURCE_SEQUENCE_NUMBER | NUMBER | |||
| CREATED_DATE | DATE | |||
| CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
| LAST_UPDATED_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| SECONDARY_QUANTITY | NUMBER | |||
| SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
| PREFERRED_GRADE | VARCHAR2 | (150) | ||
| SECONDARY_QUANTITY_RECEIVED | NUMBER | |||
| SECONDARY_QUANTITY_CANCELLED | NUMBER | |||
| AUCTION_DISPLAY_NUMBER | VARCHAR2 | (40) | ||
| AUCTION_HEADER_ID | NUMBER | |||
| AUCTION_LINE_NUMBER | NUMBER | |||
| BID_NUMBER | NUMBER | |||
| BID_LINE_NUMBER | NUMBER | |||
| _LA:REQS_IN_POOL_FLAG | CHAR | (63) | ||
| OKE_CONTRACT_HEADER_ID | NUMBER | |||
| OKE_CONTRACT_VERSION_ID | NUMBER | |||
| OKE_CONTRACT_NUM | VARCHAR2 | (120) | ||
| OKE_CONTRACT_VERSION_NUM | NUMBER | (4) | ||
| OKE_CONTRACT_LINE_NUM | VARCHAR2 | (150) | ||
| _LA:VMI_FLAG | CHAR | (54) | ||
| NOTE_TO_VENDOR | VARCHAR2 | (480) | ||
| _LA:PCARD_FLAG | CHAR | (56) | ||
| _LA:TAX_USER_OVERRIDE_FLAG | CHAR | (68) | ||
| SHIP_METHOD | VARCHAR2 | (30) | Ship method (References WSH_CARRIER_SERVICES.ship_method_code.) | |
| ESTIMATED_PICKUP_DATE | DATE | Estimated pickup date. | ||
| SUPPLIER_NOTIFIED_FOR_CANCEL | VARCHAR2 | (1) | Indicates whether a cancellation notification has been sent to the supplier for this requisition line. | |
| BASE_UNIT_PRICE | NUMBER | Base Unit Price | ||
| NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | (1) | ||
| DROP_SHIP_FLAG | VARCHAR2 | (1) | Indicates whether the Shipment has a backing Sales Order Line. | |
| SALES_ORDER_UPDATE_DATE | DATE | The date/time when any of referenced data elements on the backing Sales Order Line is updated. | ||
| AMOUNT | NUMBER | Amount on the req line | ||
| CURRENCY_AMOUNT | NUMBER | Foreign currency amount on the req line | ||
| LABOR_REQ_LINE_ID | NUMBER | Stored the referenced temp labor requisition line id for an expence line | ||
| JOB_ID | NUMBER | Reference to the HR Job | ||
| JOB_NAME | VARCHAR2 | (700) | Name of the HR Job | |
| JOB_LONG_DESCRIPTION | VARCHAR2 | (2000) | Job Detailed Description | |
| CONTRACTOR_STATUS | VARCHAR2 | (25) | Resource finalization status for temp labor req lines | |
| CONTACT_INFORMATION | VARCHAR2 | (240) | Job Contact Information | |
| CANDIDATE_SCREENING_REQD_FLAG | VARCHAR2 | (1) | Flag to indicate if candidate screening is required | |
| CANDIDATE_FIRST_NAME | VARCHAR2 | (240) | First Name of the Candidate | |
| CANDIDATE_LAST_NAME | VARCHAR2 | (240) | Last Name of the Candidate | |
| ASSIGNMENT_END_DATE | DATE | End date for the candidate assignment | ||
| OVERTIME_ALLOWED_FLAG | VARCHAR2 | (1) | Flag to indicate if overtime is allowed | |
| CONTRACTOR_REQUISITION_FLAG | VARCHAR2 | (1) | Indicates if the req is a temp labor req | |
| ASSIGNMENT_START_DATE | DATE | Assignment start date for the candidate | ||
| ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Yes | Value Basis of the line type |
| PURCHASE_BASIS | VARCHAR2 | (30) | Yes | Purchase Basis of the line type |
| MATCHING_BASIS | VARCHAR2 | (30) | Yes | Matching Basis of the line type |
| AT_SOURCING_FLAG | VARCHAR2 | (1) | At Sourcing Flag |
Cut, paste (and edit) the following text to query this object:
SELECT REQUISITION_LINE_ID
, LINE_NUMBER
, REQUISITION_ID
, REQUISITION_DOCUMENT_NUMBER
, OPERATING_UNIT_ID
, OPERATING_UNIT_NAME
, _LA:DOCUMENT_TYPE
, LINE_TYPE
, ITEM_DESCRIPTION
, UNIT_PRICE
, REQUESTED_QUANTITY
, DELIVERED_QUANTITY
, RECEIVED_QUANTITY
, CANCELLED_QUANTITY
, NEED_BY_DATE
, _LA:DESTINATION_TYPE
, _LA:CANCEL_FLAG
, CANCEL_DATE
, CANCEL_REASON
, _LA:CLOSURE_STATUS
, CLOSED_DATE
, CLOSED_REASON
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_RATE_DATE
, FOREIGN_CURRENCY_UNIT_PRICE
, _LA:ENCUMBERED_FLAG
, JUSTIFICATION
, _LA:MODIFIED_BY_BUYER_FLAG
, _LA:ON_RFQ_FLAG
, BUYER_NOTE
, RECEIVER_NOTE
, REFERENCE_NUMBER
, _LA:RFQ_REQUIRED_FLAG
, _LA:SOURCE_DOCUMENT_TYPE
, _LA:REQUISITION_SOURCE_TYPE
, SUGGESTED_SUPPLIER
, SUGGESTED_SUPPLIER_SITE
, SUGGESTED_SUPPLIER_CONTACT
, SUGGESTED_SUPPLIER_PHONE
, SUGGESTED_VENDOR_CONTACT_FAX
, SUGGESTED_VENDOR_CONTACT_EMAIL
, SUGGESTED_SUPPLIER_PRODUCT_NUM
, SOURCE_SUBINVENTORY
, TRANSACTION_REASON
, _LA:URGENT_FLAG
, USSGL_TRANSACTION_CODE
, _DF
, ITEM_ID
, _KF:ITEM_NUMBER::_CO
, ITEM_REVISION
, ITEM_ORGANIZATION_ID
, ITEM_ORGANIZATION_CODE
, CATEGORY_ID
, _KF:CATEGORY::_CO
, UNIT_OF_MEASURE
, UOM_CLASS
, UOM_DESCRIPTION
, DESTINATION_ORGANIZATION_ID
, DESTINATION_ORGANIZATION_CODE
, DESTINATION_ORGANIZATION_NAME
, DESTINATION_SUBINVENTORY
, HAZARD_CLASS_ID
, HAZARD_CLASS
, UN_NUMBER_ID
, UN_NUMBER
, CURRENCY_CODE
, CURRENCY
, CURRENCY_CONVERSION_RATE_TYPE
, RATE_TYPE_NAME
, RATE_TYPE_DESCRIPTION
, DELIVER_TO_LOCATION_ID
, DELIVER_TO_LOCATION
, DELIVER_TO_PERSON_ID
, DELIVER_TO_PERSON
, SUGGESTED_BUYER_ID
, SUGGESTED_BUYER_EMP_NUMBER
, SUGGESTED_BUYER_NAME
, SOURCE_ORGANIZATION_ID
, SOURCE_ORGANIZATION_CODE
, SOURCE_ORGANIZATION_NAME
, MODIFICATION_BUYER_ID
, MODIFICATION_BUYER_EMP_NUMBER
, MODIFICATION_BUYER_NAME
, SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_NUMBER
, SOURCE_DOCUMENT_LINE_NUMBER
, SHIPMENT_ID
, SHIPMENT_NUMBER
, PARENT_REQUISITION_LINE_ID
, PARENT_REQUISITION_LINE_NUMBER
, BILL_OF_MATERIAL_RESOURCE_ID
, BILL_OF_MATERIAL_RESOURCE
, WIP_ENTITY_ID
, WIP_JOB_NAME
, WIP_LINE_ID
, WIP_LINE_CODE
, WIP_REPETITIVE_SCHEDULE_ID
, WIP_OPERATION_SEQUENCE_NUMBER
, WIP_RESOURCE_SEQUENCE_NUMBER
, CREATED_DATE
, CREATED_BY
, LAST_UPDATED_DATE
, LAST_UPDATED_BY
, SECONDARY_QUANTITY
, SECONDARY_UNIT_OF_MEASURE
, PREFERRED_GRADE
, SECONDARY_QUANTITY_RECEIVED
, SECONDARY_QUANTITY_CANCELLED
, AUCTION_DISPLAY_NUMBER
, AUCTION_HEADER_ID
, AUCTION_LINE_NUMBER
, BID_NUMBER
, BID_LINE_NUMBER
, _LA:REQS_IN_POOL_FLAG
, OKE_CONTRACT_HEADER_ID
, OKE_CONTRACT_VERSION_ID
, OKE_CONTRACT_NUM
, OKE_CONTRACT_VERSION_NUM
, OKE_CONTRACT_LINE_NUM
, _LA:VMI_FLAG
, NOTE_TO_VENDOR
, _LA:PCARD_FLAG
, _LA:TAX_USER_OVERRIDE_FLAG
, SHIP_METHOD
, ESTIMATED_PICKUP_DATE
, SUPPLIER_NOTIFIED_FOR_CANCEL
, BASE_UNIT_PRICE
, NEGOTIATED_BY_PREPARER_FLAG
, DROP_SHIP_FLAG
, SALES_ORDER_UPDATE_DATE
, AMOUNT
, CURRENCY_AMOUNT
, LABOR_REQ_LINE_ID
, JOB_ID
, JOB_NAME
, JOB_LONG_DESCRIPTION
, CONTRACTOR_STATUS
, CONTACT_INFORMATION
, CANDIDATE_SCREENING_REQD_FLAG
, CANDIDATE_FIRST_NAME
, CANDIDATE_LAST_NAME
, ASSIGNMENT_END_DATE
, OVERTIME_ALLOWED_FLAG
, CONTRACTOR_REQUISITION_FLAG
, ASSIGNMENT_START_DATE
, ORDER_TYPE_LOOKUP_CODE
, PURCHASE_BASIS
, MATCHING_BASIS
, AT_SOURCING_FLAG
FROM APPS.POFV_REQUISITION_LINES;
APPS
BOM_RESOURCES
FINANCIALS_SYSTEM_PARAMS_ALL
FND_CURRENCIES_VL
GL_DAILY_CONVERSION_TYPES
HR_ALL_ORGANIZATION_UNITS
HR_GENERAL
- show dependent code
HR_LOCATIONS
HR_PERSON_NAME
- show dependent code
HR_SECURITY
- show dependent code
MTL_CATEGORIES
MTL_ITEM_REVISIONS
MTL_PARAMETERS
MTL_SECONDARY_INVENTORIES
MTL_SYSTEM_ITEMS
MTL_UNITS_OF_MEASURE
OKC_K_HEADERS_B
OKC_K_LINES_B
OKC_K_VERS_NUMBERS_V
PER_JOBS_VL
PER_PEOPLE_F
PO_HAZARD_CLASSES
PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_LINE_TYPES
PO_REQUISITION_HEADERS_ALL
PO_REQUISITION_LINES_ALL
PO_UN_NUMBERS
WIP_ENTITIES
WIP_LINES
WIP_OPERATIONS
WIP_OPERATION_RESOURCES
APPS.POFV_REQUISITION_LINES is not referenced by any database object
|
|
|
|