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


VIEW: APPS.POFV_STD_PO_LINES

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

View Type

A Business Intelligence System view

[View Source]

Columns
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)
_DF CHAR (18)
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

_KF:CATEGORY::_CO CHAR (15)
UNIT_OF_MEASURE VARCHAR2 (25)
UOM_CLASS VARCHAR2 (10)
UOM_DESCRIPTION VARCHAR2 (50)
CONTRACT_NUMBER VARCHAR2 (20)
HAZARD_CLASS_ID NUMBER

HAZARD_CLASS VARCHAR2 (40)
UN_NUMBER_ID NUMBER

UN_NUMBER VARCHAR2 (25)
SOURCE_DOCUMENT_ID NUMBER

SOURCE_DOCUMENT_NUMBER VARCHAR2 (20)
_LA:SOURCE_DOCUMENT_TYPE CHAR (76)
SOURCE_DOCUMENT_LINE_ID NUMBER

SOURCE_DOCUMENT_LINE_NUMBER NUMBER

CANCELLED_BY NUMBER (9)
CANCELLED_BY_EMPLOYEE_NUMBER VARCHAR2 (30)
CANCELLED_BY_EMPLOYEE_NAME VARCHAR2 (240)
CLOSED_BY NUMBER (9)
CLOSED_BY_EMPLOYEE_NUMBER VARCHAR2 (30)
CLOSED_BY_EMPLOYEE_NAME VARCHAR2 (240)
TAX_CODE_ID NUMBER

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

RETROACTIVE_DATE DATE

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

Referenced Contract Unique Identifier
CONTRACT_OWNING_ORG_ID NUMBER

Operating Unit where the referenced contract is created from
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
JOB_NAME VARCHAR2 (700)
Name of the HR Job.
AMOUNT NUMBER

Budget Amout for temp labor standard PO lines
PURCHASE_BASIS VARCHAR2 (30) Yes Purchase basis of the line type
MATCHING_BASIS VARCHAR2 (30) Yes Matching basis of the line type
ORDER_TYPE_LOOKUP_CODE VARCHAR2 (25) Yes 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
Query Text

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
,      _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
,      CONTRACT_NUMBER
,      HAZARD_CLASS_ID
,      HAZARD_CLASS
,      UN_NUMBER_ID
,      UN_NUMBER
,      SOURCE_DOCUMENT_ID
,      SOURCE_DOCUMENT_NUMBER
,      _LA:SOURCE_DOCUMENT_TYPE
,      SOURCE_DOCUMENT_LINE_ID
,      SOURCE_DOCUMENT_LINE_NUMBER
,      CANCELLED_BY
,      CANCELLED_BY_EMPLOYEE_NUMBER
,      CANCELLED_BY_EMPLOYEE_NAME
,      CLOSED_BY
,      CLOSED_BY_EMPLOYEE_NUMBER
,      CLOSED_BY_EMPLOYEE_NAME
,      TAX_CODE_ID
,      TAX_CODE_NAME
,      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
,      RETROACTIVE_DATE
,      OKE_CONTRACT_HEADER_ID
,      OKE_CONTRACT_VERSION_ID
,      OKE_CONTRACT_NUM
,      OKE_CONTRACT_VERSION_NUM
,      OKE_CONTRACT_LINE_NUM
,      SUPPLIER_REF_NUMBER
,      CONTRACT_ID
,      CONTRACT_OWNING_ORG_ID
,      SVC_AMOUNT_NOTIF_SENT
,      SVC_COMPLETION_NOTIF_SENT
,      BASE_UNIT_PRICE
,      JOB_ID
,      JOB_NAME
,      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.POFV_STD_PO_LINES;

Dependencies

[top of page]

APPS.POFV_STD_PO_LINES references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_CATEGORIES
SynonymMTL_ITEM_REVISIONS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_UNITS_OF_MEASURE
SynonymOKC_K_HEADERS_B
SynonymOKC_K_LINES_B
ViewOKC_K_VERS_NUMBERS_V
ViewPER_JOBS_VL
ViewPER_PEOPLE_F
SynonymPO_HAZARD_CLASSES
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_TYPES
SynonymPO_UN_NUMBERS

APPS.POFV_STD_PO_LINES is not referenced by any database object