VIEW: MSC.MSC_PO_REQUISITIONS_INTERFACE#

Source

View Text - Preformatted

select PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, NEED_BY_DATE NEED_BY_DATE, ITEM_ID ITEM_ID, ITEM_REVISION ITEM_REVISION, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID, AUTHORIZATION_STATUS AUTHORIZATION_STATUS, BATCH_ID BATCH_ID, GROUP_CODE GROUP_CODE, PREPARER_ID PREPARER_ID, AUTOSOURCE_FLAG AUTOSOURCE_FLAG, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, DELIVER_TO_REQUESTOR_ID DELIVER_TO_REQUESTOR_ID, SUGGESTED_VENDOR_ID SUGGESTED_VENDOR_ID, SUGGESTED_VENDOR_SITE_ID SUGGESTED_VENDOR_SITE_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE, SOURCE_TYPE_CODE SOURCE_TYPE_CODE, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, QUANTITY QUANTITY, UOM_CODE UOM_CODE, LINE_TYPE_ID LINE_TYPE_ID, ORG_ID ORG_ID, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, SR_INSTANCE_ID SR_INSTANCE_ID, SUGGESTED_VENDOR_SITE SUGGESTED_VENDOR_SITE, SOURCE_LINE_ID SOURCE_LINE_ID, VMI_FLAG VMI_FLAG from "MSC"."MSC_PO_REQUISITIONS_INTERFACE"

View Text - HTML Formatted

SELECT PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, NEED_BY_DATE NEED_BY_DATE
, ITEM_ID ITEM_ID
, ITEM_REVISION ITEM_REVISION
, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID
, AUTHORIZATION_STATUS AUTHORIZATION_STATUS
, BATCH_ID BATCH_ID
, GROUP_CODE GROUP_CODE
, PREPARER_ID PREPARER_ID
, AUTOSOURCE_FLAG AUTOSOURCE_FLAG
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID
, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, DELIVER_TO_REQUESTOR_ID DELIVER_TO_REQUESTOR_ID
, SUGGESTED_VENDOR_ID SUGGESTED_VENDOR_ID
, SUGGESTED_VENDOR_SITE_ID SUGGESTED_VENDOR_SITE_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE
, SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, QUANTITY QUANTITY
, UOM_CODE UOM_CODE
, LINE_TYPE_ID LINE_TYPE_ID
, ORG_ID ORG_ID
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, SR_INSTANCE_ID SR_INSTANCE_ID
, SUGGESTED_VENDOR_SITE SUGGESTED_VENDOR_SITE
, SOURCE_LINE_ID SOURCE_LINE_ID
, VMI_FLAG VMI_FLAG
FROM "MSC"."MSC_PO_REQUISITIONS_INTERFACE"