DOO_FULFILL_LINES_ALL

Details

Schema: FUSION
Object owner: DOO
Object type: VIEW

Columns

Name
ACCOUNTING_RULE_ID ACTUAL_COMPLETION_DATE ACTUAL_SHIP_DATE APPLIED_PRICE_LIST_ID ASSESSABLE_VALUE BILL_TO_CONTACT_ID BILL_TO_CONTACT_POINT_ID BILL_TO_CUSTOMER_ID BILL_TO_SITE_USE_ID BILLING_TRX_TYPE_ID BUYER_ID CANCELED_FLAG CANCELED_QTY CANCEL_REASON_CODE CARRIER_ID CATEGORY_CODE CHANGE_ELIGIBLE_FLAG COMMENTS COMPONENT_ID_PATH COMP_SEQ_PATH CONFIGURATOR_PATH CONFIG_CREATION_DATE CONFIG_HEADER_ID CONFIG_INVENTORY_ITEM_ID CONFIG_ITEM_REFERENCE CONFIG_REVISION_NUMBER CONFIG_TRADE_COMPL_RESULT_CODE CONTRACT_END_DATE CONTRACT_START_DATE CREATED_BY CREATED_IN_RELEASE CREATION_DATE CREDIT_CHK_AUTH_EXP_DATE CREDIT_CHK_AUTH_NUM CUSTOMER_ITEM_ID CUSTOMER_PO_LINE_NUMBER CUSTOMER_PO_NUMBER CUSTOMER_PO_SCHEDULE_NUMBER DEFAULT_TAXATION_COUNTRY DEMAND_CLASS_CODE DESTINATION_LOCATION_ID DESTINATION_ORG_ID DOCUMENT_SUB_TYPE EARLIEST_ACCEPTABLE_SHIP_DATE ESTIMATE_FULFILLMENT_COST ESTIMATE_MARGIN EXEMPTION_CERTIFICATE_NUMBER EXTENDED_AMOUNT FINAL_DISCHARGE_LOCATION_ID FIRST_PTY_REG_ID FOB_POINT_CODE FREIGHT_TERMS_CODE FULFILLED_QTY FULFILLMENT_DATE FULFILLMENT_MODE FULFILLMENT_SPLIT_REF_ID FULFILL_INSTANCE_ID FULFILL_LINE_ID FULFILL_LINE_NUMBER FULFILL_ORG_ID FULFILL_TOLERANCE_ABOVE FULFILL_TOLERANCE_BELOW GOP_REFERENCE_ID GOP_REQUEST_REGION HEADER_ID INTENDED_USE_CLASSIF_ID INVENTORY_ITEM_ID INVENTORY_ORGANIZATION_ID INVOICEABLE_ITEM_FLAG INVOICE_ENABLED_FLAG INVOICE_INTERFACED_FLAG INVOICING_RULE_ID ITEM_SUB_TYPE_CODE ITEM_TYPE_CODE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LATEST_ACCEPTABLE_ARRIVAL_DATE LATEST_ACCEPTABLE_SHIP_DATE LATEST_EXT_FULFILL_LINE_NUMBER LINE_ID LINE_TYPE_CODE ON_HOLD OPEN_FLAG ORDERED_QTY ORDERED_UOM ORG_ID ORIGINAL_INVENTORY_ITEM_ID ORIG_SYS_DOCUMENT_LINE_REF ORIG_SYS_DOCUMENT_REF OVERRIDE_SCHEDULE_DATE_FLAG OWNER_ID PACKING_INSTRUCTIONS PARENT_FULFILL_LINE_ID PARTIAL_SHIP_ALLOWED_FLAG PAYMENT_TERM_ID PO_STATUS_CODE PREF_OVERRIDDEN_BITSET PRICED_ON PROCESS_INSTANCE_ID PROCESS_NUMBER PRODUCT_CATEGORY PRODUCT_TYPE PROD_FC_CATEG_ID PROMISE_ARRIVAL_DATE PROMISE_SHIP_DATE PURCHASING_ENABLED_FLAG PURCHASING_UOM QUANTITY_PER_MODEL RECEIVABLES_ORG_ID REMNANT_FLAG REQUEST_ARRIVAL_DATE REQUEST_CANCEL_DATE REQUEST_SHIP_DATE REQUEST_TYPE REQUIRED_FULFILLMENT_DATE REQUISITION_BU_ID REQUISITION_INVENTORY_ORG_ID RESERVABLE_FLAG RESERVATION_ID RESERVED_QTY RETURNABLE_FLAG RETURN_REASON_CODE RMA_DELIVERED_QTY ROOT_PARENT_FULFILL_LINE_ID SCHEDULE_ARRIVAL_DATE SCHEDULE_SHIP_DATE SCHEDULING_REASON_CODE SHIPMENT_PRIORITY_CODE SHIPPABLE_FLAG SHIPPED_QTY SHIPPED_UOM SHIPPING_INSTRUCTIONS SHIP_CLASS_OF_SERVICE SHIP_MODE_OF_TRANSPORT SHIP_SET_NAME SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_POINT_ID SHIP_TO_CUSTOMER_ID SHIP_TO_PARTY_CONTACT_ID SHIP_TO_PARTY_ID SHIP_TO_PARTY_SITE_ID SHIP_TO_SITE_USE_ID SHOW_IN_SALES SOURCE_LINE_ID SOURCE_LINE_NUMBER SOURCE_ORDER_ID SOURCE_ORDER_NUMBER SOURCE_ORDER_SYSTEM SOURCE_ORG_ID SOURCE_REVISION_NUMBER SOURCE_SCHEDULE_ID SOURCE_SCHEDULE_NUMBER SPLIT_FROM_FLINE_ID STATUS_CODE STATUS_RULESET_ID SUBINVENTORY SUBSTITUTE_ALLOWED_FLAG SUBSTITUTE_REASON_CODE SUPPLIER_ID SUPPLIER_SITE_ID SUPPLY_STATUS_CODE TAX_CLASSIFICATION_CODE TAX_EXEMPTION_REASON_CODE TAX_EXEMPT_FLAG TAX_INVOICE_DATE TAX_INVOICE_NUMBER THIRD_PTY_REG_ID TOTAL_CONTRACT_AMOUNT TOTAL_CONTRACT_QUANTITY TRADE_COMPLIANCE_DATE TRADE_COMPLIANCE_RESULT_CODE TRANSPORTATION_PLANNED_FLAG TRX_BUSINESS_CATEGORY UNIT_LIST_PRICE UNIT_QUANTITY UNIT_SELLING_PRICE USER_DEFINED_FISC_CLASS VALID_CONFIGURATION_FLAG SERVICE_DURATION_PERIOD_CODE SERVICE_DURATION SALES_PRODUCT_TYPE_CODE ACTION_TYPE_CODE ASSET_GROUP_NUMBER ASSET_TRACKED_FLAG PROCESS_SET SALESPERSON_ID SERVICE_CANCEL_DATE UNREFERENCED_RETURN_FLAG PRJ_REC_INDICATOR SELLING_PROFIT_CENTER_BU_ID INVENTORY_INTERFACED_FLAG SECONDARY_UOM SECONDARY_ORDERED_QTY SECONDARY_SHIPPED_QTY SECONDARY_RMA_DELIVERED_QTY PRICE_USING_SEC_UOM_FLAG SECONDARY_FULFILLED_QTY

