[Home] [Help] [Dependency Information]
Object Name: | POBV_STD_PO_LINES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.POBV_STD_PO_LINES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This shows item and price information for a good or service on a standard purchase order.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PO_LINE_ID | NUMBER | Yes | ||
LINE_NUMBER | NUMBER | Yes | ||
STANDARD_PO_ID | NUMBER | Yes | ||
STANDARD_PO_DOCUMENT_NUMBER | VARCHAR2 | (20) | Yes | |
OPERATING_UNIT_ID | NUMBER | |||
OPERATING_UNIT_NAME | VARCHAR2 | (240) | Yes | |
LINE_TYPE | VARCHAR2 | (25) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
ORDERED_QUANTITY | NUMBER | |||
UNIT_PRICE | NUMBER | |||
LIST_PRICE | NUMBER | |||
MARKET_PRICE | NUMBER | |||
_LA:PRICE_TYPE | CHAR | (72) | ||
_LA:CANCEL_FLAG | CHAR | (57) | ||
CANCEL_DATE | DATE | |||
CANCEL_REASON | VARCHAR2 | (240) | ||
_LA:CLOSURE_STATUS | CHAR | (65) | ||
CLOSED_DATE | DATE | |||
CLOSED_REASON | VARCHAR2 | (240) | ||
_LA:NEGOTIATED_BY_BUYER_FLAG | CHAR | (73) | ||
_LA:CAPITAL_EXPENSE_FLAG | CHAR | (66) | ||
SUPPLIER_NOTE | VARCHAR2 | (480) | ||
SUPPLIER_PRODUCT_NUMBER | VARCHAR2 | (25) | ||
_LA:TAXABLE_FLAG | CHAR | (58) | ||
TYPE_OF_1099 | VARCHAR2 | (10) | ||
TRANSACTION_REASON | VARCHAR2 | (25) | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
ITEM_ID | NUMBER | |||
ITEM_REVISION | VARCHAR2 | (3) | ||
CATEGORY_ID | NUMBER | |||
UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
CONTRACT_NUMBER | VARCHAR2 | (25) | ||
HAZARD_CLASS_ID | NUMBER | |||
UN_NUMBER_ID | NUMBER | |||
SOURCE_DOCUMENT_ID | NUMBER | |||
SOURCE_DOCUMENT_LINE_ID | NUMBER | |||
CANCELLED_BY | NUMBER | (9) | ||
CLOSED_BY | NUMBER | (9) | ||
TAX_CODE_ID | 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) | ||
AUCTION_DISPLAY_NUMBER | VARCHAR2 | (40) | ||
AUCTION_HEADER_ID | NUMBER | |||
AUCTION_LINE_NUMBER | NUMBER | |||
BID_NUMBER | NUMBER | |||
BID_LINE_NUMBER | NUMBER | |||
OKE_CONTRACT_HEADER_ID | NUMBER | |||
OKE_CONTRACT_VERSION_ID | 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. | |
CONTRACT_ID | NUMBER | Contract PA reference of the line. Applicable to Standard PO only. Foreign key to PO_HEADER_ID in PO_HEADERS_ALL | ||
SVC_AMOUNT_NOTIF_SENT | VARCHAR2 | (1) | Temp Labor lines only (i.e. PURCHASE_BASIS='TEMP LABOR'): Indicates whether an Amount Billed Approaching Budget reminder notification has been sent for this line. | |
SVC_COMPLETION_NOTIF_SENT | VARCHAR2 | (1) | Temp Labor lines only (i.e. PURCHASE_BASIS='TEMP LABOR'): Indicates whether a Contractor Assignment Nearing Completion reminder notification has been sent for this line. | |
BASE_UNIT_PRICE | NUMBER | Base Unit Price | ||
JOB_ID | NUMBER | Stores the HR Job identifier | ||
AMOUNT | NUMBER | Budget Amout for temp labor standard PO lines | ||
PURCHASE_BASIS | VARCHAR2 | (30) | Purchase basis of the line type | |
MATCHING_BASIS | VARCHAR2 | (30) | Matching basis of the line type | |
ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Value basis of the line | |
CONTRACTOR_FIRST_NAME | VARCHAR2 | (240) | First name of the contingent worker | |
CONTRACTOR_LAST_NAME | VARCHAR2 | (240) | Last name of the contingent worker | |
START_DATE | DATE | Assignment start date for the contingent worker | ||
EXPIRATION_DATE | DATE | BLANKET, QUOTATION, RFQ: Date after which the item on this catalog line can no longer be ordered. STANDARD PO: For temp labor lines, this is the assignment end date for a contingent worker. | ||
MANUAL_PRICE_CHANGE_FLAG | VARCHAR2 | (1) | Only for Standard PO lines referencing a Global Agreement, Contract, or Quotation: Y if the user has manually entered a price overriding the source document price, N or null otherwise. | |
RETAINAGE_RATE | NUMBER | Retainage Rate | ||
MAX_RETAINAGE_AMOUNT | NUMBER | Max Retainage Amount | ||
PROGRESS_PAYMENT_RATE | NUMBER | Progress Payment Rate | ||
RECOUPMENT_RATE | NUMBER | Recoupment Rate | ||
TAX_ATTRIBUTE_UPDATE_CODE | VARCHAR2 | (15) | Tax Attribute Update Code |
Cut, paste (and edit) the following text to query this object:
SELECT PO_LINE_ID
, LINE_NUMBER
, STANDARD_PO_ID
, STANDARD_PO_DOCUMENT_NUMBER
, OPERATING_UNIT_ID
, OPERATING_UNIT_NAME
, LINE_TYPE
, ITEM_DESCRIPTION
, ORDERED_QUANTITY
, UNIT_PRICE
, LIST_PRICE
, MARKET_PRICE
, _LA:PRICE_TYPE
, _LA:CANCEL_FLAG
, CANCEL_DATE
, CANCEL_REASON
, _LA:CLOSURE_STATUS
, CLOSED_DATE
, CLOSED_REASON
, _LA:NEGOTIATED_BY_BUYER_FLAG
, _LA:CAPITAL_EXPENSE_FLAG
, SUPPLIER_NOTE
, SUPPLIER_PRODUCT_NUMBER
, _LA:TAXABLE_FLAG
, TYPE_OF_1099
, TRANSACTION_REASON
, USSGL_TRANSACTION_CODE
, ITEM_ID
, ITEM_REVISION
, CATEGORY_ID
, UNIT_OF_MEASURE
, CONTRACT_NUMBER
, HAZARD_CLASS_ID
, UN_NUMBER_ID
, SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_LINE_ID
, CANCELLED_BY
, CLOSED_BY
, TAX_CODE_ID
, CREATED_DATE
, CREATED_BY
, LAST_UPDATED_DATE
, LAST_UPDATED_BY
, SECONDARY_QUANTITY
, SECONDARY_UNIT_OF_MEASURE
, PREFERRED_GRADE
, AUCTION_DISPLAY_NUMBER
, AUCTION_HEADER_ID
, AUCTION_LINE_NUMBER
, BID_NUMBER
, BID_LINE_NUMBER
, OKE_CONTRACT_HEADER_ID
, OKE_CONTRACT_VERSION_ID
, SUPPLIER_REF_NUMBER
, CONTRACT_ID
, SVC_AMOUNT_NOTIF_SENT
, SVC_COMPLETION_NOTIF_SENT
, BASE_UNIT_PRICE
, JOB_ID
, AMOUNT
, PURCHASE_BASIS
, MATCHING_BASIS
, ORDER_TYPE_LOOKUP_CODE
, CONTRACTOR_FIRST_NAME
, CONTRACTOR_LAST_NAME
, START_DATE
, EXPIRATION_DATE
, MANUAL_PRICE_CHANGE_FLAG
, RETAINAGE_RATE
, MAX_RETAINAGE_AMOUNT
, PROGRESS_PAYMENT_RATE
, RECOUPMENT_RATE
, TAX_ATTRIBUTE_UPDATE_CODE
FROM APPS.POBV_STD_PO_LINES;
APPS.POBV_STD_PO_LINES is not referenced by any database object
|
|
|