DOO_HEADERS_ALL_V
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 |
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 |