[Home] [Help] [Dependency Information]
Object Name: | PO_HEADERS_VAL_TYPE |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
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 |
|
Name | Parameters | Result |
---|---|---|
PO_HEADERS_VAL_TYPE |
SELF(PO_HEADERS_VAL_TYPE) |
PO_HEADERS_VAL_TYPE |
|
|
|