eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TYPE: APPS.PO_HEADERS_VAL_TYPE

Object Details

Object Name:	PO_HEADERS_VAL_TYPE
Object Type:	TYPE
Owner:	APPS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length	Prcn
EMAIL_ADDRESS	PO_TBL_VARCHAR2000
SUPPLIER_NOTIF_METHOD	PO_TBL_VARCHAR30
FAX	PO_TBL_VARCHAR30
RETRO_PRICE_COMM_UPDATES_FLAG	PO_TBL_VARCHAR1
RETRO_PRICE_APPLY_UPDATES_FLAG	PO_TBL_VARCHAR1
UPDATE_SOURCING_RULES_FLAG	PO_TBL_VARCHAR1
AUTO_SOURCING_FLAG	PO_TBL_VARCHAR1
DRAFT_ID	PO_TBL_NUMBER
PO_HEADER_ID	PO_TBL_NUMBER
DELETE_FLAG	PO_TBL_VARCHAR30
CHANGE_ACCEPTED_FLAG	PO_TBL_VARCHAR1
AGENT_ID	PO_TBL_NUMBER
TYPE_LOOKUP_CODE	PO_TBL_VARCHAR30
LAST_UPDATE_DATE	PO_TBL_DATE
LAST_UPDATED_BY	PO_TBL_NUMBER
SEGMENT1	PO_TBL_VARCHAR30
SUMMARY_FLAG	PO_TBL_VARCHAR1
ENABLED_FLAG	PO_TBL_VARCHAR1
SEGMENT2	PO_TBL_VARCHAR30
SEGMENT3	PO_TBL_VARCHAR30
SEGMENT4	PO_TBL_VARCHAR30
SEGMENT5	PO_TBL_VARCHAR30
START_DATE_ACTIVE	PO_TBL_DATE
END_DATE_ACTIVE	PO_TBL_DATE
LAST_UPDATE_LOGIN	PO_TBL_NUMBER
CREATION_DATE	PO_TBL_DATE
CREATED_BY	PO_TBL_NUMBER
VENDOR_ID	PO_TBL_NUMBER
VENDOR_SITE_ID	PO_TBL_NUMBER
VENDOR_CONTACT_ID	PO_TBL_NUMBER
SHIP_TO_LOCATION_ID	PO_TBL_NUMBER
BILL_TO_LOCATION_ID	PO_TBL_NUMBER
TERMS_ID	PO_TBL_NUMBER
SHIP_VIA_LOOKUP_CODE	PO_TBL_VARCHAR30
FOB_LOOKUP_CODE	PO_TBL_VARCHAR30
FREIGHT_TERMS_LOOKUP_CODE	PO_TBL_VARCHAR30
STATUS_LOOKUP_CODE	PO_TBL_VARCHAR30
CURRENCY_CODE	PO_TBL_VARCHAR30
RATE_TYPE	PO_TBL_VARCHAR30
RATE_DATE	PO_TBL_DATE
RATE	PO_TBL_NUMBER
FROM_HEADER_ID	PO_TBL_NUMBER
FROM_TYPE_LOOKUP_CODE	PO_TBL_VARCHAR30
START_DATE	PO_TBL_DATE
END_DATE	PO_TBL_DATE
BLANKET_TOTAL_AMOUNT	PO_TBL_NUMBER
AUTHORIZATION_STATUS	PO_TBL_VARCHAR30
REVISION_NUM	PO_TBL_NUMBER
REVISED_DATE	PO_TBL_DATE
APPROVED_FLAG	PO_TBL_VARCHAR1
APPROVED_DATE	PO_TBL_DATE
AMOUNT_LIMIT	PO_TBL_NUMBER
MIN_RELEASE_AMOUNT	PO_TBL_NUMBER
NOTE_TO_AUTHORIZER	PO_TBL_VARCHAR2000
NOTE_TO_VENDOR	PO_TBL_VARCHAR2000
NOTE_TO_RECEIVER	PO_TBL_VARCHAR2000
PRINT_COUNT	PO_TBL_NUMBER
PRINTED_DATE	PO_TBL_DATE
VENDOR_ORDER_NUM	PO_TBL_VARCHAR30
CONFIRMING_ORDER_FLAG	PO_TBL_VARCHAR1
COMMENTS	PO_TBL_VARCHAR2000
REPLY_DATE	PO_TBL_DATE
REPLY_METHOD_LOOKUP_CODE	PO_TBL_VARCHAR30
RFQ_CLOSE_DATE	PO_TBL_DATE
QUOTE_TYPE_LOOKUP_CODE	PO_TBL_VARCHAR30
QUOTATION_CLASS_CODE	PO_TBL_VARCHAR30
QUOTE_WARNING_DELAY_UNIT	PO_TBL_VARCHAR30
QUOTE_WARNING_DELAY	PO_TBL_NUMBER
QUOTE_VENDOR_QUOTE_NUMBER	PO_TBL_VARCHAR30
ACCEPTANCE_REQUIRED_FLAG	PO_TBL_VARCHAR1
ACCEPTANCE_DUE_DATE	PO_TBL_DATE
CLOSED_DATE	PO_TBL_DATE
USER_HOLD_FLAG	PO_TBL_VARCHAR1
APPROVAL_REQUIRED_FLAG	PO_TBL_VARCHAR1
CANCEL_FLAG	PO_TBL_VARCHAR1
FIRM_STATUS_LOOKUP_CODE	PO_TBL_VARCHAR30
FIRM_DATE	PO_TBL_DATE
FROZEN_FLAG	PO_TBL_VARCHAR1
SUPPLY_AGREEMENT_FLAG	PO_TBL_VARCHAR1
EDI_PROCESSED_FLAG	PO_TBL_VARCHAR1
EDI_PROCESSED_STATUS	PO_TBL_VARCHAR30
ATTRIBUTE_CATEGORY	PO_TBL_VARCHAR30
ATTRIBUTE1	PO_TBL_VARCHAR2000
ATTRIBUTE2	PO_TBL_VARCHAR2000
ATTRIBUTE3	PO_TBL_VARCHAR2000
ATTRIBUTE4	PO_TBL_VARCHAR2000
ATTRIBUTE5	PO_TBL_VARCHAR2000
ATTRIBUTE6	PO_TBL_VARCHAR2000
ATTRIBUTE7	PO_TBL_VARCHAR2000
ATTRIBUTE8	PO_TBL_VARCHAR2000
ATTRIBUTE9	PO_TBL_VARCHAR2000
ATTRIBUTE10	PO_TBL_VARCHAR2000
ATTRIBUTE11	PO_TBL_VARCHAR2000
ATTRIBUTE12	PO_TBL_VARCHAR2000
ATTRIBUTE13	PO_TBL_VARCHAR2000
ATTRIBUTE14	PO_TBL_VARCHAR2000
ATTRIBUTE15	PO_TBL_VARCHAR2000
CLOSED_CODE	PO_TBL_VARCHAR30
USSGL_TRANSACTION_CODE	PO_TBL_VARCHAR30
GOVERNMENT_CONTEXT	PO_TBL_VARCHAR30
REQUEST_ID	PO_TBL_NUMBER
PROGRAM_APPLICATION_ID	PO_TBL_NUMBER
PROGRAM_ID	PO_TBL_NUMBER
PROGRAM_UPDATE_DATE	PO_TBL_DATE
ORG_ID	PO_TBL_NUMBER
GLOBAL_ATTRIBUTE_CATEGORY	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE1	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE2	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE3	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE4	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE5	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE6	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE7	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE8	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE9	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE10	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE11	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE12	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE13	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE14	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE15	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE16	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE17	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE18	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE19	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE20	PO_TBL_VARCHAR2000
INTERFACE_SOURCE_CODE	PO_TBL_VARCHAR30
REFERENCE_NUM	PO_TBL_VARCHAR30
WF_ITEM_TYPE	PO_TBL_VARCHAR30
WF_ITEM_KEY	PO_TBL_VARCHAR2000
MRC_RATE_TYPE	PO_TBL_VARCHAR2000
MRC_RATE_DATE	PO_TBL_VARCHAR2000
MRC_RATE	PO_TBL_VARCHAR2000
PCARD_ID	PO_TBL_NUMBER
PRICE_UPDATE_TOLERANCE	PO_TBL_NUMBER
PAY_ON_CODE	PO_TBL_VARCHAR30
XML_FLAG	PO_TBL_VARCHAR5
XML_SEND_DATE	PO_TBL_DATE
XML_CHANGE_SEND_DATE	PO_TBL_DATE
GLOBAL_AGREEMENT_FLAG	PO_TBL_VARCHAR1
CONSIGNED_CONSUMPTION_FLAG	PO_TBL_VARCHAR1
CBC_ACCOUNTING_DATE	PO_TBL_DATE
CONSUME_REQ_DEMAND_FLAG	PO_TBL_VARCHAR1
CHANGE_REQUESTED_BY	PO_TBL_VARCHAR30
SHIPPING_CONTROL	PO_TBL_VARCHAR30
CONTERMS_EXIST_FLAG	PO_TBL_VARCHAR1
CONTERMS_ARTICLES_UPD_DATE	PO_TBL_DATE
CONTERMS_DELIV_UPD_DATE	PO_TBL_DATE
ENCUMBRANCE_REQUIRED_FLAG	PO_TBL_VARCHAR1
PENDING_SIGNATURE_FLAG	PO_TBL_VARCHAR1
CHANGE_SUMMARY	PO_TBL_VARCHAR2000
DOCUMENT_CREATION_METHOD	PO_TBL_VARCHAR30
SUBMIT_DATE	PO_TBL_DATE
CREATED_LANGUAGE	PO_TBL_VARCHAR5
CPA_REFERENCE	PO_TBL_NUMBER
AMOUNT_AGREED	PO_TBL_NUMBER
AMOUNT_TO_ENCUMBER	PO_TBL_NUMBER
APPROVAL_STATUS	PO_TBL_VARCHAR30
DOCUMENT_NUM	PO_TBL_VARCHAR30
INTERFACE_ID	PO_TBL_NUMBER
INVENTORY_ORG_ID	PO_TBL_NUMBER
PO_RELEASE_ID	PO_TBL_NUMBER
RELEASE_DATE	PO_TBL_DATE
RELEASE_NUM	PO_TBL_NUMBER
STYLE_ID	PO_TBL_NUMBER
MOD_EFFECTIVE_DATE	PO_TBL_DATE
DRAFT_TYPE	PO_TBL_VARCHAR30
DRAFT_STATUS	PO_TBL_VARCHAR30
USER_DOCUMENT_STATUS	PO_TBL_VARCHAR30
CONTROL_ACTION	PO_TBL_VARCHAR30
CLM_EFFECTIVE_DATE	PO_TBL_DATE
CLM_MIN_GUARANTEE_AWARD_AMT	PO_TBL_NUMBER
CLM_MIN_GUARANTEE_AWARD_PERC	PO_TBL_NUMBER
CLM_MIN_ORDER_AMOUNT	PO_TBL_NUMBER
CLM_MAX_ORDER_AMOUNT	PO_TBL_NUMBER
CLM_STANDARD_FORM	PO_TBL_VARCHAR2000
CLM_DOCUMENT_FORMAT	PO_TBL_VARCHAR2000
CLM_SOURCE_DOCUMENT_ID	PO_TBL_NUMBER
CLM_EXTERNAL_IDV	PO_TBL_VARCHAR2000
CLM_AWARD_TYPE	PO_TBL_VARCHAR30
UMBRELLA_PROGRAM_ID	PO_TBL_NUMBER
CLM_CONTRACT_OFFICER	PO_TBL_NUMBER
CLM_AWARD_ADMINISTRATOR	PO_TBL_VARCHAR2000
MODIFICATION_NUMBER	PO_TBL_VARCHAR100

Methods

Name	Parameters	Result
PO_HEADERS_VAL_TYPE	SELF(PO_HEADERS_VAL_TYPE)	PO_HEADERS_VAL_TYPE

Dependencies

[top of page]

APPS.PO_HEADERS_VAL_TYPE references the following:

APPS: PO_TBL_DATE; PO_TBL_NUMBER; PO_TBL_VARCHAR1; PO_TBL_VARCHAR100; PO_TBL_VARCHAR2000; PO_TBL_VARCHAR30; PO_TBL_VARCHAR5

APPS.PO_HEADERS_VAL_TYPE is referenced by following:

APPS: PO_HEADERS_VAL_TYPE; PO_MOD_SYNC_PROCESS_PVT - show dependent code; PO_PDOI_HEADER_PROCESS_PVT - show dependent code; PO_VALIDATIONS - show dependent code; PO_VALIDATIONS - show dependent code