Name

ACCOUNTING_RULE_ID

ACTUAL_COMPLETION_DATE

ACTUAL_SHIP_DATE

APPLIED_PRICE_LIST_ID

ASSESSABLE_VALUE

BILL_TO_CONTACT_ID

BILL_TO_CONTACT_POINT_ID

BILL_TO_CUSTOMER_ID

BILL_TO_SITE_USE_ID

BILLING_TRX_TYPE_ID

BUYER_ID

CANCELED_FLAG

CANCELED_QTY

CANCEL_REASON_CODE

CARRIER_ID

CATEGORY_CODE

CHANGE_ELIGIBLE_FLAG

COMMENTS

COMPONENT_ID_PATH

COMP_SEQ_PATH

CONFIGURATOR_PATH

CONFIG_CREATION_DATE

CONFIG_HEADER_ID

CONFIG_INVENTORY_ITEM_ID

CONFIG_ITEM_REFERENCE

CONFIG_REVISION_NUMBER

CONFIG_TRADE_COMPL_RESULT_CODE

CONTRACT_END_DATE

CONTRACT_START_DATE

CREATED_BY

CREATED_IN_RELEASE

CREATION_DATE

CREDIT_CHK_AUTH_EXP_DATE

CREDIT_CHK_AUTH_NUM

CUSTOMER_ITEM_ID

CUSTOMER_PO_LINE_NUMBER

CUSTOMER_PO_NUMBER

CUSTOMER_PO_SCHEDULE_NUMBER

DEFAULT_TAXATION_COUNTRY

DEMAND_CLASS_CODE

DESTINATION_LOCATION_ID

DESTINATION_ORG_ID

DOCUMENT_SUB_TYPE

EARLIEST_ACCEPTABLE_SHIP_DATE

ESTIMATE_FULFILLMENT_COST

ESTIMATE_MARGIN

EXEMPTION_CERTIFICATE_NUMBER

EXTENDED_AMOUNT

FINAL_DISCHARGE_LOCATION_ID

FIRST_PTY_REG_ID

FOB_POINT_CODE

FREIGHT_TERMS_CODE

FULFILLED_QTY

