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