DOO_HEADERS_ALL

Details

Schema: FUSION
Object owner: DOO
Object type: VIEW

Columns

Name
ALLOW_CURRENCY_OVERRIDE_FLAG APPLIED_CURRENCY_CODE APPROVAL_SEQUENCE_NUMBER CANCELED_FLAG CANCEL_REASON_CODE CARRIER_ID CHANGE_VERSION_NUMBER COMMENTS CONVERSION_DATE CONVERSION_RATE CONVERSION_TYPE_CODE CREATED_BY CREATED_IN_RELEASE CREATION_DATE CUSTOMER_PO_NUMBER DEMAND_CLASS_CODE EARLIEST_ACCEPTABLE_SHIP_DATE EARLIEST_ACCEPT_ARRIVAL_DATE FOB_POINT_CODE FREEZE_PRICE_FLAG FREEZE_SHIPPING_CHARGE_FLAG FREEZE_TAX_FLAG FREIGHT_TERMS_CODE FULFILL_ORG_ID HEADER_ID IS_EDITABLE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LATEST_ACCEPTABLE_SHIP_DATE LATEST_ACCEPT_ARRIVAL_DATE LEGAL_ENTITY_ID ON_HOLD OPEN_FLAG ORDERED_DATE ORDER_NUMBER ORDER_TYPE_CODE ORG_ID ORIG_SYS_DOCUMENT_REF OWNER_ID PACKING_INSTRUCTIONS PARTIAL_SHIP_ALLOWED_FLAG PAYMENT_TERM_ID PRE_CREDIT_CHECKED_FLAG PRICED_ON PRICING_SEGMENT_CODE PRICING_SEGMENT_EXPLANATION PRICING_STRATEGY_EXPLANATION PRICING_STRATEGY_ID REQUEST_ARRIVAL_DATE REQUEST_CANCEL_DATE REQUEST_SHIP_DATE REVISION_SOURCE_ORDER_SYSTEM SEGMENT_EXPLANATION_MSG_NAME SHIPMENT_PRIORITY_CODE SHIPPING_INSTRUCTIONS SHIPSET_FLAG SHIP_CLASS_OF_SERVICE SHIP_MODE_OF_TRANSPORT SOLD_TO_CONTACT_ID SOLD_TO_CUSTOMER_ID SOLD_TO_PARTY_CONTACT_ID SOLD_TO_PARTY_CONTACT_POINT_ID SOLD_TO_PARTY_ID SOURCE_DOCUMENT_TYPE_CODE SOURCE_ORDER_ID SOURCE_ORDER_NUMBER SOURCE_ORDER_SYSTEM SOURCE_ORG_ID SOURCE_REVISION_NUMBER STATUS_CODE STRATEGY_EXPLANATION_MSG_NAME SUBMITTED_FLAG SUBSTITUTE_ALLOWED_FLAG SUPPLIER_ID SUPPLIER_SITE_ID TRADE_COMPLIANCE_RESULT_CODE TRANSACTIONAL_CURRENCY_CODE SUBMITTED_DATE SUBMITTED_BY SALES_CHANNEL_CODE SALESPERSON_ID

Name

ALLOW_CURRENCY_OVERRIDE_FLAG

APPLIED_CURRENCY_CODE

APPROVAL_SEQUENCE_NUMBER

CANCELED_FLAG

CANCEL_REASON_CODE

CARRIER_ID

CHANGE_VERSION_NUMBER

COMMENTS

CONVERSION_DATE

CONVERSION_RATE

CONVERSION_TYPE_CODE

CREATED_BY

CREATED_IN_RELEASE

CREATION_DATE

CUSTOMER_PO_NUMBER

DEMAND_CLASS_CODE

EARLIEST_ACCEPTABLE_SHIP_DATE

EARLIEST_ACCEPT_ARRIVAL_DATE

FOB_POINT_CODE

FREEZE_PRICE_FLAG

FREEZE_SHIPPING_CHARGE_FLAG

FREEZE_TAX_FLAG

FREIGHT_TERMS_CODE

FULFILL_ORG_ID

HEADER_ID

IS_EDITABLE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LATEST_ACCEPTABLE_SHIP_DATE

LATEST_ACCEPT_ARRIVAL_DATE

LEGAL_ENTITY_ID

ON_HOLD

OPEN_FLAG

ORDERED_DATE

