DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.PO_REQUISITION_LINES_INQ_V

Object Details
Object Name: PO_REQUISITION_LINES_INQ_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_REQUISITION_LINES_INQ_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
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


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 (0)

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
DEST_ORGANIZATION VARCHAR2 (240)

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


WIP_ENTITY VARCHAR2 (240)

WIP_LINE VARCHAR2 (10)

BOM_RESOURCE VARCHAR2 (10)

BOM_RESOURCE_UNIT VARCHAR2 (3)

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_DSP VARCHAR2 (30)

DEST_STOCK_ENABLED_FLAG VARCHAR2 (1)

DEST_INTERNAL_ORDERABLE_FLAG VARCHAR2 (1)

DEST_PURCHASING_ENABLED_FLAG VARCHAR2 (1)

DEST_OUTSIDE_OPERATION_FLAG VARCHAR2 (1)

DEST_INVENTORY_ASSET_FLAG VARCHAR2 (1)

UOM_CLASS_DSP VARCHAR2 (10)

DESTINATION_TYPE_DSP VARCHAR2 (0)

SOURCE_TYPE_DSP VARCHAR2 (0)

SOURCE_DOCUMENT_TYPE_DSP VARCHAR2 (0)

FULL_LEAD_TIME NUMBER


DESTINATION_CUSTOMER_ID NUMBER


DESTINATION_ADDRESS_ID NUMBER


DESTINATION_USE_ID NUMBER


REQUISITION_NUM VARCHAR2 (20) Yes
PREPARER_ID NUMBER (9) Yes
AUTHORIZATION_STATUS VARCHAR2 (25)

AUTHORIZATION_STATUS_DSP VARCHAR2 (0)

TYPE_LOOKUP_CODE VARCHAR2 (25)

DOCUMENT_TYPE_DSP VARCHAR2 (80) Yes
INTERFACE_SOURCE_CODE VARCHAR2 (25)

REQ_DESCRIPTION VARCHAR2 (240)
EMERGENCY_PO_NUM VARCHAR2 (20)
CATALOG_TYPE VARCHAR2 (30)
CATALOG_SOURCE VARCHAR2 (30)
MANUFACTURER_ID NUMBER

MANUFACTURER_NAME VARCHAR2 (240)
MANUFACTURER_PART_NUMBER VARCHAR2 (30)
REQUESTER_EMAIL VARCHAR2 (240)
REQUESTER_FAX VARCHAR2 (60)
REQUESTER_PHONE VARCHAR2 (60)
UNSPSC_CODE VARCHAR2 (30)
OTHER_CATEGORY_CODE VARCHAR2 (30)
SUPPLIER_DUNS VARCHAR2 (60)
TAX_STATUS_INDICATOR VARCHAR2 (30)
NEW_SUPPLIER_FLAG VARCHAR2 (1)
AUTO_RECEIVE_FLAG VARCHAR2 (1)
PCARD_ID VARCHAR2 (40)
TAX_NAME VARCHAR2 (0)
TAX_CODE_ID NUMBER

Tax ID
OKE_CONTRACT_HEADER_ID NUMBER

OKE_CONTRACT_VERSION_ID NUMBER

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

Sourcing reference
AUCTION_DISPLAY_NUMBER VARCHAR2 (40)
Sourcing reference
AUCTION_LINE_NUMBER NUMBER

Sourcing reference
REQS_IN_POOL_FLAG VARCHAR2 (1)
flag to indicate if the requisitions are available in the pool
VMI_FLAG VARCHAR2 (1)
Flag to indicate if this is a VMI line
BID_NUMBER NUMBER

Reference to sourcing Bid number
BID_LINE_NUMBER NUMBER

Reference to sourcing Bid lINE number
SUPPLIER_REF_NUMBER VARCHAR2 (150)
Tracking code that links to a specific configuration of an item. Generated by a configuration engine maintained by suppliers.
AMOUNT NUMBER

Line Amount
CURRENCY_AMOUNT NUMBER

Foreign Currency Line amount
JOB_ID NUMBER

Reference to HR Job
CANDIDATE_FIRST_NAME VARCHAR2 (240)
Candidate First Name
CANDIDATE_LAST_NAME VARCHAR2 (240)
Candidate Last name
ASSIGNMENT_END_DATE DATE

assignment end date for the candidate
LABOR_REQ_LINE_ID NUMBER

Reference to the associated temp labor line
CONTRACTOR_REQUISITION_FLAG VARCHAR2 (1)
indicates if the line belongs to a temp labor req
PURCHASE_BASIS VARCHAR2 (30) Yes Purchase basis for the line
DROP_SHIP_FLAG VARCHAR2 (1)
Indicates whether the Shipment has a backing Sales Order Line.
ASSIGNMENT_START_DATE DATE