FULFILLMENT_DATE

FULFILLMENT_MODE

FULFILLMENT_SPLIT_REF_ID

FULFILL_INSTANCE_ID

FULFILL_LINE_ID

FULFILL_LINE_NUMBER

FULFILL_ORG_ID

FULFILL_TOLERANCE_ABOVE

FULFILL_TOLERANCE_BELOW

GOP_REFERENCE_ID

GOP_REQUEST_REGION

HEADER_ID

INTENDED_USE_CLASSIF_ID

INVENTORY_ITEM_ID

INVENTORY_ORGANIZATION_ID

INVOICEABLE_ITEM_FLAG

INVOICE_ENABLED_FLAG

INVOICE_INTERFACED_FLAG

INVOICING_RULE_ID

ITEM_SUB_TYPE_CODE

ITEM_TYPE_CODE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LATEST_ACCEPTABLE_ARRIVAL_DATE

LATEST_ACCEPTABLE_SHIP_DATE

LATEST_EXT_FULFILL_LINE_NUMBER

LINE_ID

LINE_TYPE_CODE

ON_HOLD

OPEN_FLAG

ORDERED_QTY

ORDERED_UOM

ORG_ID

ORIGINAL_INVENTORY_ITEM_ID

ORIG_SYS_DOCUMENT_LINE_REF

ORIG_SYS_DOCUMENT_REF

OVERRIDE_SCHEDULE_DATE_FLAG

OWNER_ID

PACKING_INSTRUCTIONS

PARENT_FULFILL_LINE_ID

PARTIAL_SHIP_ALLOWED_FLAG

PAYMENT_TERM_ID

PO_STATUS_CODE

PREF_OVERRIDDEN_BITSET

PRICED_ON

PROCESS_INSTANCE_ID

PROCESS_NUMBER

PRODUCT_CATEGORY

PRODUCT_TYPE

PROD_FC_CATEG_ID

PROMISE_ARRIVAL_DATE

PROMISE_SHIP_DATE

PURCHASING_ENABLED_FLAG

PURCHASING_UOM

QUANTITY_PER_MODEL

RECEIVABLES_ORG_ID

REMNANT_FLAG

REQUEST_ARRIVAL_DATE

REQUEST_CANCEL_DATE

REQUEST_SHIP_DATE

REQUEST_TYPE

REQUIRED_FULFILLMENT_DATE

REQUISITION_BU_ID

REQUISITION_INVENTORY_ORG_ID

RESERVABLE_FLAG

RESERVATION_ID

RESERVED_QTY

RETURNABLE_FLAG

RETURN_REASON_CODE

RMA_DELIVERED_QTY

ROOT_PARENT_FULFILL_LINE_ID

SCHEDULE_ARRIVAL_DATE

SCHEDULE_SHIP_DATE

SCHEDULING_REASON_CODE

SHIPMENT_PRIORITY_CODE

SHIPPABLE_FLAG

SHIPPED_QTY

SHIPPED_UOM

SHIPPING_INSTRUCTIONS

SHIP_CLASS_OF_SERVICE

SHIP_MODE_OF_TRANSPORT

SHIP_SET_NAME

SHIP_TO_CONTACT_ID

SHIP_TO_CONTACT_POINT_ID

SHIP_TO_CUSTOMER_ID

SHIP_TO_PARTY_CONTACT_ID

SHIP_TO_PARTY_ID

SHIP_TO_PARTY_SITE_ID

SHIP_TO_SITE_USE_ID

SHOW_IN_SALES

SOURCE_LINE_ID

SOURCE_LINE_NUMBER

SOURCE_ORDER_ID

SOURCE_ORDER_NUMBER

SOURCE_ORDER_SYSTEM

SOURCE_ORG_ID

SOURCE_REVISION_NUMBER

SOURCE_SCHEDULE_ID

SOURCE_SCHEDULE_NUMBER

SPLIT_FROM_FLINE_ID

STATUS_CODE

STATUS_RULESET_ID

SUBINVENTORY

SUBSTITUTE_ALLOWED_FLAG

SUBSTITUTE_REASON_CODE

SUPPLIER_ID

SUPPLIER_SITE_ID

SUPPLY_STATUS_CODE

TAX_CLASSIFICATION_CODE

TAX_EXEMPTION_REASON_CODE

TAX_EXEMPT_FLAG

TAX_INVOICE_DATE

TAX_INVOICE_NUMBER

THIRD_PTY_REG_ID

TOTAL_CONTRACT_AMOUNT

TOTAL_CONTRACT_QUANTITY

TRADE_COMPLIANCE_DATE

TRADE_COMPLIANCE_RESULT_CODE

TRANSPORTATION_PLANNED_FLAG

TRX_BUSINESS_CATEGORY

UNIT_LIST_PRICE