ORDER_NUMBER

ORDER_TYPE_CODE

ORG_ID

ORIG_SYS_DOCUMENT_REF

OWNER_ID

PACKING_INSTRUCTIONS

PARTIAL_SHIP_ALLOWED_FLAG

PAYMENT_TERM_ID

PRE_CREDIT_CHECKED_FLAG

PRICED_ON

PRICING_SEGMENT_CODE

PRICING_SEGMENT_EXPLANATION

PRICING_STRATEGY_EXPLANATION

PRICING_STRATEGY_ID

REQUEST_ARRIVAL_DATE

REQUEST_CANCEL_DATE

REQUEST_SHIP_DATE

REVISION_SOURCE_ORDER_SYSTEM

SEGMENT_EXPLANATION_MSG_NAME

SHIPMENT_PRIORITY_CODE

SHIPPING_INSTRUCTIONS

SHIPSET_FLAG

SHIP_CLASS_OF_SERVICE

SHIP_MODE_OF_TRANSPORT

SOLD_TO_CONTACT_ID

SOLD_TO_CUSTOMER_ID

SOLD_TO_PARTY_CONTACT_ID

SOLD_TO_PARTY_CONTACT_POINT_ID

SOLD_TO_PARTY_ID

SOURCE_DOCUMENT_TYPE_CODE

SOURCE_ORDER_ID

SOURCE_ORDER_NUMBER

SOURCE_ORDER_SYSTEM

SOURCE_ORG_ID

SOURCE_REVISION_NUMBER

STATUS_CODE

STRATEGY_EXPLANATION_MSG_NAME

SUBMITTED_FLAG

SUBSTITUTE_ALLOWED_FLAG

SUPPLIER_ID

SUPPLIER_SITE_ID

TRADE_COMPLIANCE_RESULT_CODE

TRANSACTIONAL_CURRENCY_CODE

SUBMITTED_DATE

SUBMITTED_BY

SALES_CHANNEL_CODE

SALESPERSON_ID

Query

