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


VIEW: APPS.PO_HEADERS_CHANGE_PRINT

Object Details
Object Name: PO_HEADERS_CHANGE_PRINT
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_HEADERS_CHANGE_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)

ORIGINAL_BUYER_FIRST_NAME VARCHAR2 (150)

ORIGINAL_BUYER_LAST_NAME VARCHAR2 (150)

ORIGINAL_BUYER_AGENT_ID NUMBER (9)

REVISION_BUYER_FIRST_NAME VARCHAR2 (150)

REVISION_BUYER_LAST_NAME VARCHAR2 (150)

REVISION_BUYER_AGENT_ID NUMBER (9)

AMOUNT_AGREED NUMBER


APPROVED_FLAG VARCHAR2 (1)

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

VENDOR_CONTACT_PHONE VARCHAR2 (28)

SHIP_TO_LOCATION_ID NUMBER

SHIP_ADDRESS_LINE1 VARCHAR2 (4000)

SHIP_ADDRESS_LINE2 VARCHAR2 (4000)

SHIP_ADDRESS_LINE3 VARCHAR2 (4000)

SHIP_CITY VARCHAR2 (4000)

SHIP_STATE_PROVINCE VARCHAR2 (4000)

SHIP_POSTAL_CODE VARCHAR2 (4000)

SHIP_COUNTRY VARCHAR2 (4000)

BILL_TO_LOCATION_ID NUMBER

BILL_ADDRESS_LINE1 VARCHAR2 (4000)

BILL_ADDRESS_LINE2 VARCHAR2 (4000)

BILL_ADDRESS_LINE3 VARCHAR2 (4000)

BILL_CITY VARCHAR2 (4000)

BILL_STATE_PROVINCE VARCHAR2 (4000)

BILL_POSTAL_CODE VARCHAR2 (4000)

BILL_COUNTRY VARCHAR2 (4000)

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


PO_HEADER_ID NUMBER


PO_RELEASE_ID NUMBER


ORG_ID NUMBER

Organization identifier
RELEASE_NUM NUMBER

RELEASE_TYPE VARCHAR2 (25)
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
,      ORIGINAL_BUYER_FIRST_NAME
,      ORIGINAL_BUYER_LAST_NAME
,      ORIGINAL_BUYER_AGENT_ID
,      REVISION_BUYER_FIRST_NAME
,      REVISION_BUYER_LAST_NAME
,      REVISION_BUYER_AGENT_ID
,      AMOUNT_AGREED
,      APPROVED_FLAG
,      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
,      SHIP_TO_LOCATION_ID
,      SHIP_ADDRESS_LINE1
,      SHIP_ADDRESS_LINE2
,      SHIP_ADDRESS_LINE3
,      SHIP_CITY
,      SHIP_STATE_PROVINCE
,      SHIP_POSTAL_CODE
,      SHIP_COUNTRY
,      BILL_TO_LOCATION_ID
,      BILL_ADDRESS_LINE1
,      BILL_ADDRESS_LINE2
,      BILL_ADDRESS_LINE3
,      BILL_CITY
,      BILL_STATE_PROVINCE
,      BILL_POSTAL_CODE
,      BILL_COUNTRY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      VENDOR_SITE_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      ORG_ID
,      RELEASE_NUM
,      RELEASE_TYPE
FROM APPS.PO_HEADERS_CHANGE_PRINT;

Dependencies

[top of page]

APPS.PO_HEADERS_CHANGE_PRINT references the following:

SchemaAPPS
SynonymAP_SUPPLIER_CONTACTS
SynonymAP_TERMS
ViewFND_CURRENCIES_VL
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
PL/SQL PackagePO_COMMUNICATION_PVT - show dependent code
SynonymPO_HEADERS
SynonymPO_HEADERS_ARCHIVE
SynonymPO_HEADERS_ARCHIVE_ALL
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ARCHIVE
SynonymPO_RELEASES_ARCHIVE_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES
ViewPO_VENDOR_SITES_ALL

APPS.PO_HEADERS_CHANGE_PRINT is not referenced by any database object