UNIT_QUANTITY

UNIT_SELLING_PRICE

USER_DEFINED_FISC_CLASS

VALID_CONFIGURATION_FLAG

SERVICE_DURATION_PERIOD_CODE

SERVICE_DURATION

SALES_PRODUCT_TYPE_CODE

ACTION_TYPE_CODE

ASSET_GROUP_NUMBER

ASSET_TRACKED_FLAG

PROCESS_SET

SALESPERSON_ID

SERVICE_CANCEL_DATE

UNREFERENCED_RETURN_FLAG

PRJ_REC_INDICATOR

SELLING_PROFIT_CENTER_BU_ID

INVENTORY_INTERFACED_FLAG

SECONDARY_UOM

SECONDARY_ORDERED_QTY

SECONDARY_SHIPPED_QTY

SECONDARY_RMA_DELIVERED_QTY

PRICE_USING_SEC_UOM_FLAG

SECONDARY_FULFILLED_QTY

Query

SQL_Statement
SELECT DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('RULE_ID', 'INVOICING_ACCT_RULES', DFLA.ACCOUNTING_RULE_ID) ACCOUNTING_RULE_ID, DFLA.ACTUAL_COMPLETION_DATE, DFLA.ACTUAL_SHIP_DATE, DFLA.APPLIED_PRICE_LIST_ID, DFLA.ASSESSABLE_VALUE, DFLA.BILL_TO_CONTACT_ID, DFLA.BILL_TO_CONTACT_POINT_ID, DFLA.BILL_TO_CUSTOMER_ID, DFLA.BILL_TO_SITE_USE_ID, DFLA.BILLING_TRX_TYPE_ID, DFLA.BUYER_ID, DFLA.CANCELED_FLAG, DFLA.CANCELED_QTY, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'RETURN_REASON', DFLA.CANCEL_REASON_CODE) CANCEL_REASON_CODE, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('CARRIER_ID', 'CARRIERS', DFLA.CARRIER_ID) CARRIER_ID, DFLA.CATEGORY_CODE, DFLA.CHANGE_ELIGIBLE_FLAG, DFLA.COMMENTS, DFLA.COMPONENT_ID_PATH, DFLA.COMP_SEQ_PATH, DFLA.CONFIGURATOR_PATH, DFLA.CONFIG_CREATION_DATE, DFLA.CONFIG_HEADER_ID, DFLA.CONFIG_INVENTORY_ITEM_ID, DFLA.CONFIG_ITEM_REFERENCE, DFLA.CONFIG_REVISION_NUMBER, DFLA.CONFIG_TRADE_COMPL_RESULT_CODE, DFLA.CONTRACT_END_DATE, DFLA.CONTRACT_START_DATE, DFLA.CREATED_BY, DFLA.CREATED_IN_RELEASE, DFLA.CREATION_DATE, DFLA.CREDIT_CHK_AUTH_EXP_DATE, DFLA.CREDIT_CHK_AUTH_NUM, DFLA.CUSTOMER_ITEM_ID, DFLA.CUSTOMER_PO_LINE_NUMBER, DFLA.CUSTOMER_PO_NUMBER, DFLA.CUSTOMER_PO_SCHEDULE_NUMBER, DFLA.DEFAULT_TAXATION_COUNTRY, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'DEMAND_CLASS', DFLA.DEMAND_CLASS_CODE) DEMAND_CLASS_CODE, DFLA.DESTINATION_LOCATION_ID, DFLA.DESTINATION_ORG_ID, DFLA.DOCUMENT_SUB_TYPE, DFLA.EARLIEST_ACCEPTABLE_SHIP_DATE, DFLA.ESTIMATE_FULFILLMENT_COST, DFLA.ESTIMATE_MARGIN, DFLA.EXEMPTION_CERTIFICATE_NUMBER, DFLA.EXTENDED_AMOUNT, DFLA.FINAL_DISCHARGE_LOCATION_ID, DFLA.FIRST_PTY_REG_ID, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'FOB', DFLA.FOB_POINT_CODE) FOB_POINT_CODE, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'WSH_FREIGHT_CHARGE_TERMS', DFLA.FREIGHT_TERMS_CODE) FREIGHT_TERMS_CODE, DFLA.FULFILLED_QTY, DFLA.FULFILLMENT_DATE, DFLA.FULFILLMENT_MODE, DFLA.FULFILLMENT_SPLIT_REF_ID, DFLA.FULFILL_INSTANCE_ID, DFLA.FULFILL_LINE_ID, DFLA.FULFILL_LINE_NUMBER, DFLA.FULFILL_ORG_ID, DFLA.FULFILL_TOLERANCE_ABOVE, DFLA.FULFILL_TOLERANCE_BELOW, DFLA.GOP_REFERENCE_ID, DFLA.GOP_REQUEST_REGION, DFLA.HEADER_ID, DFLA.INTENDED_USE_CLASSIF_ID, DFLA.INVENTORY_ITEM_ID, DFLA.INVENTORY_ORGANIZATION_ID, DFLA.INVOICEABLE_ITEM_FLAG, DFLA.INVOICE_ENABLED_FLAG, DFLA.INVOICE_INTERFACED_FLAG, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('RULE_ID', 'INVOICING_ACCT_RULES', DFLA.INVOICING_RULE_ID) INVOICING_RULE_ID, DFLA.ITEM_SUB_TYPE_CODE, DFLA.ITEM_TYPE_CODE, DFLA.LAST_UPDATED_BY, DFLA.LAST_UPDATE_DATE, DFLA.LAST_UPDATE_LOGIN, DFLA.LATEST_ACCEPTABLE_ARRIVAL_DATE, DFLA.LATEST_ACCEPTABLE_SHIP_DATE, DFLA.LATEST_EXT_FULFILL_LINE_NUMBER, DFLA.LINE_ID, DFLA.LINE_TYPE_CODE, DFLA.ON_HOLD, DFLA.OPEN_FLAG, DFLA.ORDERED_QTY, DFLA.ORDERED_UOM, DFLA.ORG_ID, DFLA.ORIGINAL_INVENTORY_ITEM_ID, DFLA.ORIG_SYS_DOCUMENT_LINE_REF, DFLA.ORIG_SYS_DOCUMENT_REF, DFLA.OVERRIDE_SCHEDULE_DATE_FLAG, DFLA.OWNER_ID, DFLA.PACKING_INSTRUCTIONS, DFLA.PARENT_FULFILL_LINE_ID, DFLA.PARTIAL_SHIP_ALLOWED_FLAG, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('TERM_ID', 'PAYMENT_TERMS', DFLA.PAYMENT_TERM_ID) PAYMENT_TERM_ID, DFLA.PO_STATUS_CODE, DFLA.PREF_OVERRIDDEN_BITSET, DFLA.PRICED_ON, DFLA.PROCESS_INSTANCE_ID, DFLA.PROCESS_NUMBER, DFLA.PRODUCT_CATEGORY, DFLA.PRODUCT_TYPE, DFLA.PROD_FC_CATEG_ID, DFLA.PROMISE_ARRIVAL_DATE, DFLA.PROMISE_SHIP_DATE, DFLA.PURCHASING_ENABLED_FLAG, DFLA.PURCHASING_UOM, DFLA.QUANTITY_PER_MODEL, DFLA.RECEIVABLES_ORG_ID, DFLA.REMNANT_FLAG, DFLA.REQUEST_ARRIVAL_DATE, DFLA.REQUEST_CANCEL_DATE, DFLA.REQUEST_SHIP_DATE, DFLA.REQUEST_TYPE, DFLA.REQUIRED_FULFILLMENT_DATE, DFLA.REQUISITION_BU_ID, DFLA.REQUISITION_INVENTORY_ORG_ID, DFLA.RESERVABLE_FLAG, DFLA.RESERVATION_ID, DFLA.RESERVED_QTY, DFLA.RETURNABLE_FLAG, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'RETURN_REASON', DFLA.RETURN_REASON_CODE) RETURN_REASON_CODE, DFLA.RMA_DELIVERED_QTY, DFLA.ROOT_PARENT_FULFILL_LINE_ID, DFLA.SCHEDULE_ARRIVAL_DATE, DFLA.SCHEDULE_SHIP_DATE, DFLA.SCHEDULING_REASON_CODE, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'SHIPMENT_PRIORITY', DFLA.SHIPMENT_PRIORITY_CODE) SHIPMENT_PRIORITY_CODE, DFLA.SHIPPABLE_FLAG, DFLA.SHIPPED_QTY, DFLA.SHIPPED_UOM, DFLA.SHIPPING_INSTRUCTIONS, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'WSH_SERVICE_LEVELS', DFLA.SHIP_CLASS_OF_SERVICE) SHIP_CLASS_OF_SERVICE, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'WSH_MODE_OF_TRANSPORT', DFLA.SHIP_MODE_OF_TRANSPORT) SHIP_MODE_OF_TRANSPORT, DFLA.SHIP_SET_NAME, DFLA.SHIP_TO_CONTACT_ID, DFLA.SHIP_TO_CONTACT_POINT_ID, DFLA.SHIP_TO_CUSTOMER_ID, DFLA.SHIP_TO_PARTY_CONTACT_ID, DFLA.SHIP_TO_PARTY_ID, DFLA.SHIP_TO_PARTY_SITE_ID, DFLA.SHIP_TO_SITE_USE_ID, DFLA.SHOW_IN_SALES, DFLA.SOURCE_LINE_ID, DFLA.SOURCE_LINE_NUMBER, DFLA.SOURCE_ORDER_ID, DFLA.SOURCE_ORDER_NUMBER, DFLA.SOURCE_ORDER_SYSTEM, DFLA.SOURCE_ORG_ID, DFLA.SOURCE_REVISION_NUMBER, DFLA.SOURCE_SCHEDULE_ID, DFLA.SOURCE_SCHEDULE_NUMBER, DFLA.SPLIT_FROM_FLINE_ID, DFLA.STATUS_CODE, DFLA.STATUS_RULESET_ID, DFLA.SUBINVENTORY, DFLA.SUBSTITUTE_ALLOWED_FLAG, DFLA.SUBSTITUTE_REASON_CODE, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('SUPPLIER_ID', 'SUPPLIERS', DFLA.SUPPLIER_ID) SUPPLIER_ID, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('SUPPLIER_SITE_ID', 'SUPPLIER_SITES', DFLA.SUPPLIER_SITE_ID) SUPPLIER_SITE_ID, DFLA.SUPPLY_STATUS_CODE, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'ZX_OUTPUT_CLASSIFICATIONS', DFLA.TAX_CLASSIFICATION_CODE) TAX_CLASSIFICATION_CODE, DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'ZX_EXEMPTION_REASON_CODE', DFLA.TAX_EXEMPTION_REASON_CODE) TAX_EXEMPTION_REASON_CODE, DFLA.TAX_EXEMPT_FLAG, DFLA.TAX_INVOICE_DATE, DFLA.TAX_INVOICE_NUMBER, DFLA.THIRD_PTY_REG_ID, DFLA.TOTAL_CONTRACT_AMOUNT, DFLA.TOTAL_CONTRACT_QUANTITY, DFLA.TRADE_COMPLIANCE_DATE, DFLA.TRADE_COMPLIANCE_RESULT_CODE, DFLA.TRANSPORTATION_PLANNED_FLAG, DFLA.TRX_BUSINESS_CATEGORY, DFLA.UNIT_LIST_PRICE, DFLA.UNIT_QUANTITY, DFLA.UNIT_SELLING_PRICE, DFLA.USER_DEFINED_FISC_CLASS, DFLA.VALID_CONFIGURATION_FLAG, DFLA.SERVICE_DURATION_PERIOD_CODE, DFLA.SERVICE_DURATION, DFLA.SALES_PRODUCT_TYPE_CODE, DFLA.ACTION_TYPE_CODE, DFLA.ASSET_GROUP_NUMBER, DFLA.ASSET_TRACKED_FLAG, DFLA.PROCESS_SET, DFLA.SALESPERSON_ID, DFLA.SERVICE_CANCEL_DATE, DFLA.UNREFERENCED_RETURN_FLAG, DFLA.PRJ_REC_INDICATOR, DFLA.SELLING_PROFIT_CENTER_BU_ID, DFLA.INVENTORY_INTERFACED_FLAG, DFLA.SECONDARY_UOM, DFLA.SECONDARY_ORDERED_QTY, DFLA.SECONDARY_SHIPPED_QTY, DFLA.SECONDARY_RMA_DELIVERED_QTY, DFLA.PRICE_USING_SEC_UOM_FLAG, DFLA.SECONDARY_FULFILLED_QTY FROM DOO_FULFILL_LINES_ALL DFLA

