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

VIEW: APPS.PO_CLMREQ_LINES_V

Object Details
Object Name: PO_CLMREQ_LINES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUISITION_HEADER_ID NUMBER
Yes Requisition header unique identifier
REQUISITION_NUM VARCHAR2 (20) Yes Line number
PREPARER_ID NUMBER (9) Yes Requisition line unique identifier
REQUISITION_LINE_ID NUMBER
Yes Requisition line unique identifier
LINE_NUM NUMBER
Yes Line number
LINE_TYPE_ID NUMBER
Yes Line type
CATEGORY_ID NUMBER

Item category unique identifier
ITEM_DESCRIPTION VARCHAR2 (240) Yes Item description
UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
Unit of measure
UNIT_PRICE NUMBER

Unit price in functional currency
QUANTITY NUMBER

Quantity ordered
DELIVER_TO_LOCATION_ID NUMBER

Deliver-to location unique identifier
TO_PERSON_ID NUMBER (9) Yes Requester unique identifier
SOURCE_TYPE_CODE VARCHAR2 (25) Yes Requisition source type of item
ITEM_ID NUMBER

Item unique identifier
ITEM_REVISION VARCHAR2 (3)
Item revision
QUANTITY_DELIVERED NUMBER

Quantity delivered to date
SUGGESTED_BUYER_ID NUMBER (9)
Suggested buyer unique identifier
ENCUMBERED_FLAG VARCHAR2 (1)
Indicates whether the distribution is encumbered. When encumbrance is not enabled, this column will be used as an internal flag.
RFQ_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether an RFQ is required prior to placement on a purchase order
NEED_BY_DATE DATE

Date the requisition is needed internally
LINE_LOCATION_ID NUMBER

Document shipment schedule unique identifier
MODIFIED_BY_AGENT_FLAG VARCHAR2 (1)
Indicates whether a buyer modified this line or not
PARENT_REQ_LINE_ID NUMBER

Unique identifier of the parent requisition line for a modified requisition line
PURCHASING_AGENT_ID NUMBER (9)
Unique identifier of the buyer who modified the requisition line
DOCUMENT_TYPE_CODE VARCHAR2 (25)
Source document type
BLANKET_PO_HEADER_ID NUMBER

Suggested source blanket agreement or catalog quotation header unique identifier
BLANKET_PO_LINE_NUM NUMBER

Suggested source blanket agreement or catalog quotation line number
CURRENCY_CODE VARCHAR2 (15)
Unique identifier for the currency
RATE_TYPE VARCHAR2 (30)
Currency conversion rate type
RATE_DATE DATE

Currency conversion rate date
RATE NUMBER

Currency conversion rate
CURRENCY_UNIT_PRICE NUMBER

Foreign currency unit price
SUGGESTED_VENDOR_NAME VARCHAR2 (240)
Suggested supplier name
SUGGESTED_VENDOR_LOCATION VARCHAR2 (240)
Suggested supplier site name
SUGGESTED_VENDOR_CONTACT VARCHAR2 (80)
Suggested supplier contact name
SUGGESTED_VENDOR_PHONE VARCHAR2 (25)
Suggested supplier phone number
SUPPLIER_ITEM VARCHAR2 (25)
Suggested supplier product number
UN_NUMBER_ID NUMBER

UN number unique identifier
HAZARD_CLASS_ID NUMBER

Hazard class unique identifier
MUST_USE_SUGG_VENDOR_FLAG VARCHAR2 (1)
Unused since release 8.0
REFERENCE_NUM VARCHAR2 (25)
Reference number
ON_RFQ_FLAG VARCHAR2 (1)
Indicates whether the requisition line was placed on an RFQ
URGENT_FLAG VARCHAR2 (1)
Indicates whether the requisition is urgent or not
CANCEL_FLAG VARCHAR2 (1)
Indicates whether the requisition is cancelled or not
SOURCE_ORGANIZATION_ID NUMBER

Inventory source organization unique identifier
SOURCE_SUBINVENTORY VARCHAR2 (10)
Inventory source subinventory name
DESTINATION_TYPE_CODE VARCHAR2 (25)
Destination type
DESTINATION_ORGANIZATION_ID NUMBER

Destination organization unique identifier
DESTINATION_SUBINVENTORY VARCHAR2 (10)
Destination subinventory name
QUANTITY_CANCELLED NUMBER

Quantity cancelled
CANCEL_DATE DATE