Assignment start date for the candidate
ORG_ID NUMBER

Organization identifier
REQUESTING_ORG VARCHAR2 (240)
Requesting Operating Unit Name
PURCHASING_ORG VARCHAR2 (240)
Purchasing Operating Unit Name
SUGGESTED_VENDOR_CONTACT_FAX VARCHAR2 (25)
Supplier fax information
SUGGESTED_VENDOR_CONTACT_EMAIL VARCHAR2 (2000)
Supplier Email information
BASE_UNIT_PRICE NUMBER

Base Unit Price
AT_SOURCING_FLAG VARCHAR2 (1)
CONTRACTOR_STATUS VARCHAR2 (25)
SECURITY_LEVEL_CODE VARCHAR2 (25)
Query Text

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
,      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
,      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
,      WIP_ENTITY
,      WIP_LINE
,      BOM_RESOURCE
,      BOM_RESOURCE_UNIT
,      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_DSP
,      DEST_STOCK_ENABLED_FLAG
,      DEST_INTERNAL_ORDERABLE_FLAG
,      DEST_PURCHASING_ENABLED_FLAG
,      DEST_OUTSIDE_OPERATION_FLAG
,      DEST_INVENTORY_ASSET_FLAG
,      UOM_CLASS_DSP
,      DESTINATION_TYPE_DSP
,      SOURCE_TYPE_DSP
,      SOURCE_DOCUMENT_TYPE_DSP
,      FULL_LEAD_TIME
,      DESTINATION_CUSTOMER_ID
,      DESTINATION_ADDRESS_ID
,      DESTINATION_USE_ID
,      REQUISITION_NUM
,      PREPARER_ID
,      AUTHORIZATION_STATUS
,      AUTHORIZATION_STATUS_DSP
,      TYPE_LOOKUP_CODE
,      DOCUMENT_TYPE_DSP
,      INTERFACE_SOURCE_CODE
,      REQ_DESCRIPTION
,      EMERGENCY_PO_NUM
,      CATALOG_TYPE
,      CATALOG_SOURCE
,      MANUFACTURER_ID
,      MANUFACTURER_NAME
,      MANUFACTURER_PART_NUMBER
,      REQUESTER_EMAIL
,      REQUESTER_FAX
,      REQUESTER_PHONE
,      UNSPSC_CODE
,      OTHER_CATEGORY_CODE
,      SUPPLIER_DUNS
,      TAX_STATUS_INDICATOR
,      NEW_SUPPLIER_FLAG
,      AUTO_RECEIVE_FLAG
,      PCARD_ID
,      TAX_NAME
,      TAX_CODE_ID
,      OKE_CONTRACT_HEADER_ID
,      OKE_CONTRACT_VERSION_ID
,      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
,      VMI_FLAG
,      BID_NUMBER
,      BID_LINE_NUMBER
,      SUPPLIER_REF_NUMBER
,      AMOUNT
,      CURRENCY_AMOUNT
,      JOB_ID
,      CANDIDATE_FIRST_NAME
,      CANDIDATE_LAST_NAME
,      ASSIGNMENT_END_DATE
,      LABOR_REQ_LINE_ID
,      CONTRACTOR_REQUISITION_FLAG
,      PURCHASE_BASIS
,      DROP_SHIP_FLAG
,      ASSIGNMENT_START_DATE
,      ORG_ID
,      REQUESTING_ORG
,      PURCHASING_ORG
,      SUGGESTED_VENDOR_CONTACT_FAX
,      SUGGESTED_VENDOR_CONTACT_EMAIL
,      BASE_UNIT_PRICE
,      AT_SOURCING_FLAG
,      CONTRACTOR_STATUS
,      SECURITY_LEVEL_CODE
FROM APPS.PO_REQUISITION_LINES_INQ_V;

Dependencies

[top of page]

APPS.PO_REQUISITION_LINES_INQ_V references the following:

SchemaAPPS
SynonymBOM_RESOURCES
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
SynonymGL_DAILY_CONVERSION_TYPES
ViewGL_SETS_OF_BOOKS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_LOCATIONS_ALL_TL
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_UNITS_OF_MEASURE
SynonymPO_DOCUMENT_TYPES_ALL_B
SynonymPO_DOCUMENT_TYPES_ALL_TL
SynonymPO_HAZARD_CLASSES_TL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_LINE_TYPES_B
SynonymPO_LINE_TYPES_TL
SynonymPO_LOCATION_ASSOCIATIONS_ALL
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES
SynonymPO_UN_NUMBERS_TL
SynonymWIP_ENTITIES
SynonymWIP_LINES

APPS.PO_REQUISITION_LINES_INQ_V is not referenced by any database object