SQL_Statement

SELECT

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('RULE_ID', 'INVOICING_ACCT_RULES', DFLA.ACCOUNTING_RULE_ID) ACCOUNTING_RULE_ID,

DFLA.ACTUAL_COMPLETION_DATE,

DFLA.ACTUAL_SHIP_DATE,

DFLA.APPLIED_PRICE_LIST_ID,

DFLA.ASSESSABLE_VALUE,

DFLA.BILL_TO_CONTACT_ID,

DFLA.BILL_TO_CONTACT_POINT_ID,

DFLA.BILL_TO_CUSTOMER_ID,

DFLA.BILL_TO_SITE_USE_ID,

DFLA.BILLING_TRX_TYPE_ID,

DFLA.BUYER_ID,

DFLA.CANCELED_FLAG,

DFLA.CANCELED_QTY,

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

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

DFLA.CATEGORY_CODE,

DFLA.CHANGE_ELIGIBLE_FLAG,

DFLA.COMMENTS,

DFLA.COMPONENT_ID_PATH,

DFLA.COMP_SEQ_PATH,

DFLA.CONFIGURATOR_PATH,

DFLA.CONFIG_CREATION_DATE,

DFLA.CONFIG_HEADER_ID,

DFLA.CONFIG_INVENTORY_ITEM_ID,