Cancel date
CANCEL_REASON VARCHAR2 (240)
Cancel reason
CLOSED_CODE VARCHAR2 (25)
Close status
VENDOR_ID NUMBER

Supplier unique identifier
VENDOR_SITE_ID NUMBER

Supplier site unique identifier
VENDOR_CONTACT_ID NUMBER

Supplier contact unique identifier
ON_LINE_FLAG VARCHAR2 (1)
Unused since release 7.0
DESTINATION_CONTEXT VARCHAR2 (30)
Destination descriptive flexfield context column
INVENTORY_SOURCE_CONTEXT VARCHAR2 (30)
Inventory source descriptive flexfield context column
VENDOR_SOURCE_CONTEXT VARCHAR2 (30)
Supplier source descriptive flexfield context column
BOM_RESOURCE_ID NUMBER

BOM resource unique identifier
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States standard general ledger transaction code
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL descriptive flexfield context column
CLOSED_REASON VARCHAR2 (240)
Close reason
CLOSED_DATE DATE

Close date
TRANSACTION_REASON_CODE VARCHAR2 (25)
Transaction reason
SOURCE_REQ_LINE_ID NUMBER

Source requisition line identifier
ORG_ID NUMBER

Organization identifier
KANBAN_CARD_ID NUMBER

Primary key for the Kanban Card
CATALOG_TYPE VARCHAR2 (30)
Catalog type
CATALOG_SOURCE VARCHAR2 (30)
Catalog source
MANUFACTURER_ID NUMBER

Manufacturer unique identifier
MANUFACTURER_NAME VARCHAR2 (240)
Manufacturer name
MANUFACTURER_PART_NUMBER VARCHAR2 (150)
Manufacturer part number
REQUESTER_EMAIL VARCHAR2 (240)
Requester e-mail address
REQUESTER_FAX VARCHAR2 (60)
Requester facsimile number
REQUESTER_PHONE VARCHAR2 (60)
Requester phone number
UNSPSC_CODE VARCHAR2 (30)
Standard Product and Service Code
OTHER_CATEGORY_CODE VARCHAR2 (30)
Other category code
SUPPLIER_DUNS VARCHAR2 (60)
Data Universal Numbering System Code
PCARD_FLAG VARCHAR2 (1)
Indicator that this line is ordered using a procurement card
NEW_SUPPLIER_FLAG VARCHAR2 (1)
Indicator that this is a new supplier
AUTO_RECEIVE_FLAG VARCHAR2 (1)
Allow auto-receiving
ITEM_SOURCE_ID NUMBER

Used only for the reference to item sources table
SUPPLIER_REF_NUMBER VARCHAR2 (150)
Reference Number for the Supplier
PREFERRED_GRADE VARCHAR2 (150)
Preferred quality grade of the item ordered
VMI_FLAG VARCHAR2 (1)
Indicates VMI requisition with value = 'Y'
AUCTION_HEADER_ID NUMBER

Reference to sourcing auction id
AUCTION_DISPLAY_NUMBER VARCHAR2 (40)
Reference to sourcing auction number
AUCTION_LINE_NUMBER NUMBER

reference to sourcing auction line number
REQS_IN_POOL_FLAG VARCHAR2 (1)
Flag to indicate if the requisitions are available for PO creation
BID_NUMBER NUMBER

Reference to sourcing bid number
BID_LINE_NUMBER NUMBER

Reference to sourcing bid line number
NONCAT_TEMPLATE_ID NUMBER

Non-Catalog Request template identifier
SUGGESTED_VENDOR_CONTACT_FAX VARCHAR2 (25)
Supplier contact fax number
SUGGESTED_VENDOR_CONTACT_EMAIL VARCHAR2 (2000)
Supplier email contact information
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_LONG_DESCRIPTION VARCHAR2 (2000)
Job Detailed Description
CONTACT_INFORMATION VARCHAR2 (240)
Job Contact Information
SUGGESTED_SUPPLIER_FLAG VARCHAR2 (1)
Flag to indicate if the supplier is from an ASL or user suggested
ASSIGNMENT_END_DATE DATE

End date for the candidate assignment
CONTRACTOR_REQUISITION_FLAG VARCHAR2 (1)
Indicates if the req is a temp labor req
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
ORDER_TYPE_LOOKUP_CODE VARCHAR2 (25) Yes Value Basis of the line type
PURCHASE_BASIS VARCHAR2 (30) Yes Value Basis of the line type
MATCHING_BASIS VARCHAR2 (30) Yes Matching Basis of the line type
NEGOTIATED_BY_PREPARER_FLAG VARCHAR2 (1)
Indicates whether price has been negotiated by buyer
SHIP_METHOD VARCHAR2 (30)
Ship method (References WSH_CARRIER_SERVICES.ship_method_code.)
BASE_UNIT_PRICE NUMBER