SQL_Statement
SELECT DHA.ALLOW_CURRENCY_OVERRIDE_FLAG, DHA.APPLIED_CURRENCY_CODE, DHA.APPROVAL_SEQUENCE_NUMBER, DHA.CANCELED_FLAG, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'RETURN_REASON', DHA.CANCEL_REASON_CODE ) CANCEL_REASON_CODE, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('CARRIER_ID', 'CARRIERS', DHA.CARRIER_ID ) CARRIER_ID, DHA.CHANGE_VERSION_NUMBER, DHA.COMMENTS, DHA.CONVERSION_DATE, DHA.CONVERSION_RATE, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('CONVERSION_TYPE', 'CURRENCY_CONV_TYPES', DHA.CONVERSION_TYPE_CODE ) CONVERSION_TYPE_CODE, DHA.CREATED_BY, DHA.CREATED_IN_RELEASE, DHA.CREATION_DATE, DHA.CUSTOMER_PO_NUMBER, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'DEMAND_CLASS', DHA.DEMAND_CLASS_CODE ) DEMAND_CLASS_CODE, DHA.EARLIEST_ACCEPTABLE_SHIP_DATE, DHA.EARLIEST_ACCEPT_ARRIVAL_DATE, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'FOB', DHA.FOB_POINT_CODE ) FOB_POINT_CODE, DHA.FREEZE_PRICE_FLAG, DHA.FREEZE_SHIPPING_CHARGE_FLAG, DHA.FREEZE_TAX_FLAG, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'WSH_FREIGHT_CHARGE_TERMS', DHA.FREIGHT_TERMS_CODE ) FREIGHT_TERMS_CODE, DHA.FULFILL_ORG_ID, DHA.HEADER_ID, DHA.IS_EDITABLE, DHA.LAST_UPDATED_BY, DHA.LAST_UPDATE_DATE, DHA.LAST_UPDATE_LOGIN, DHA.LATEST_ACCEPTABLE_SHIP_DATE, DHA.LATEST_ACCEPT_ARRIVAL_DATE, DHA.LEGAL_ENTITY_ID, DHA.ON_HOLD, DHA.OPEN_FLAG, DHA.ORDERED_DATE, DHA.ORDER_NUMBER, DHA.ORDER_TYPE_CODE, DHA.ORG_ID, DHA.ORIG_SYS_DOCUMENT_REF, DHA.OWNER_ID, DHA.PACKING_INSTRUCTIONS, DHA.PARTIAL_SHIP_ALLOWED_FLAG, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('TERM_ID', 'PAYMENT_TERMS', DHA.PAYMENT_TERM_ID ) PAYMENT_TERM_ID, DHA.PRE_CREDIT_CHECKED_FLAG, DHA.PRICED_ON, DHA.PRICING_SEGMENT_CODE, DHA.PRICING_SEGMENT_EXPLANATION, DHA.PRICING_STRATEGY_EXPLANATION, DHA.PRICING_STRATEGY_ID, DHA.REQUEST_ARRIVAL_DATE, DHA.REQUEST_CANCEL_DATE, DHA.REQUEST_SHIP_DATE, DHA.REVISION_SOURCE_ORDER_SYSTEM, DHA.SEGMENT_EXPLANATION_MSG_NAME, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'SHIPMENT_PRIORITY', DHA.SHIPMENT_PRIORITY_CODE ) SHIPMENT_PRIORITY_CODE, DHA.SHIPPING_INSTRUCTIONS, DHA.SHIPSET_FLAG, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'WSH_SERVICE_LEVELS', DHA.SHIP_CLASS_OF_SERVICE ) SHIP_CLASS_OF_SERVICE, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'WSH_MODE_OF_TRANSPORT', DHA.SHIP_MODE_OF_TRANSPORT ) SHIP_MODE_OF_TRANSPORT, DHA.SOLD_TO_CONTACT_ID, DHA.SOLD_TO_CUSTOMER_ID, DHA.SOLD_TO_PARTY_CONTACT_ID, DHA.SOLD_TO_PARTY_CONTACT_POINT_ID, DHA.SOLD_TO_PARTY_ID, DHA.SOURCE_DOCUMENT_TYPE_CODE, DHA.SOURCE_ORDER_ID, DHA.SOURCE_ORDER_NUMBER, DHA.SOURCE_ORDER_SYSTEM, DHA.SOURCE_ORG_ID, DHA.SOURCE_REVISION_NUMBER, DHA.STATUS_CODE, DHA.STRATEGY_EXPLANATION_MSG_NAME, DHA.SUBMITTED_FLAG, DHA.SUBSTITUTE_ALLOWED_FLAG, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('SUPPLIER_ID', 'SUPPLIERS', DHA.SUPPLIER_ID ) SUPPLIER_ID, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('SUPPLIER_SITE_ID', 'SUPPLIER_SITES', DHA.SUPPLIER_SITE_ID ) SUPPLIER_SITE_ID, DHA.TRADE_COMPLIANCE_RESULT_CODE, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('CURRENCY_CODE', 'CURRENCIES', DHA.TRANSACTIONAL_CURRENCY_CODE ) TRANSACTIONAL_CURRENCY_CODE, DHA.SUBMITTED_DATE, DHA.SUBMITTED_BY, DHA.SALES_CHANNEL_CODE, DHA.SALESPERSON_ID FROM DOO_HEADERS_ALL DHA

SQL_Statement

SELECT

DHA.ALLOW_CURRENCY_OVERRIDE_FLAG,

DHA.APPLIED_CURRENCY_CODE,

DHA.APPROVAL_SEQUENCE_NUMBER,

DHA.CANCELED_FLAG,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'RETURN_REASON', DHA.CANCEL_REASON_CODE ) CANCEL_REASON_CODE,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('CARRIER_ID', 'CARRIERS', DHA.CARRIER_ID ) CARRIER_ID,

DHA.CHANGE_VERSION_NUMBER,

DHA.COMMENTS,

DHA.CONVERSION_DATE,

DHA.CONVERSION_RATE,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('CONVERSION_TYPE', 'CURRENCY_CONV_TYPES', DHA.CONVERSION_TYPE_CODE ) CONVERSION_TYPE_CODE,

DHA.CREATED_BY,

DHA.CREATED_IN_RELEASE,

DHA.CREATION_DATE,

DHA.CUSTOMER_PO_NUMBER,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'DEMAND_CLASS', DHA.DEMAND_CLASS_CODE ) DEMAND_CLASS_CODE,

DHA.EARLIEST_ACCEPTABLE_SHIP_DATE,