DFLA.CONFIG_ITEM_REFERENCE,

DFLA.CONFIG_REVISION_NUMBER,

DFLA.CONFIG_TRADE_COMPL_RESULT_CODE,

DFLA.CONTRACT_END_DATE,

DFLA.CONTRACT_START_DATE,

DFLA.CREATED_BY,

DFLA.CREATED_IN_RELEASE,

DFLA.CREATION_DATE,

DFLA.CREDIT_CHK_AUTH_EXP_DATE,

DFLA.CREDIT_CHK_AUTH_NUM,

DFLA.CUSTOMER_ITEM_ID,

DFLA.CUSTOMER_PO_LINE_NUMBER,

DFLA.CUSTOMER_PO_NUMBER,

DFLA.CUSTOMER_PO_SCHEDULE_NUMBER,

DFLA.DEFAULT_TAXATION_COUNTRY,

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

DFLA.DESTINATION_LOCATION_ID,

DFLA.DESTINATION_ORG_ID,

DFLA.DOCUMENT_SUB_TYPE,

DFLA.EARLIEST_ACCEPTABLE_SHIP_DATE,

DFLA.ESTIMATE_FULFILLMENT_COST,

DFLA.ESTIMATE_MARGIN,

DFLA.EXEMPTION_CERTIFICATE_NUMBER,