Base Unit Price
AT_SOURCING_FLAG VARCHAR2 (1)
Whether or not this requisition line is part of an active sourcing negotiation. If 'Y', the req line is part of an active negotiation in Oracle Sourcing. If 'N' or 'NULL', the requisition line is not part of an active negotation in Oracle Sourcing.
CONFORMED_LINE_ID NUMBER

Populated only for Amendment records and stores the requisition_line_id of the parent requisition line
LINE_NUM_DISPLAY VARCHAR2 (100)
Stores the line number for federal requisitions
GROUP_LINE_ID NUMBER

Stores the requisition_line_id of the CLIN
CLM_INFO_FLAG VARCHAR2 (1)
States whether this is an informational line
CLM_OPTION_INDICATOR VARCHAR2 (1)
States whether this is an optional line
CLM_BASE_LINE_NUM NUMBER

Stores the requisition_line_id of the base line and is populated only for optional line
CLM_OPTION_NUM NUMBER

Stores the option line number
CLM_OPTION_FROM_DATE DATE

Stores the option start date
CLM_OPTION_TO_DATE DATE

Stores the option end date
CLM_FUNDED_FLAG VARCHAR2 (1)
States whether this is a funded line or not.
UDA_TEMPLATE_ID NUMBER

Uda Template Id
CONTRACT_TYPE VARCHAR2 (100)
Contract Type for Complex Pricing
COST_CONSTRAINT VARCHAR2 (100)
Cost Constraint for Complex Pricing
CLM_PERIOD_PERF_START_DATE DATE

The Start date for CLM period performance.
CLM_PERIOD_PERF_END_DATE DATE

The End date for CLM period performance.
CLM_EXTENDED_ITEM_DESCRIPTION VARCHAR2 (4000)
Extended Item Description.
CLM_OPTION_EXERCISED VARCHAR2 (1)
States whether the option line is exercised.
IS_LINE_NUM_DISPLAY_MODIFIED VARCHAR2 (1)
Stores whether the line num display is modified by user manually.
ASSIGNMENT_NUMBER VARCHAR2 (30)
Assignment Number
PO_DRAFT_ID NUMBER

po_draft_id of the modification
PO_LINE_ID NUMBER

po_Line_id in the modification
CLM_EXERCISED_DATE DATE

Date When optiion line is exercised.
LINKED_TO_FUND VARCHAR2 (1)
Indicates whether the line is only used to add funds
FUND_SOURCE_NOT_KNOWN VARCHAR2 (1)
This column indicates if the requisition line has distributions or not
CREATION_DATE DATE

Standard who column - date when this row was created.
FUNDED_VALUE NUMBER

Assignment Number
FUNDS_USED NUMBER

Assignment Number
FUNDS_REMAINING NUMBER

Assignment Number
REVISION_NUM NUMBER

