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


VIEW: APPS.POFV_BKT_PO_LINES

Object Details
Object Name: POFV_BKT_PO_LINES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POFV_BKT_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
BLANKET_PO_ID NUMBER
Yes
BLANKET_PO_DOCUMENT_NUMBER VARCHAR2 (20) Yes
OPERATING_UNIT_ID NUMBER

OPERATING_UNIT_NAME VARCHAR2 (240) Yes
LINE_TYPE VARCHAR2 (25)
ITEM_DESCRIPTION VARCHAR2 (240)
UNIT_PRICE NUMBER

LIST_PRICE NUMBER

MARKET_PRICE NUMBER

_LA:PRICE_TYPE CHAR (72)
_LA:PRICE_BREAK_TYPE CHAR (79)
AGREED_AMOUNT NUMBER

AGREED_QUANTITY NUMBER

_LA:ALLOW_PRICE_OVERRIDE CHAR (71)
PRICE_LIMIT NUMBER

MINIMUM_RELEASE_AMOUNT NUMBER

_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)
EXPIRATION_DATE DATE

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)
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)
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
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
,      BLANKET_PO_ID
,      BLANKET_PO_DOCUMENT_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      LINE_TYPE
,      ITEM_DESCRIPTION
,      UNIT_PRICE
,      LIST_PRICE
,      MARKET_PRICE
,      _LA:PRICE_TYPE
,      _LA:PRICE_BREAK_TYPE
,      AGREED_AMOUNT
,      AGREED_QUANTITY
,      _LA:ALLOW_PRICE_OVERRIDE
,      PRICE_LIMIT
,      MINIMUM_RELEASE_AMOUNT
,      _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
,      EXPIRATION_DATE
,      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
,      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
,      BASE_UNIT_PRICE
,      JOB_ID
,      JOB_NAME
,      AMOUNT
,      PURCHASE_BASIS
,      MATCHING_BASIS
,      ORDER_TYPE_LOOKUP_CODE
,      RETAINAGE_RATE
,      MAX_RETAINAGE_AMOUNT
,      PROGRESS_PAYMENT_RATE
,      RECOUPMENT_RATE
,      TAX_ATTRIBUTE_UPDATE_CODE
FROM APPS.POFV_BKT_PO_LINES;

Dependencies

[top of page]

APPS.POFV_BKT_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_BKT_PO_LINES is not referenced by any database object