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


VIEW: APPS.POFV_PURCHASE_ORDERS

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

View Type

A Business Intelligence System view


This shows a superset of purchasing documents, including standard and planned purchase orders, blanket purchase agreements, purchase contracts, quotations, and requests for quotation.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PURCHASE_ORDER_ID NUMBER
Yes
DOCUMENT_NUMBER VARCHAR2 (20) Yes
OPERATING_UNIT_ID NUMBER


OPERATING_UNIT_NAME VARCHAR2 (240) Yes
_LA:PURCHASE_ORDER_TYPE CHAR (72)

REVISION_NUMBER NUMBER


REVISED_DATE DATE


DESCRIPTION VARCHAR2 (240)

_LA:AUTHORIZATION_STATUS CHAR (80)

APPROVAL_DATE DATE


_LA:CANCEL_FLAG CHAR (57)

_LA:CLOSURE_STATUS CHAR (65)

CLOSED_DATE DATE


_LA:FIRM_STATUS CHAR (69)

_LA:FROZEN_FLAG CHAR (57)

_LA:HOLD_FLAG CHAR (60)

CURRENCY_CONVERSION_RATE NUMBER


CURRENCY_CONVERSION_RATE_DATE DATE


_LA:FREIGHT_TERM CHAR (78)

_LA:FREE_ON_BOARD_POINT CHAR (45)

START_EFFECTIVE_DATE DATE


END_EFFECTIVE_DATE DATE


AGREED_AMOUNT NUMBER


AMOUNT_LIMIT NUMBER


MINIMUM_RELEASE_AMOUNT NUMBER


RECEIVER_NOTE VARCHAR2 (480)

SUPPLIER_NOTE VARCHAR2 (480)

_LA:ACCEPTANCE_REQUIRED_FLAG CHAR (70)

ACCEPTANCE_DUE_DATE DATE


_LA:CONFIRMING_ORDER_FLAG CHAR (67)

_LA:SUPPLY_AGREEMENT_FLAG CHAR (67)

PRINT_COUNT NUMBER


LAST_PRINTED_DATE DATE


EDI_PROCESSED_FLAG VARCHAR2 (1)

EDI_PROCESSED_STATUS VARCHAR2 (10)

SUPPLIER_ORDER_NUMBER VARCHAR2 (25)
PRICE_UPDATE_TOLERANCE NUMBER

_LA:PAY_ON CHAR (66)
USSGL_TRANSACTION_CODE VARCHAR2 (30)

_DF CHAR (20)

SUPPLIER_ID NUMBER


SUPPLIER_NAME VARCHAR2 (240)

SUPPLIER_SITE_ID NUMBER


SUPPLIER_SITE VARCHAR2 (15)

SUPPLIER_CONTACT_ID NUMBER


SUPPLIER_CONTACT_NAME VARCHAR2 (32)

BUYER_ID NUMBER (9) Yes
BUYER_EMPLOYEE_NUMBER VARCHAR2 (30)

BUYER_NAME VARCHAR2 (240)

BILL_TO_LOCATION_ID NUMBER


BILL_TO_LOCATION VARCHAR2 (60)

SHIP_TO_LOCATION_ID NUMBER


SHIP_TO_LOCATION VARCHAR2 (60)

PAYMENT_TERMS_ID NUMBER


PAYMENT_TERMS_NAME VARCHAR2 (50)

CARRIER VARCHAR2 (25)

CARRIER_DESCRIPTION VARCHAR2 (80)

CARRIER_ORGANIZATION_ID NUMBER

CARRIER_ORGANIZATION_CODE VARCHAR2 (3)
CURRENCY_CODE VARCHAR2 (15)

CURRENCY VARCHAR2 (80) Yes
CURRENCY_CONVERSION_RATE_TYPE VARCHAR2 (30)

RATE_TYPE_NAME VARCHAR2 (30)

RATE_TYPE_DESCRIPTION VARCHAR2 (240)

PCARD_ID NUMBER (15)
PCARD_NUMBER VARCHAR2 (80)
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).
_LA:XML_FLAG CHAR (54)
XML_SEND_DATE DATE

XML_CHANGE_SEND_DATE DATE

_LA:GLOBAL_AGREEMENT_FLAG CHAR (67)
CBC_ACCOUNTING_DATE DATE

_LA:CONSUME_REQ_DEMAND_FLAG CHAR (69)
_LA:CONSIGNED_CONSUM_FLAG CHAR (72)
CHANGE_REQUESTED_BY VARCHAR2 (20)
PENDING_SIGNATURE_FLAG VARCHAR2 (1)
Indicates if the purchasing document is waiting for the signatures or not. Applicable to Purchasing document of type Standard, Contract, Blanket
_LA:CONTERMS_EXIST_FLAG CHAR (65)
Indicates if contract terms template is attached to the purchasing document or not. Applicable to Purchasing document of type Standard, Contract, Blanket
CONTERMS_ARTICLES_UPD_DATE DATE

Timestamp for the last update to Contract Articles. Applicable to Purchasing document of type Standard, Contract, Blanket
CONTERMS_DELIV_UPD_DATE DATE

Timestamp for the last update to Contract Deliverables. Applicable to Purchasing document of type Standard, Contract, Blanket
DOCUMENT_CREATION_METHOD VARCHAR2 (30)
SUBMIT_DATE DATE