Revision number
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUISITION_HEADER_ID
,      REQUISITION_NUM
,      PREPARER_ID
,      REQUISITION_LINE_ID
,      LINE_NUM
,      LINE_TYPE_ID
,      CATEGORY_ID
,      ITEM_DESCRIPTION
,      UNIT_MEAS_LOOKUP_CODE
,      UNIT_PRICE
,      QUANTITY
,      DELIVER_TO_LOCATION_ID
,      TO_PERSON_ID
,      SOURCE_TYPE_CODE
,      ITEM_ID
,      ITEM_REVISION
,      QUANTITY_DELIVERED
,      SUGGESTED_BUYER_ID
,      ENCUMBERED_FLAG
,      RFQ_REQUIRED_FLAG
,      NEED_BY_DATE
,      LINE_LOCATION_ID
,      MODIFIED_BY_AGENT_FLAG
,      PARENT_REQ_LINE_ID
,      PURCHASING_AGENT_ID
,      DOCUMENT_TYPE_CODE
,      BLANKET_PO_HEADER_ID
,      BLANKET_PO_LINE_NUM
,      CURRENCY_CODE
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      CURRENCY_UNIT_PRICE
,      SUGGESTED_VENDOR_NAME
,      SUGGESTED_VENDOR_LOCATION
,      SUGGESTED_VENDOR_CONTACT
,      SUGGESTED_VENDOR_PHONE
,      SUPPLIER_ITEM
,      UN_NUMBER_ID
,      HAZARD_CLASS_ID
,      MUST_USE_SUGG_VENDOR_FLAG
,      REFERENCE_NUM
,      ON_RFQ_FLAG
,      URGENT_FLAG
,      CANCEL_FLAG
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUBINVENTORY
,      DESTINATION_TYPE_CODE
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_SUBINVENTORY
,      QUANTITY_CANCELLED
,      CANCEL_DATE
,      CANCEL_REASON
,      CLOSED_CODE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      ON_LINE_FLAG
,      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
,      ORG_ID
,      KANBAN_CARD_ID
,      CATALOG_TYPE
,      CATALOG_SOURCE
,      MANUFACTURER_ID
,      MANUFACTURER_NAME
,      MANUFACTURER_PART_NUMBER
,      REQUESTER_EMAIL
,      REQUESTER_FAX
,      REQUESTER_PHONE
,      UNSPSC_CODE
,      OTHER_CATEGORY_CODE
,      SUPPLIER_DUNS
,      PCARD_FLAG
,      NEW_SUPPLIER_FLAG
,      AUTO_RECEIVE_FLAG
,      ITEM_SOURCE_ID
,      SUPPLIER_REF_NUMBER
,      PREFERRED_GRADE
,      VMI_FLAG
,      AUCTION_HEADER_ID
,      AUCTION_DISPLAY_NUMBER
,      AUCTION_LINE_NUMBER
,      REQS_IN_POOL_FLAG
,      BID_NUMBER
,      BID_LINE_NUMBER
,      NONCAT_TEMPLATE_ID
,      SUGGESTED_VENDOR_CONTACT_FAX
,      SUGGESTED_VENDOR_CONTACT_EMAIL
,      AMOUNT
,      CURRENCY_AMOUNT
,      LABOR_REQ_LINE_ID
,      JOB_ID
,      JOB_LONG_DESCRIPTION
,      CONTACT_INFORMATION
,      SUGGESTED_SUPPLIER_FLAG
,      ASSIGNMENT_END_DATE
,      CONTRACTOR_REQUISITION_FLAG
,      DROP_SHIP_FLAG
,      ASSIGNMENT_START_DATE
,      ORDER_TYPE_LOOKUP_CODE
,      PURCHASE_BASIS
,      MATCHING_BASIS
,      NEGOTIATED_BY_PREPARER_FLAG
,      SHIP_METHOD
,      BASE_UNIT_PRICE
,      AT_SOURCING_FLAG
,      CONFORMED_LINE_ID
,      LINE_NUM_DISPLAY
,      GROUP_LINE_ID
,      CLM_INFO_FLAG
,      CLM_OPTION_INDICATOR
,      CLM_BASE_LINE_NUM
,      CLM_OPTION_NUM
,      CLM_OPTION_FROM_DATE
,      CLM_OPTION_TO_DATE
,      CLM_FUNDED_FLAG
,      UDA_TEMPLATE_ID
,      CONTRACT_TYPE
,      COST_CONSTRAINT
,      CLM_PERIOD_PERF_START_DATE
,      CLM_PERIOD_PERF_END_DATE
,      CLM_EXTENDED_ITEM_DESCRIPTION
,      CLM_OPTION_EXERCISED
,      IS_LINE_NUM_DISPLAY_MODIFIED
,      ASSIGNMENT_NUMBER
,      PO_DRAFT_ID
,      PO_LINE_ID
,      CLM_EXERCISED_DATE
,      LINKED_TO_FUND
,      FUND_SOURCE_NOT_KNOWN
,      CREATION_DATE
,      FUNDED_VALUE
,      FUNDS_USED
,      FUNDS_REMAINING
,      REVISION_NUM
FROM APPS.PO_CLMREQ_LINES_V;

Dependencies

[top of page]

APPS.PO_CLMREQ_LINES_V references the following:

SchemaAPPS
ViewPO_CLMREQ_DIST_FUNDS_USED_V
ViewPO_REQUISITION_HEADERS_CLM_V
SynonymPO_REQUISITION_LINES_ALL
SynonymPO_REQ_DISTRIBUTIONS_ALL
APPS.PO_CLMREQ_LINES_V is referenced by following:

SchemaAPPS
Package BodyPON_AUCTION_CREATE_PO_PKG - show dependent code