[Home] [Help] [Dependency Information]
Object Name: | PO_REQUISITIONS_INTERFACE_ALL# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | |||
PROCESS_FLAG | VARCHAR2 | (30) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
INTERFACE_SOURCE_CODE | VARCHAR2 | (25) | Yes | |
INTERFACE_SOURCE_LINE_ID | NUMBER | |||
SOURCE_TYPE_CODE | VARCHAR2 | (25) | ||
REQUISITION_HEADER_ID | NUMBER | |||
REQUISITION_LINE_ID | NUMBER | |||
REQ_DISTRIBUTION_ID | NUMBER | |||
REQUISITION_TYPE | VARCHAR2 | (25) | ||
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Yes | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
QUANTITY | NUMBER | |||
UNIT_PRICE | NUMBER | |||
AUTHORIZATION_STATUS | VARCHAR2 | (25) | Yes | |
BATCH_ID | NUMBER | |||
GROUP_CODE | VARCHAR2 | (30) | ||
DELETE_ENABLED_FLAG | VARCHAR2 | (1) | ||
UPDATE_ENABLED_FLAG | VARCHAR2 | (1) | ||
APPROVER_ID | NUMBER | (9) | ||
APPROVER_NAME | VARCHAR2 | (240) | ||
APPROVAL_PATH_ID | NUMBER | |||
NOTE_TO_APPROVER | VARCHAR2 | (4000) | ||
PREPARER_ID | NUMBER | (9) | ||
AUTOSOURCE_FLAG | VARCHAR2 | (1) | ||
REQ_NUMBER_SEGMENT1 | VARCHAR2 | (20) | ||
REQ_NUMBER_SEGMENT2 | VARCHAR2 | (20) | ||
REQ_NUMBER_SEGMENT3 | VARCHAR2 | (20) | ||
REQ_NUMBER_SEGMENT4 | VARCHAR2 | (20) | ||
REQ_NUMBER_SEGMENT5 | VARCHAR2 | (20) | ||
HEADER_DESCRIPTION | VARCHAR2 | (240) | ||
HEADER_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
HEADER_ATTRIBUTE1 | VARCHAR2 | (150) | ||
HEADER_ATTRIBUTE2 | VARCHAR2 | (150) | ||
HEADER_ATTRIBUTE3 | VARCHAR2 | (150) | ||
HEADER_ATTRIBUTE4 | VARCHAR2 | (150) | ||
HEADER_ATTRIBUTE5 | VARCHAR2 | (150) | ||
HEADER_ATTRIBUTE6 | VARCHAR2 | (150) | ||
HEADER_ATTRIBUTE7 | VARCHAR2 | (150) | ||
HEADER_ATTRIBUTE8 | VARCHAR2 | (150) | ||
HEADER_ATTRIBUTE9 | VARCHAR2 | (150) | ||
HEADER_ATTRIBUTE10 | VARCHAR2 | (150) | ||
HEADER_ATTRIBUTE11 | VARCHAR2 | (150) | ||
HEADER_ATTRIBUTE12 | VARCHAR2 | (150) | ||
HEADER_ATTRIBUTE13 | VARCHAR2 | (150) | ||
HEADER_ATTRIBUTE14 | VARCHAR2 | (150) | ||
URGENT_FLAG | VARCHAR2 | (1) | ||
HEADER_ATTRIBUTE15 | VARCHAR2 | (150) | ||
RFQ_REQUIRED_FLAG | VARCHAR2 | (1) | ||
JUSTIFICATION | VARCHAR2 | (480) | ||
NOTE_TO_BUYER | VARCHAR2 | (480) | ||
NOTE_TO_RECEIVER | VARCHAR2 | (480) | ||
ITEM_ID | NUMBER | |||
ITEM_SEGMENT1 | VARCHAR2 | (40) | ||
ITEM_SEGMENT2 | VARCHAR2 | (40) | ||
ITEM_SEGMENT3 | VARCHAR2 | (40) | ||
ITEM_SEGMENT4 | VARCHAR2 | (40) | ||
ITEM_SEGMENT5 | VARCHAR2 | (40) | ||
ITEM_SEGMENT6 | VARCHAR2 | (40) | ||
ITEM_SEGMENT7 | VARCHAR2 | (40) | ||
ITEM_SEGMENT8 | VARCHAR2 | (40) | ||
ITEM_SEGMENT9 | VARCHAR2 | (40) | ||
ITEM_SEGMENT10 | VARCHAR2 | (40) | ||
ITEM_SEGMENT11 | VARCHAR2 | (40) | ||
ITEM_SEGMENT12 | VARCHAR2 | (40) | ||
ITEM_SEGMENT13 | VARCHAR2 | (40) | ||
ITEM_SEGMENT14 | VARCHAR2 | (40) | ||
ITEM_SEGMENT15 | VARCHAR2 | (40) | ||
ITEM_SEGMENT16 | VARCHAR2 | (40) | ||
ITEM_SEGMENT17 | VARCHAR2 | (40) | ||
ITEM_SEGMENT18 | VARCHAR2 | (40) | ||
ITEM_SEGMENT19 | VARCHAR2 | (40) | ||
ITEM_SEGMENT20 | VARCHAR2 | (40) | ||
ITEM_REVISION | VARCHAR2 | (3) | ||
CHARGE_ACCOUNT_ID | NUMBER | |||
CHARGE_ACCOUNT_SEGMENT1 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT2 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT3 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT4 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT5 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT6 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT7 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT8 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT9 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT10 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT11 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT12 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT13 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT14 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT15 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT16 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT17 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT18 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT19 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT20 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT21 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT22 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT23 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT24 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT25 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT26 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT27 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT28 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT29 | VARCHAR2 | (25) | ||
CHARGE_ACCOUNT_SEGMENT30 | VARCHAR2 | (25) | ||
CATEGORY_ID | NUMBER | |||
CATEGORY_SEGMENT1 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT2 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT3 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT4 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT5 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT6 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT7 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT8 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT9 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT10 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT11 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT12 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT13 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT14 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT15 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT16 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT17 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT18 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT19 | VARCHAR2 | (40) | ||
CATEGORY_SEGMENT20 | VARCHAR2 | (40) | ||
UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
UOM_CODE | VARCHAR2 | (3) | ||
LINE_TYPE_ID | NUMBER | |||
LINE_TYPE | VARCHAR2 | (25) | ||
UN_NUMBER_ID | NUMBER | |||
UN_NUMBER | VARCHAR2 | (25) | ||
HAZARD_CLASS_ID | NUMBER | |||
HAZARD_CLASS | VARCHAR2 | (40) | ||
MUST_USE_SUGG_VENDOR_FLAG | VARCHAR2 | (10) | ||
REFERENCE_NUM | VARCHAR2 | (25) | ||
WIP_ENTITY_ID | NUMBER | |||
WIP_LINE_ID | NUMBER | |||
WIP_OPERATION_SEQ_NUM | NUMBER | |||
WIP_RESOURCE_SEQ_NUM | NUMBER | |||
WIP_REPETITIVE_SCHEDULE_ID | NUMBER | |||
PROJECT_NUM | VARCHAR2 | (25) | ||
TASK_NUM | VARCHAR2 | (250) | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
SOURCE_ORGANIZATION_ID | NUMBER | |||
SOURCE_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
SOURCE_SUBINVENTORY | VARCHAR2 | (10) | ||
DESTINATION_ORGANIZATION_ID | NUMBER | |||
DESTINATION_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
DESTINATION_SUBINVENTORY | VARCHAR2 | (10) | ||
DELIVER_TO_LOCATION_ID | NUMBER | |||
DELIVER_TO_LOCATION_CODE | VARCHAR2 | (60) | ||
DELIVER_TO_REQUESTOR_ID | NUMBER | (9) | ||
DELIVER_TO_REQUESTOR_NAME | VARCHAR2 | (240) | ||
SUGGESTED_BUYER_ID | NUMBER | (9) | ||
SUGGESTED_BUYER_NAME | VARCHAR2 | (240) | ||
SUGGESTED_VENDOR_NAME | VARCHAR2 | (240) | ||
SUGGESTED_VENDOR_ID | NUMBER | |||
SUGGESTED_VENDOR_SITE | VARCHAR2 | (46) | ||
SUGGESTED_VENDOR_SITE_ID | NUMBER | |||
SUGGESTED_VENDOR_CONTACT | VARCHAR2 | (80) | ||
SUGGESTED_VENDOR_CONTACT_ID | NUMBER | |||
SUGGESTED_VENDOR_PHONE | VARCHAR2 | (25) | ||
SUGGESTED_VENDOR_ITEM_NUM | VARCHAR2 | (25) | ||
LINE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
LINE_ATTRIBUTE1 | VARCHAR2 | (150) | ||
LINE_ATTRIBUTE2 | VARCHAR2 | (150) | ||
LINE_ATTRIBUTE3 | VARCHAR2 | (150) | ||
LINE_ATTRIBUTE4 | VARCHAR2 | (150) | ||
LINE_ATTRIBUTE5 | VARCHAR2 | (150) | ||
LINE_ATTRIBUTE6 | VARCHAR2 | (150) | ||
LINE_ATTRIBUTE7 | VARCHAR2 | (150) | ||
LINE_ATTRIBUTE8 | VARCHAR2 | (150) | ||
LINE_ATTRIBUTE9 | VARCHAR2 | (150) | ||
LINE_ATTRIBUTE10 | VARCHAR2 | (150) | ||
LINE_ATTRIBUTE11 | VARCHAR2 | (150) | ||
LINE_ATTRIBUTE12 | VARCHAR2 | (150) | ||
LINE_ATTRIBUTE13 | VARCHAR2 | (150) | ||
LINE_ATTRIBUTE14 | VARCHAR2 | (150) | ||
LINE_ATTRIBUTE15 | VARCHAR2 | (150) | ||
NEED_BY_DATE | DATE | |||
NOTE1_ID | NUMBER | |||
NOTE2_ID | NUMBER | |||
NOTE3_ID | NUMBER | |||
NOTE4_ID | NUMBER | |||
NOTE5_ID | NUMBER | |||
NOTE6_ID | NUMBER | |||
NOTE7_ID | NUMBER | |||
NOTE8_ID | NUMBER | |||
NOTE9_ID | NUMBER | |||
NOTE10_ID | NUMBER | |||
NOTE1_TITLE | VARCHAR2 | (80) | ||
NOTE2_TITLE | VARCHAR2 | (80) | ||
NOTE3_TITLE | VARCHAR2 | (80) | ||
NOTE4_TITLE | VARCHAR2 | (80) | ||
NOTE5_TITLE | VARCHAR2 | (80) | ||
NOTE6_TITLE | VARCHAR2 | (80) | ||
NOTE7_TITLE | VARCHAR2 | (80) | ||
NOTE8_TITLE | VARCHAR2 | (80) | ||
NOTE9_TITLE | VARCHAR2 | (80) | ||
NOTE10_TITLE | VARCHAR2 | (80) | ||
GL_DATE | DATE | |||
DIST_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
DISTRIBUTION_ATTRIBUTE1 | VARCHAR2 | (150) | ||
DISTRIBUTION_ATTRIBUTE2 | VARCHAR2 | (150) | ||
DISTRIBUTION_ATTRIBUTE3 | VARCHAR2 | (150) | ||
DISTRIBUTION_ATTRIBUTE4 | VARCHAR2 | (150) | ||
DISTRIBUTION_ATTRIBUTE5 | VARCHAR2 | (150) | ||
DISTRIBUTION_ATTRIBUTE6 | VARCHAR2 | (150) | ||
DISTRIBUTION_ATTRIBUTE7 | VARCHAR2 | (150) | ||
DISTRIBUTION_ATTRIBUTE8 | VARCHAR2 | (150) | ||
DISTRIBUTION_ATTRIBUTE9 | VARCHAR2 | (150) | ||
DISTRIBUTION_ATTRIBUTE10 | VARCHAR2 | (150) | ||
DISTRIBUTION_ATTRIBUTE11 | VARCHAR2 | (150) | ||
DISTRIBUTION_ATTRIBUTE12 | VARCHAR2 | (150) | ||
DISTRIBUTION_ATTRIBUTE13 | VARCHAR2 | (150) | ||
DISTRIBUTION_ATTRIBUTE14 | VARCHAR2 | (150) | ||
DISTRIBUTION_ATTRIBUTE15 | VARCHAR2 | (150) | ||
PREPARER_NAME | VARCHAR2 | (240) | ||
BOM_RESOURCE_ID | NUMBER | |||
ACCRUAL_ACCOUNT_ID | NUMBER | |||
VARIANCE_ACCOUNT_ID | NUMBER | |||
BUDGET_ACCOUNT_ID | NUMBER | |||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_UNIT_PRICE | NUMBER | |||
RATE | NUMBER | |||
RATE_DATE | DATE | |||
RATE_TYPE | VARCHAR2 | (30) | ||
PREVENT_ENCUMBRANCE_FLAG | VARCHAR2 | (1) | ||
AUTOSOURCE_DOC_HEADER_ID | NUMBER | |||
AUTOSOURCE_DOC_LINE_NUM | NUMBER | |||
PROJECT_ACCOUNTING_CONTEXT | VARCHAR2 | (30) | ||
EXPENDITURE_ORGANIZATION_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
TASK_ID | NUMBER | |||
END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
EXPENDITURE_ITEM_DATE | DATE | |||
DOCUMENT_TYPE_CODE | VARCHAR2 | (25) | ||
ORG_ID | NUMBER | |||
TRANSACTION_REASON_CODE | VARCHAR2 | (25) | ||
ALLOCATION_TYPE | VARCHAR2 | (25) | ||
ALLOCATION_VALUE | NUMBER | |||
MULTI_DISTRIBUTIONS | VARCHAR2 | (1) | ||
REQ_DIST_SEQUENCE_ID | NUMBER | |||
KANBAN_CARD_ID | NUMBER | |||
EMERGENCY_PO_NUM | VARCHAR2 | (20) | ||
AWARD_ID | NUMBER | (15) | ||
TAX_CODE_ID | NUMBER | |||
OKE_CONTRACT_HEADER_ID | NUMBER | |||
OKE_CONTRACT_NUM | VARCHAR2 | (120) | ||
OKE_CONTRACT_VERSION_ID | NUMBER | |||
OKE_CONTRACT_LINE_ID | NUMBER | |||
OKE_CONTRACT_LINE_NUM | VARCHAR2 | (150) | ||
OKE_CONTRACT_DELIVERABLE_ID | NUMBER | |||
OKE_CONTRACT_DELIVERABLE_NUM | VARCHAR2 | (150) | ||
SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
SECONDARY_UOM_CODE | VARCHAR2 | (3) | ||
SECONDARY_QUANTITY | NUMBER | |||
PREFERRED_GRADE | VARCHAR2 | (150) | ||
VMI_FLAG | VARCHAR2 | (1) | ||
TAX_USER_OVERRIDE_FLAG | VARCHAR2 | (1) | ||
AMOUNT | NUMBER | |||
CURRENCY_AMOUNT | NUMBER | |||
SHIP_METHOD | VARCHAR2 | (30) | ||
ESTIMATED_PICKUP_DATE | DATE | |||
BASE_UNIT_PRICE | NUMBER | |||
NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | (1) | ||
TAX_NAME | VARCHAR2 | (30) | ||
FUNDED_VALUE | NUMBER | |||
PARTIAL_FUNDED_FLAG | VARCHAR2 | (1) | ||
FEDERAL_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, PROCESS_FLAG
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, INTERFACE_SOURCE_CODE
, INTERFACE_SOURCE_LINE_ID
, SOURCE_TYPE_CODE
, REQUISITION_HEADER_ID
, REQUISITION_LINE_ID
, REQ_DISTRIBUTION_ID
, REQUISITION_TYPE
, DESTINATION_TYPE_CODE
, ITEM_DESCRIPTION
, QUANTITY
, UNIT_PRICE
, AUTHORIZATION_STATUS
, BATCH_ID
, GROUP_CODE
, DELETE_ENABLED_FLAG
, UPDATE_ENABLED_FLAG
, APPROVER_ID
, APPROVER_NAME
, APPROVAL_PATH_ID
, NOTE_TO_APPROVER
, PREPARER_ID
, AUTOSOURCE_FLAG
, REQ_NUMBER_SEGMENT1
, REQ_NUMBER_SEGMENT2
, REQ_NUMBER_SEGMENT3
, REQ_NUMBER_SEGMENT4
, REQ_NUMBER_SEGMENT5
, HEADER_DESCRIPTION
, HEADER_ATTRIBUTE_CATEGORY
, HEADER_ATTRIBUTE1
, HEADER_ATTRIBUTE2
, HEADER_ATTRIBUTE3
, HEADER_ATTRIBUTE4
, HEADER_ATTRIBUTE5
, HEADER_ATTRIBUTE6
, HEADER_ATTRIBUTE7
, HEADER_ATTRIBUTE8
, HEADER_ATTRIBUTE9
, HEADER_ATTRIBUTE10
, HEADER_ATTRIBUTE11
, HEADER_ATTRIBUTE12
, HEADER_ATTRIBUTE13
, HEADER_ATTRIBUTE14
, URGENT_FLAG
, HEADER_ATTRIBUTE15
, RFQ_REQUIRED_FLAG
, JUSTIFICATION
, NOTE_TO_BUYER
, NOTE_TO_RECEIVER
, ITEM_ID
, ITEM_SEGMENT1
, ITEM_SEGMENT2
, ITEM_SEGMENT3
, ITEM_SEGMENT4
, ITEM_SEGMENT5
, ITEM_SEGMENT6
, ITEM_SEGMENT7
, ITEM_SEGMENT8
, ITEM_SEGMENT9
, ITEM_SEGMENT10
, ITEM_SEGMENT11
, ITEM_SEGMENT12
, ITEM_SEGMENT13
, ITEM_SEGMENT14
, ITEM_SEGMENT15
, ITEM_SEGMENT16
, ITEM_SEGMENT17
, ITEM_SEGMENT18
, ITEM_SEGMENT19
, ITEM_SEGMENT20
, ITEM_REVISION
, CHARGE_ACCOUNT_ID
, CHARGE_ACCOUNT_SEGMENT1
, CHARGE_ACCOUNT_SEGMENT2
, CHARGE_ACCOUNT_SEGMENT3
, CHARGE_ACCOUNT_SEGMENT4
, CHARGE_ACCOUNT_SEGMENT5
, CHARGE_ACCOUNT_SEGMENT6
, CHARGE_ACCOUNT_SEGMENT7
, CHARGE_ACCOUNT_SEGMENT8
, CHARGE_ACCOUNT_SEGMENT9
, CHARGE_ACCOUNT_SEGMENT10
, CHARGE_ACCOUNT_SEGMENT11
, CHARGE_ACCOUNT_SEGMENT12
, CHARGE_ACCOUNT_SEGMENT13
, CHARGE_ACCOUNT_SEGMENT14
, CHARGE_ACCOUNT_SEGMENT15
, CHARGE_ACCOUNT_SEGMENT16
, CHARGE_ACCOUNT_SEGMENT17
, CHARGE_ACCOUNT_SEGMENT18
, CHARGE_ACCOUNT_SEGMENT19
, CHARGE_ACCOUNT_SEGMENT20
, CHARGE_ACCOUNT_SEGMENT21
, CHARGE_ACCOUNT_SEGMENT22
, CHARGE_ACCOUNT_SEGMENT23
, CHARGE_ACCOUNT_SEGMENT24
, CHARGE_ACCOUNT_SEGMENT25
, CHARGE_ACCOUNT_SEGMENT26
, CHARGE_ACCOUNT_SEGMENT27
, CHARGE_ACCOUNT_SEGMENT28
, CHARGE_ACCOUNT_SEGMENT29
, CHARGE_ACCOUNT_SEGMENT30
, CATEGORY_ID
, CATEGORY_SEGMENT1
, CATEGORY_SEGMENT2
, CATEGORY_SEGMENT3
, CATEGORY_SEGMENT4
, CATEGORY_SEGMENT5
, CATEGORY_SEGMENT6
, CATEGORY_SEGMENT7
, CATEGORY_SEGMENT8
, CATEGORY_SEGMENT9
, CATEGORY_SEGMENT10
, CATEGORY_SEGMENT11
, CATEGORY_SEGMENT12
, CATEGORY_SEGMENT13
, CATEGORY_SEGMENT14
, CATEGORY_SEGMENT15
, CATEGORY_SEGMENT16
, CATEGORY_SEGMENT17
, CATEGORY_SEGMENT18
, CATEGORY_SEGMENT19
, CATEGORY_SEGMENT20
, UNIT_OF_MEASURE
, UOM_CODE
, LINE_TYPE_ID
, LINE_TYPE
, UN_NUMBER_ID
, UN_NUMBER
, HAZARD_CLASS_ID
, HAZARD_CLASS
, MUST_USE_SUGG_VENDOR_FLAG
, REFERENCE_NUM
, WIP_ENTITY_ID
, WIP_LINE_ID
, WIP_OPERATION_SEQ_NUM
, WIP_RESOURCE_SEQ_NUM
, WIP_REPETITIVE_SCHEDULE_ID
, PROJECT_NUM
, TASK_NUM
, EXPENDITURE_TYPE
, SOURCE_ORGANIZATION_ID
, SOURCE_ORGANIZATION_CODE
, SOURCE_SUBINVENTORY
, DESTINATION_ORGANIZATION_ID
, DESTINATION_ORGANIZATION_CODE
, DESTINATION_SUBINVENTORY
, DELIVER_TO_LOCATION_ID
, DELIVER_TO_LOCATION_CODE
, DELIVER_TO_REQUESTOR_ID
, DELIVER_TO_REQUESTOR_NAME
, SUGGESTED_BUYER_ID
, SUGGESTED_BUYER_NAME
, SUGGESTED_VENDOR_NAME
, SUGGESTED_VENDOR_ID
, SUGGESTED_VENDOR_SITE
, SUGGESTED_VENDOR_SITE_ID
, SUGGESTED_VENDOR_CONTACT
, SUGGESTED_VENDOR_CONTACT_ID
, SUGGESTED_VENDOR_PHONE
, SUGGESTED_VENDOR_ITEM_NUM
, LINE_ATTRIBUTE_CATEGORY
, LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15
, NEED_BY_DATE
, NOTE1_ID
, NOTE2_ID
, NOTE3_ID
, NOTE4_ID
, NOTE5_ID
, NOTE6_ID
, NOTE7_ID
, NOTE8_ID
, NOTE9_ID
, NOTE10_ID
, NOTE1_TITLE
, NOTE2_TITLE
, NOTE3_TITLE
, NOTE4_TITLE
, NOTE5_TITLE
, NOTE6_TITLE
, NOTE7_TITLE
, NOTE8_TITLE
, NOTE9_TITLE
, NOTE10_TITLE
, GL_DATE
, DIST_ATTRIBUTE_CATEGORY
, DISTRIBUTION_ATTRIBUTE1
, DISTRIBUTION_ATTRIBUTE2
, DISTRIBUTION_ATTRIBUTE3
, DISTRIBUTION_ATTRIBUTE4
, DISTRIBUTION_ATTRIBUTE5
, DISTRIBUTION_ATTRIBUTE6
, DISTRIBUTION_ATTRIBUTE7
, DISTRIBUTION_ATTRIBUTE8
, DISTRIBUTION_ATTRIBUTE9
, DISTRIBUTION_ATTRIBUTE10
, DISTRIBUTION_ATTRIBUTE11
, DISTRIBUTION_ATTRIBUTE12
, DISTRIBUTION_ATTRIBUTE13
, DISTRIBUTION_ATTRIBUTE14
, DISTRIBUTION_ATTRIBUTE15
, PREPARER_NAME
, BOM_RESOURCE_ID
, ACCRUAL_ACCOUNT_ID
, VARIANCE_ACCOUNT_ID
, BUDGET_ACCOUNT_ID
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, CURRENCY_CODE
, CURRENCY_UNIT_PRICE
, RATE
, RATE_DATE
, RATE_TYPE
, PREVENT_ENCUMBRANCE_FLAG
, AUTOSOURCE_DOC_HEADER_ID
, AUTOSOURCE_DOC_LINE_NUM
, PROJECT_ACCOUNTING_CONTEXT
, EXPENDITURE_ORGANIZATION_ID
, PROJECT_ID
, TASK_ID
, END_ITEM_UNIT_NUMBER
, EXPENDITURE_ITEM_DATE
, DOCUMENT_TYPE_CODE
, ORG_ID
, TRANSACTION_REASON_CODE
, ALLOCATION_TYPE
, ALLOCATION_VALUE
, MULTI_DISTRIBUTIONS
, REQ_DIST_SEQUENCE_ID
, KANBAN_CARD_ID
, EMERGENCY_PO_NUM
, AWARD_ID
, TAX_CODE_ID
, OKE_CONTRACT_HEADER_ID
, OKE_CONTRACT_NUM
, OKE_CONTRACT_VERSION_ID
, OKE_CONTRACT_LINE_ID
, OKE_CONTRACT_LINE_NUM
, OKE_CONTRACT_DELIVERABLE_ID
, OKE_CONTRACT_DELIVERABLE_NUM
, SECONDARY_UNIT_OF_MEASURE
, SECONDARY_UOM_CODE
, SECONDARY_QUANTITY
, PREFERRED_GRADE
, VMI_FLAG
, TAX_USER_OVERRIDE_FLAG
, AMOUNT
, CURRENCY_AMOUNT
, SHIP_METHOD
, ESTIMATED_PICKUP_DATE
, BASE_UNIT_PRICE
, NEGOTIATED_BY_PREPARER_FLAG
, TAX_NAME
, FUNDED_VALUE
, PARTIAL_FUNDED_FLAG
, FEDERAL_FLAG
FROM PO.PO_REQUISITIONS_INTERFACE_ALL#;
|
|
|