AUTO_SOURCING_FLAG VARCHAR2 (1)
Auto Sourcing Flag
UPDATE_SOURCING_RULES_FLAG VARCHAR2 (1)
Update Sourcing Rules Flag
RETRO_PRICE_APPLY_UPDATES_FLAG VARCHAR2 (1)
Retro Price Apply Updates Flag
RETRO_PRICE_COMM_UPDATES_FLAG VARCHAR2 (1)
Retro Price Comm Updates Flag
EMAIL_ADDRESS VARCHAR2 (2000)
Email Address
FAX VARCHAR2 (30)
Fax
SUPPLIER_NOTIF_METHOD VARCHAR2 (25)
Supplier Notif Method
SUPPLIER_AUTH_ENABLED_FLAG VARCHAR2 (1)
Supplier Auth Enabled Flag
CAT_ADMIN_AUTH_ENABLED_FLAG VARCHAR2 (1)
Cat Admin Auth Enabled Flag
STYLE_ID NUMBER
Yes Style Id
TAX_ATTRIBUTE_UPDATE_CODE VARCHAR2 (15)
Tax Attribute Update Code
Query Text

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


SELECT PURCHASE_ORDER_ID
,      DOCUMENT_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      _LA:PURCHASE_ORDER_TYPE
,      REVISION_NUMBER
,      REVISED_DATE
,      DESCRIPTION
,      _LA:AUTHORIZATION_STATUS
,      APPROVAL_DATE
,      _LA:CANCEL_FLAG
,      _LA:CLOSURE_STATUS
,      CLOSED_DATE
,      _LA:FIRM_STATUS
,      _LA:FROZEN_FLAG
,      _LA:HOLD_FLAG
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_RATE_DATE
,      _LA:FREIGHT_TERM
,      _LA:FREE_ON_BOARD_POINT
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      AGREED_AMOUNT
,      AMOUNT_LIMIT
,      MINIMUM_RELEASE_AMOUNT
,      RECEIVER_NOTE
,      SUPPLIER_NOTE
,      _LA:ACCEPTANCE_REQUIRED_FLAG
,      ACCEPTANCE_DUE_DATE
,      _LA:CONFIRMING_ORDER_FLAG
,      _LA:SUPPLY_AGREEMENT_FLAG
,      PRINT_COUNT
,      LAST_PRINTED_DATE
,      EDI_PROCESSED_FLAG
,      EDI_PROCESSED_STATUS
,      SUPPLIER_ORDER_NUMBER
,      PRICE_UPDATE_TOLERANCE
,      _LA:PAY_ON
,      USSGL_TRANSACTION_CODE
,      _DF
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      SUPPLIER_CONTACT_ID
,      SUPPLIER_CONTACT_NAME
,      BUYER_ID
,      BUYER_EMPLOYEE_NUMBER
,      BUYER_NAME
,      BILL_TO_LOCATION_ID
,      BILL_TO_LOCATION
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      PAYMENT_TERMS_ID
,      PAYMENT_TERMS_NAME
,      CARRIER
,      CARRIER_DESCRIPTION
,      CARRIER_ORGANIZATION_ID
,      CARRIER_ORGANIZATION_CODE
,      CURRENCY_CODE
,      CURRENCY
,      CURRENCY_CONVERSION_RATE_TYPE
,      RATE_TYPE_NAME
,      RATE_TYPE_DESCRIPTION
,      PCARD_ID
,      PCARD_NUMBER
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      _LA:XML_FLAG
,      XML_SEND_DATE
,      XML_CHANGE_SEND_DATE
,      _LA:GLOBAL_AGREEMENT_FLAG
,      CBC_ACCOUNTING_DATE
,      _LA:CONSUME_REQ_DEMAND_FLAG
,      _LA:CONSIGNED_CONSUM_FLAG
,      CHANGE_REQUESTED_BY
,      PENDING_SIGNATURE_FLAG
,      _LA:CONTERMS_EXIST_FLAG
,      CONTERMS_ARTICLES_UPD_DATE
,      CONTERMS_DELIV_UPD_DATE
,      DOCUMENT_CREATION_METHOD
,      SUBMIT_DATE
,      AUTO_SOURCING_FLAG
,      UPDATE_SOURCING_RULES_FLAG
,      RETRO_PRICE_APPLY_UPDATES_FLAG
,      RETRO_PRICE_COMM_UPDATES_FLAG
,      EMAIL_ADDRESS
,      FAX
,      SUPPLIER_NOTIF_METHOD
,      SUPPLIER_AUTH_ENABLED_FLAG
,      CAT_ADMIN_AUTH_ENABLED_FLAG
,      STYLE_ID
,      TAX_ATTRIBUTE_UPDATE_CODE
FROM APPS.POFV_PURCHASE_ORDERS;

Dependencies

[top of page]

APPS.POFV_PURCHASE_ORDERS references the following:

SchemaAPPS
SynonymAP_CARDS_ALL
SynonymAP_TERMS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
ViewFND_CURRENCIES_VL
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymGL_DAILY_CONVERSION_TYPES
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_PARAMETERS
SynonymORG_FREIGHT
ViewPER_PEOPLE_F
SynonymPO_HEADERS_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.POFV_PURCHASE_ORDERS is not referenced by any database object