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


VIEW: APPS.PO_HEADERS_PRINT

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_TYPE VARCHAR2 (25)

PO_NUM VARCHAR2 (20)

REVISION_NUM NUMBER


PRINT_COUNT NUMBER


CREATION_DATE DATE

Standard who column - date when this row was created.
PRINTED_DATE DATE


REVISED_DATE DATE


EFFECTIVE_DATE DATE


EXPIRATION_DATE DATE


NOTE_TO_VENDOR VARCHAR2 (480)

DOCUMENT_BUYER_FIRST_NAME VARCHAR2 (150)

DOCUMENT_BUYER_LAST_NAME VARCHAR2 (150)

DOCUMENT_BUYER_AGENT_ID NUMBER (9)

ARCHIVE_BUYER_FIRST_NAME VARCHAR2 (150)

ARCHIVE_BUYER_LAST_NAME VARCHAR2 (150)

ARCHIVE_BUYER_AGENT_ID NUMBER (9)

AMOUNT_AGREED NUMBER


CANCEL_FLAG VARCHAR2 (1)

CONFIRMING_ORDER_FLAG VARCHAR2 (1)

ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)

ACCEPTANCE_DUE_DATE DATE


CURRENCY_CODE VARCHAR2 (15)

CURRENCY_NAME VARCHAR2 (80)

CURRENCY_CONVERSION_RATE NUMBER


SHIP_VIA VARCHAR2 (25)

FOB VARCHAR2 (80)

FREIGHT_TERMS VARCHAR2 (80)

PAYMENT_TERMS VARCHAR2 (50)

CUSTOMER_NUM VARCHAR2 (25)

VENDOR_NUM VARCHAR2 (30)

VENDOR_NAME VARCHAR2 (240)

VENDOR_ADDRESS_LINE1 VARCHAR2 (240)

VENDOR_ADDRESS_LINE2 VARCHAR2 (240)

VENDOR_ADDRESS_LINE3 VARCHAR2 (240)

VENDOR_CITY VARCHAR2 (25)

VENDOR_STATE VARCHAR2 (150)

VENDOR_POSTAL_CODE VARCHAR2 (20)

VENDOR_COUNTRY VARCHAR2 (80)

VENDOR_PHONE VARCHAR2 (28)

VENDOR_CONTACT_FIRST_NAME VARCHAR2 (15)

VENDOR_CONTACT_LAST_NAME VARCHAR2 (15)

VENDOR_CONTACT_PHONE VARCHAR2 (53)

VENDOR_ADDRESS_LINE4 VARCHAR2 (240)
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
VENDOR_SITE_ID NUMBER


BILL_TO_LOCATION_ID NUMBER


SHIP_TO_LOCATION_ID NUMBER


PO_HEADER_ID NUMBER


PO_RELEASE_ID NUMBER


APPROVED_FLAG VARCHAR2 (1)

LANGUAGE VARCHAR2 (30)

VENDOR_ID NUMBER

RELEASE_DATE DATE

CONSIGNED_CONSUMPTION_FLAG VARCHAR2 (1)
ORG_ID NUMBER

Organization identifier
Query Text

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


SELECT PO_TYPE
,      PO_NUM
,      REVISION_NUM
,      PRINT_COUNT
,      CREATION_DATE
,      PRINTED_DATE
,      REVISED_DATE
,      EFFECTIVE_DATE
,      EXPIRATION_DATE
,      NOTE_TO_VENDOR
,      DOCUMENT_BUYER_FIRST_NAME
,      DOCUMENT_BUYER_LAST_NAME
,      DOCUMENT_BUYER_AGENT_ID
,      ARCHIVE_BUYER_FIRST_NAME
,      ARCHIVE_BUYER_LAST_NAME
,      ARCHIVE_BUYER_AGENT_ID
,      AMOUNT_AGREED
,      CANCEL_FLAG
,      CONFIRMING_ORDER_FLAG
,      ACCEPTANCE_REQUIRED_FLAG
,      ACCEPTANCE_DUE_DATE
,      CURRENCY_CODE
,      CURRENCY_NAME
,      CURRENCY_CONVERSION_RATE
,      SHIP_VIA
,      FOB
,      FREIGHT_TERMS
,      PAYMENT_TERMS
,      CUSTOMER_NUM
,      VENDOR_NUM
,      VENDOR_NAME
,      VENDOR_ADDRESS_LINE1
,      VENDOR_ADDRESS_LINE2
,      VENDOR_ADDRESS_LINE3
,      VENDOR_CITY
,      VENDOR_STATE
,      VENDOR_POSTAL_CODE
,      VENDOR_COUNTRY
,      VENDOR_PHONE
,      VENDOR_CONTACT_FIRST_NAME
,      VENDOR_CONTACT_LAST_NAME
,      VENDOR_CONTACT_PHONE
,      VENDOR_ADDRESS_LINE4
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      VENDOR_SITE_ID
,      BILL_TO_LOCATION_ID
,      SHIP_TO_LOCATION_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      APPROVED_FLAG
,      LANGUAGE
,      VENDOR_ID
,      RELEASE_DATE
,      CONSIGNED_CONSUMPTION_FLAG
,      ORG_ID
FROM APPS.PO_HEADERS_PRINT;

Dependencies

[top of page]

APPS.PO_HEADERS_PRINT references the following:

SchemaAPPS
SynonymAP_TERMS
SynonymFND_CURRENCIES_TL
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
SynonymFND_TERRITORIES_TL
ViewHR_EMPLOYEES
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_PEOPLE_F
SynonymPO_HEADERS
SynonymPO_HEADERS_ALL
SynonymPO_HEADERS_ARCHIVE_ALL
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES
SynonymPO_RELEASES_ARCHIVE_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.PO_HEADERS_PRINT is not referenced by any database object