DFLA.EXTENDED_AMOUNT,

DFLA.FINAL_DISCHARGE_LOCATION_ID,

DFLA.FIRST_PTY_REG_ID,

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

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

DFLA.FULFILLED_QTY,

DFLA.FULFILLMENT_DATE,

DFLA.FULFILLMENT_MODE,

DFLA.FULFILLMENT_SPLIT_REF_ID,

DFLA.FULFILL_INSTANCE_ID,

DFLA.FULFILL_LINE_ID,

DFLA.FULFILL_LINE_NUMBER,

DFLA.FULFILL_ORG_ID,

DFLA.FULFILL_TOLERANCE_ABOVE,

DFLA.FULFILL_TOLERANCE_BELOW,

DFLA.GOP_REFERENCE_ID,

DFLA.GOP_REQUEST_REGION,

DFLA.HEADER_ID,

DFLA.INTENDED_USE_CLASSIF_ID,

DFLA.INVENTORY_ITEM_ID,

DFLA.INVENTORY_ORGANIZATION_ID,

DFLA.INVOICEABLE_ITEM_FLAG,

DFLA.INVOICE_ENABLED_FLAG,

DFLA.INVOICE_INTERFACED_FLAG,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('RULE_ID', 'INVOICING_ACCT_RULES', DFLA.INVOICING_RULE_ID) INVOICING_RULE_ID,

DFLA.ITEM_SUB_TYPE_CODE,

DFLA.ITEM_TYPE_CODE,

DFLA.LAST_UPDATED_BY,

DFLA.LAST_UPDATE_DATE,

DFLA.LAST_UPDATE_LOGIN,

DFLA.LATEST_ACCEPTABLE_ARRIVAL_DATE,

DFLA.LATEST_ACCEPTABLE_SHIP_DATE,

DFLA.LATEST_EXT_FULFILL_LINE_NUMBER,

DFLA.LINE_ID,

DFLA.LINE_TYPE_CODE,

DFLA.ON_HOLD,

DFLA.OPEN_FLAG,

DFLA.ORDERED_QTY,

DFLA.ORDERED_UOM,

DFLA.ORG_ID,

DFLA.ORIGINAL_INVENTORY_ITEM_ID,

DFLA.ORIG_SYS_DOCUMENT_LINE_REF,

DFLA.ORIG_SYS_DOCUMENT_REF,

DFLA.OVERRIDE_SCHEDULE_DATE_FLAG,

DFLA.OWNER_ID,

DFLA.PACKING_INSTRUCTIONS,

DFLA.PARENT_FULFILL_LINE_ID,

DFLA.PARTIAL_SHIP_ALLOWED_FLAG,

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

DFLA.PO_STATUS_CODE,

DFLA.PREF_OVERRIDDEN_BITSET,

DFLA.PRICED_ON,

DFLA.PROCESS_INSTANCE_ID,

DFLA.PROCESS_NUMBER,

DFLA.PRODUCT_CATEGORY,

DFLA.PRODUCT_TYPE,

DFLA.PROD_FC_CATEG_ID,

DFLA.PROMISE_ARRIVAL_DATE,

DFLA.PROMISE_SHIP_DATE,

DFLA.PURCHASING_ENABLED_FLAG,

DFLA.PURCHASING_UOM,

DFLA.QUANTITY_PER_MODEL,

DFLA.RECEIVABLES_ORG_ID,

DFLA.REMNANT_FLAG,

DFLA.REQUEST_ARRIVAL_DATE,

DFLA.REQUEST_CANCEL_DATE,

DFLA.REQUEST_SHIP_DATE,

DFLA.REQUEST_TYPE,

