DOO_ORDER_FLINES_V

Details

• Schema: FUSION

• Object owner: DOO

• Object type: VIEW

Columns

Name

FULFILL_LINE_ID FULFILL_LINE_NUMBER LINE_ID HEADER_ID OBJECT_VERSION_NUMBER STATUS_CODE OWNER_ID SOURCE_LINE_ID SOURCE_LINE_NUMBER SOURCE_ORDER_ID SOURCE_ORDER_NUMBER SOURCE_ORDER_SYSTEM SOURCE_SCHEDULE_ID SOURCE_SCHEDULE_NUMBER INVENTORY_ITEM_ID ITEM_TYPE_CODE FULFILL_ORG_ID ORDERED_QTY ORDERED_UOM SECONDARY_UOM SECONDARY_ORDERED_QTY RMA_DELIVERED_QTY FULFILLED_QTY SHIPPED_QTY RESERVED_QTY RESERVABLE_FLAG SHIPPABLE_FLAG INVOICEABLE_ITEM_FLAG INVOICE_ENABLED_FLAG BILL_TO_CONTACT_ID BILL_TO_CUSTOMER_ID BILL_TO_SITE_USE_ID SOURCE_ORG_ID ORG_ID REQUEST_ARRIVAL_DATE REQUEST_SHIP_DATE SCHEDULE_ARRIVAL_DATE SCHEDULE_SHIP_DATE PROMISE_ARRIVAL_DATE PROMISE_SHIP_DATE ACTUAL_SHIP_DATE FULFILLMENT_DATE CUSTOMER_ITEM_ID CUSTOMER_PO_LINE_NUMBER CUSTOMER_PO_NUMBER DEMAND_CLASS_CODE EXTENDED_AMOUNT FOB_POINT_CODE CARRIER_ID INVOICING_RULE_ID EXEMPTION_CERTIFICATE_NUMBER ACCOUNTING_RULE_ID LINE_TYPE_CODE CATEGORY_CODE OPEN_FLAG CANCELED_FLAG OVERRIDE_SCHEDULE_DATE_FLAG INVOICE_INTERFACED_FLAG ORIGINAL_INVENTORY_ITEM_ID GOP_REFERENCE_ID PACKING_INSTRUCTIONS PARENT_FULFILL_LINE_ID PAYMENT_TERM_ID REQUEST_TYPE RETURN_REASON_CODE ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_LINE_REF ROOT_PARENT_FULFILL_LINE_ID SHIP_CLASS_OF_SERVICE SHIP_MODE_OF_TRANSPORT SHIP_TO_CONTACT_ID SHIP_TO_CUSTOMER_ID SHIP_TO_SITE_USE_ID FULFILL_TOLERANCE_ABOVE FULFILL_TOLERANCE_BELOW SHIPMENT_PRIORITY_CODE SHIPPING_INSTRUCTIONS SHIP_SET_NAME SPLIT_FROM_FLINE_ID PARTIAL_SHIP_ALLOWED_FLAG SUBSTITUTE_ALLOWED_FLAG SUBSTITUTE_REASON_CODE TAX_EXEMPT_FLAG TAX_CLASSIFICATION_CODE TAX_EXEMPTION_REASON_CODE UNIT_LIST_PRICE UNIT_SELLING_PRICE LATEST_ACCEPTABLE_SHIP_DATE LATEST_ACCEPTABLE_ARRIVAL_DATE EARLIEST_ACCEPTABLE_SHIP_DATE CANCELED_QTY RETURNABLE_FLAG DELTA_TYPE PRIMARY_TASK_STATUS REFERENCE_FLINE_ID REMNANT_FLAG ON_HOLD RESERVATION_ID ACTUAL_COMPLETION_DATE INVENTORY_ORGANIZATION_ID FULFILL_INSTANCE_ID FULFILLMENT_SPLIT_REF_ID ESTIMATE_MARGIN ESTIMATE_FULFILLMENT_COST COMP_SEQ_PATH STATUS_RULESET_ID SOURCE_REVISION_NUMBER FREIGHT_TERMS_CODE CANCEL_REASON_CODE LATEST_EXT_FULFILL_LINE_NUMBER GOP_REQUEST_REGION SCHEDULING_REASON_CODE SUBINVENTORY CONFIG_ITEM_REFERENCE ITEM_SUB_TYPE_CODE SHIP_TO_PARTY_ID SHIP_TO_PARTY_CONTACT_ID SHIP_TO_PARTY_SITE_ID RECEIVABLES_ORG_ID REQUEST_CANCEL_DATE COMMENTS DEFAULT_TAXATION_COUNTRY FIRST_PTY_REG_ID THIRD_PTY_REG_ID DOCUMENT_SUB_TYPE TAX_INVOICE_NUMBER TAX_INVOICE_DATE FINAL_DISCHARGE_LOCATION_ID PROD_FC_CATEG_ID PRODUCT_TYPE PRODUCT_CATEGORY TRX_BUSINESS_CATEGORY ASSESSABLE_VALUE USER_DEFINED_FISC_CLASS INTENDED_USE_CLASSIF_ID PURCHASING_ENABLED_FLAG CUSTOMER_PO_SCHEDULE_NUMBER DESTINATION_ORG_ID DESTINATION_LOCATION_ID PO_STATUS_CODE REQUIRED_FULFILLMENT_DATE CONTRACT_START_DATE CONTRACT_END_DATE FULFILLMENT_MODE PURCHASING_UOM SHIPPED_UOM QUANTITY_PER_MODEL CONFIG_INVENTORY_ITEM_ID SUPPLY_STATUS_CODE SHIP_TO_CONTACT_POINT_ID APPLIED_PRICE_LIST_ID PRICED_ON BILL_TO_CONTACT_POINT_ID UNIT_QUANTITY SUPPLIER_ID SUPPLIER_SITE_ID TRADE_COMPLIANCE_RESULT_CODE CONFIG_TRADE_COMPL_RESULT_CODE TRANSPORTATION_PLANNED_FLAG SERVICE_DURATION SERVICE_DURATION_PERIOD_CODE SALES_PRODUCT_TYPE_CODE ASSET_TRACKED_FLAG ASSET_GROUP_NUMBER SERVICE_CANCEL_DATE UNREFERENCED_RETURN_FLAG SALESPERSON_ID PRJ_REC_INDICATOR AGREEMENT_HEADER_ID SELLING_PROFIT_CENTER_BU_ID SUBSCRIPTION_PROFILE_ID EXTERNAL_PRICE_BOOK_NAME END_REASON_CODE END_CREDIT_METHOD_CODE END_DATE ACTION_TYPE_CODE SUBSCRIPTION_INTERFACED_FLAG INVENTORY_INTERFACED_FLAG INVENTORY_TRANSACTION_FLAG DEMAND_SOURCE_LINE_REFERENCE DEMAND_SOURCE_SCHEDULED_FLAG CREDIT_CHK_AUTH_NUM DRAFT_SCHEDULED_FLAG PROMOTION_ITEM_FLAG