DHA.EARLIEST_ACCEPT_ARRIVAL_DATE,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'FOB', DHA.FOB_POINT_CODE ) FOB_POINT_CODE,

DHA.FREEZE_PRICE_FLAG,

DHA.FREEZE_SHIPPING_CHARGE_FLAG,

DHA.FREEZE_TAX_FLAG,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'WSH_FREIGHT_CHARGE_TERMS', DHA.FREIGHT_TERMS_CODE ) FREIGHT_TERMS_CODE,

DHA.FULFILL_ORG_ID,

DHA.HEADER_ID,

DHA.IS_EDITABLE,

DHA.LAST_UPDATED_BY,

DHA.LAST_UPDATE_DATE,

DHA.LAST_UPDATE_LOGIN,

DHA.LATEST_ACCEPTABLE_SHIP_DATE,

DHA.LATEST_ACCEPT_ARRIVAL_DATE,

DHA.LEGAL_ENTITY_ID,

DHA.ON_HOLD,

DHA.OPEN_FLAG,

DHA.ORDERED_DATE,

DHA.ORDER_NUMBER,

DHA.ORDER_TYPE_CODE,

DHA.ORG_ID,

DHA.ORIG_SYS_DOCUMENT_REF,

DHA.OWNER_ID,

DHA.PACKING_INSTRUCTIONS,

DHA.PARTIAL_SHIP_ALLOWED_FLAG,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('TERM_ID', 'PAYMENT_TERMS', DHA.PAYMENT_TERM_ID ) PAYMENT_TERM_ID,

DHA.PRE_CREDIT_CHECKED_FLAG,

DHA.PRICED_ON,

DHA.PRICING_SEGMENT_CODE,

DHA.PRICING_SEGMENT_EXPLANATION,

DHA.PRICING_STRATEGY_EXPLANATION,

DHA.PRICING_STRATEGY_ID,

DHA.REQUEST_ARRIVAL_DATE,

DHA.REQUEST_CANCEL_DATE,

DHA.REQUEST_SHIP_DATE,

DHA.REVISION_SOURCE_ORDER_SYSTEM,

DHA.SEGMENT_EXPLANATION_MSG_NAME,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'SHIPMENT_PRIORITY', DHA.SHIPMENT_PRIORITY_CODE ) SHIPMENT_PRIORITY_CODE,

DHA.SHIPPING_INSTRUCTIONS,

DHA.SHIPSET_FLAG,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'WSH_SERVICE_LEVELS', DHA.SHIP_CLASS_OF_SERVICE ) SHIP_CLASS_OF_SERVICE,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'WSH_MODE_OF_TRANSPORT', DHA.SHIP_MODE_OF_TRANSPORT ) SHIP_MODE_OF_TRANSPORT,

DHA.SOLD_TO_CONTACT_ID,

DHA.SOLD_TO_CUSTOMER_ID,

DHA.SOLD_TO_PARTY_CONTACT_ID,

DHA.SOLD_TO_PARTY_CONTACT_POINT_ID,

DHA.SOLD_TO_PARTY_ID,

DHA.SOURCE_DOCUMENT_TYPE_CODE,

DHA.SOURCE_ORDER_ID,

DHA.SOURCE_ORDER_NUMBER,

DHA.SOURCE_ORDER_SYSTEM,

DHA.SOURCE_ORG_ID,

DHA.SOURCE_REVISION_NUMBER,

DHA.STATUS_CODE,

DHA.STRATEGY_EXPLANATION_MSG_NAME,

DHA.SUBMITTED_FLAG,

DHA.SUBSTITUTE_ALLOWED_FLAG,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('SUPPLIER_ID', 'SUPPLIERS', DHA.SUPPLIER_ID ) SUPPLIER_ID,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('SUPPLIER_SITE_ID', 'SUPPLIER_SITES', DHA.SUPPLIER_SITE_ID ) SUPPLIER_SITE_ID,

DHA.TRADE_COMPLIANCE_RESULT_CODE,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('CURRENCY_CODE', 'CURRENCIES', DHA.TRANSACTIONAL_CURRENCY_CODE ) TRANSACTIONAL_CURRENCY_CODE,

DHA.SUBMITTED_DATE,

DHA.SUBMITTED_BY,

DHA.SALES_CHANNEL_CODE,

DHA.SALESPERSON_ID

FROM DOO_HEADERS_ALL DHA