DFLA.REQUIRED_FULFILLMENT_DATE,

DFLA.REQUISITION_BU_ID,

DFLA.REQUISITION_INVENTORY_ORG_ID,

DFLA.RESERVABLE_FLAG,

DFLA.RESERVATION_ID,

DFLA.RESERVED_QTY,

DFLA.RETURNABLE_FLAG,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'RETURN_REASON', DFLA.RETURN_REASON_CODE) RETURN_REASON_CODE,

DFLA.RMA_DELIVERED_QTY,

DFLA.ROOT_PARENT_FULFILL_LINE_ID,

DFLA.SCHEDULE_ARRIVAL_DATE,

DFLA.SCHEDULE_SHIP_DATE,

DFLA.SCHEDULING_REASON_CODE,

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

DFLA.SHIPPABLE_FLAG,

DFLA.SHIPPED_QTY,

DFLA.SHIPPED_UOM,

DFLA.SHIPPING_INSTRUCTIONS,

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

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

DFLA.SHIP_SET_NAME,

DFLA.SHIP_TO_CONTACT_ID,

DFLA.SHIP_TO_CONTACT_POINT_ID,

DFLA.SHIP_TO_CUSTOMER_ID,

DFLA.SHIP_TO_PARTY_CONTACT_ID,

DFLA.SHIP_TO_PARTY_ID,

DFLA.SHIP_TO_PARTY_SITE_ID,

DFLA.SHIP_TO_SITE_USE_ID,

DFLA.SHOW_IN_SALES,

DFLA.SOURCE_LINE_ID,

DFLA.SOURCE_LINE_NUMBER,

DFLA.SOURCE_ORDER_ID,

DFLA.SOURCE_ORDER_NUMBER,

DFLA.SOURCE_ORDER_SYSTEM,

DFLA.SOURCE_ORG_ID,

DFLA.SOURCE_REVISION_NUMBER,

DFLA.SOURCE_SCHEDULE_ID,

DFLA.SOURCE_SCHEDULE_NUMBER,

DFLA.SPLIT_FROM_FLINE_ID,

DFLA.STATUS_CODE,

DFLA.STATUS_RULESET_ID,

DFLA.SUBINVENTORY,

DFLA.SUBSTITUTE_ALLOWED_FLAG,

DFLA.SUBSTITUTE_REASON_CODE,

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

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

DFLA.SUPPLY_STATUS_CODE,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'ZX_OUTPUT_CLASSIFICATIONS', DFLA.TAX_CLASSIFICATION_CODE) TAX_CLASSIFICATION_CODE,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('LOOKUP_CODE', 'ZX_EXEMPTION_REASON_CODE', DFLA.TAX_EXEMPTION_REASON_CODE) TAX_EXEMPTION_REASON_CODE,

DFLA.TAX_EXEMPT_FLAG,

DFLA.TAX_INVOICE_DATE,

DFLA.TAX_INVOICE_NUMBER,

DFLA.THIRD_PTY_REG_ID,

DFLA.TOTAL_CONTRACT_AMOUNT,

DFLA.TOTAL_CONTRACT_QUANTITY,

DFLA.TRADE_COMPLIANCE_DATE,

DFLA.TRADE_COMPLIANCE_RESULT_CODE,

DFLA.TRANSPORTATION_PLANNED_FLAG,

DFLA.TRX_BUSINESS_CATEGORY,

DFLA.UNIT_LIST_PRICE,

DFLA.UNIT_QUANTITY,

DFLA.UNIT_SELLING_PRICE,

DFLA.USER_DEFINED_FISC_CLASS,

DFLA.VALID_CONFIGURATION_FLAG,

DFLA.SERVICE_DURATION_PERIOD_CODE,

DFLA.SERVICE_DURATION,

DFLA.SALES_PRODUCT_TYPE_CODE,

DFLA.ACTION_TYPE_CODE,

DFLA.ASSET_GROUP_NUMBER,

DFLA.ASSET_TRACKED_FLAG,

DFLA.PROCESS_SET,

DFLA.SALESPERSON_ID,

DFLA.SERVICE_CANCEL_DATE,

DFLA.UNREFERENCED_RETURN_FLAG,

DFLA.PRJ_REC_INDICATOR,

DFLA.SELLING_PROFIT_CENTER_BU_ID,

DFLA.INVENTORY_INTERFACED_FLAG,

DFLA.SECONDARY_UOM,

DFLA.SECONDARY_ORDERED_QTY,

DFLA.SECONDARY_SHIPPED_QTY,

DFLA.SECONDARY_RMA_DELIVERED_QTY,

DFLA.PRICE_USING_SEC_UOM_FLAG,

DFLA.SECONDARY_FULFILLED_QTY

FROM

DOO_FULFILL_LINES_ALL DFLA