Query

SQL_Statement

SELECT FULFILL_LINE_ID, FULFILL_LINE_NUMBER, LINE_ID, HEADER_ID, OBJECT_VERSION_NUMBER, STATUS_CODE, OWNER_ID, SOURCE_LINE_ID, SOURCE_LINE_NUMBER, SOURCE_ORDER_ID, SOURCE_ORDER_NUMBER, SOURCE_ORDER_SYSTEM, SOURCE_SCHEDULE_ID, SOURCE_SCHEDULE_NUMBER, INVENTORY_ITEM_ID, ITEM_TYPE_CODE, FULFILL_ORG_ID, ORDERED_QTY, ORDERED_UOM, SECONDARY_UOM, SECONDARY_ORDERED_QTY, RMA_DELIVERED_QTY, FULFILLED_QTY, SHIPPED_QTY, RESERVED_QTY, RESERVABLE_FLAG, SHIPPABLE_FLAG, INVOICEABLE_ITEM_FLAG, INVOICE_ENABLED_FLAG, BILL_TO_CONTACT_ID, BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID, SOURCE_ORG_ID, ORG_ID, REQUEST_ARRIVAL_DATE, REQUEST_SHIP_DATE, SCHEDULE_ARRIVAL_DATE, SCHEDULE_SHIP_DATE, PROMISE_ARRIVAL_DATE, PROMISE_SHIP_DATE, ACTUAL_SHIP_DATE, FULFILLMENT_DATE, CUSTOMER_ITEM_ID, CUSTOMER_PO_LINE_NUMBER, CUSTOMER_PO_NUMBER, DEMAND_CLASS_CODE, EXTENDED_AMOUNT, FOB_POINT_CODE, CARRIER_ID, INVOICING_RULE_ID, EXEMPTION_CERTIFICATE_NUMBER, ACCOUNTING_RULE_ID, LINE_TYPE_CODE, CATEGORY_CODE, OPEN_FLAG, CANCELED_FLAG, OVERRIDE_SCHEDULE_DATE_FLAG, INVOICE_INTERFACED_FLAG, ORIGINAL_INVENTORY_ITEM_ID, GOP_REFERENCE_ID, PACKING_INSTRUCTIONS, PARENT_FULFILL_LINE_ID, PAYMENT_TERM_ID, REQUEST_TYPE, RETURN_REASON_CODE, ORIG_SYS_DOCUMENT_REF, ORIG_SYS_DOCUMENT_LINE_REF, ROOT_PARENT_FULFILL_LINE_ID, SHIP_CLASS_OF_SERVICE, SHIP_MODE_OF_TRANSPORT, SHIP_TO_CONTACT_ID, SHIP_TO_CUSTOMER_ID, SHIP_TO_SITE_USE_ID, FULFILL_TOLERANCE_ABOVE, FULFILL_TOLERANCE_BELOW, SHIPMENT_PRIORITY_CODE, SHIPPING_INSTRUCTIONS, SHIP_SET_NAME, SPLIT_FROM_FLINE_ID, PARTIAL_SHIP_ALLOWED_FLAG, SUBSTITUTE_ALLOWED_FLAG, SUBSTITUTE_REASON_CODE, TAX_EXEMPT_FLAG, TAX_CLASSIFICATION_CODE, TAX_EXEMPTION_REASON_CODE, UNIT_LIST_PRICE, UNIT_SELLING_PRICE, LATEST_ACCEPTABLE_SHIP_DATE, LATEST_ACCEPTABLE_ARRIVAL_DATE, EARLIEST_ACCEPTABLE_SHIP_DATE, CANCELED_QTY, RETURNABLE_FLAG, DELTA_TYPE, '' PRIMARY_TASK_STATUS, REFERENCE_FLINE_ID, REMNANT_FLAG, ON_HOLD, RESERVATION_ID, ACTUAL_COMPLETION_DATE, INVENTORY_ORGANIZATION_ID, FULFILL_INSTANCE_ID, FULFILLMENT_SPLIT_REF_ID, ESTIMATE_MARGIN, ESTIMATE_FULFILLMENT_COST, COMP_SEQ_PATH, STATUS_RULESET_ID, SOURCE_REVISION_NUMBER, FREIGHT_TERMS_CODE, CANCEL_REASON_CODE, LATEST_EXT_FULFILL_LINE_NUMBER, GOP_REQUEST_REGION, SCHEDULING_REASON_CODE, SUBINVENTORY, CONFIG_ITEM_REFERENCE, ITEM_SUB_TYPE_CODE, SHIP_TO_PARTY_ID, SHIP_TO_PARTY_CONTACT_ID, SHIP_TO_PARTY_SITE_ID, RECEIVABLES_ORG_ID, REQUEST_CANCEL_DATE, COMMENTS, DEFAULT_TAXATION_COUNTRY, FIRST_PTY_REG_ID, THIRD_PTY_REG_ID, DOCUMENT_SUB_TYPE, TAX_INVOICE_NUMBER , TAX_INVOICE_DATE, FINAL_DISCHARGE_LOCATION_ID, PROD_FC_CATEG_ID, PRODUCT_TYPE , PRODUCT_CATEGORY , TRX_BUSINESS_CATEGORY , ASSESSABLE_VALUE, USER_DEFINED_FISC_CLASS , INTENDED_USE_CLASSIF_ID , PURCHASING_ENABLED_FLAG, CUSTOMER_PO_SCHEDULE_NUMBER, DESTINATION_ORG_ID, DESTINATION_LOCATION_ID, PO_STATUS_CODE, REQUIRED_FULFILLMENT_DATE, CONTRACT_START_DATE, CONTRACT_END_DATE, FULFILLMENT_MODE, PURCHASING_UOM, SHIPPED_UOM, QUANTITY_PER_MODEL , CONFIG_INVENTORY_ITEM_ID , SUPPLY_STATUS_CODE , SHIP_TO_CONTACT_POINT_ID, APPLIED_PRICE_LIST_ID, PRICED_ON, BILL_TO_CONTACT_POINT_ID, UNIT_QUANTITY , SUPPLIER_ID, SUPPLIER_SITE_ID, TRADE_COMPLIANCE_RESULT_CODE , CONFIG_TRADE_COMPL_RESULT_CODE, TRANSPORTATION_PLANNED_FLAG, SERVICE_DURATION, SERVICE_DURATION_PERIOD_CODE, SALES_PRODUCT_TYPE_CODE, ASSET_TRACKED_FLAG, ASSET_GROUP_NUMBER, SERVICE_CANCEL_DATE, UNREFERENCED_RETURN_FLAG, SALESPERSON_ID, PRJ_REC_INDICATOR, AGREEMENT_HEADER_ID, SELLING_PROFIT_CENTER_BU_ID, SUBSCRIPTION_PROFILE_ID, EXTERNAL_PRICE_BOOK_NAME, END_REASON_CODE, END_CREDIT_METHOD_CODE, END_DATE, ACTION_TYPE_CODE, SUBSCRIPTION_INTERFACED_FLAG, INVENTORY_INTERFACED_FLAG, INVENTORY_TRANSACTION_FLAG, DEMAND_SOURCE_LINE_REFERENCE, DEMAND_SOURCE_SCHEDULED_FLAG, CREDIT_CHK_AUTH_NUM, DRAFT_SCHEDULED_FLAG, PROMOTION_ITEM_FLAG FROM DOO_FULFILL_LINES_ALL