DOO_COVERAGE_FLINES_DETAILS_V
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: VIEW
Columns
Name |
---|
DOC_SYSTEM_REF_ID DOCUMENT_HEADER_ID DOCUMENT_LINE_ID DOCUMENT_FULFILL_LINE_ID OWNER_TABLE_NAME OWNER_TABLE_ID DOC_REF_TYPE DOC_ID DOC_CONTEXT_ID DOC_USER_KEY DOC_ALT_USER_KEY DOC_LINE_ID DOC_LINE_CONTEXT_ID DOC_LINE_USER_KEY DOC_LINE_ALT_USER_KEY DOC_SUBLINE_ID DOC_SUBLINE_CONTEXT_ID DOC_SUBLINE_USER_KEY DOC_SUBLINE_ALT_USER_KEY REFERENCE_DOC_SYSTEM_REF_ID TASK_TYPE FLINE_FULFILL_LINE_ID RECEIVABLES_ORG_ID FLINE_HEADER_ID FLINE_LINE_ID FULFILL_LINE_NUMBER INVENTORY_ITEM_ID ITEM_TYPE_CODE ORDERED_QTY STATUS_CODE SOURCE_LINE_ID SOURCE_LINE_NUMBER SOURCE_ORDER_ID SOURCE_ORDER_NUMBER SOURCE_ORDER_SYSTEM SOURCE_SCHEDULE_ID SOURCE_SCHEDULE_NUMBER SOURCE_REVISION_NUMBER COMP_SEQ_PATH OWNER_ID FLINE_CREATION_DATE FLINE_CREATED_BY FLINE_LAST_UPDATE_DATE FLINE_LAST_UPDATED_BY FLINE_LAST_UPDATE_LOGIN FULFILL_ORG_ID CANCELED_QTY ORDERED_UOM PURCHASING_UOM SHIPPED_UOM RMA_DELIVERED_QTY FULFILLED_QTY SHIPPED_QTY RESERVED_QTY RESERVABLE_FLAG SHIPPABLE_FLAG INVOICEABLE_ITEM_FLAG INVOICE_ENABLED_FLAG RETURNABLE_FLAG INVOICE_INTERFACED_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 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 REFERENCE_FLINE_ID LATEST_ACCEPTABLE_SHIP_DATE LATEST_ACCEPTABLE_ARRIVAL_DATE EARLIEST_ACCEPTABLE_SHIP_DATE ON_HOLD RESERVATION_ID ACTUAL_COMPLETION_DATE INVENTORY_ORGANIZATION_ID FULFILL_INSTANCE_ID STATUS_RULESET_ID REMNANT_FLAG FULFILLMENT_SPLIT_REF_ID ESTIMATE_MARGIN ESTIMATE_FULFILLMENT_COST FREIGHT_TERMS_CODE CANCEL_REASON_CODE LATEST_EXT_FULFILL_LINE_NUMBER GOP_REQUEST_REGION SCHEDULING_REASON_CODE SUBINVENTORY SUPPLIER_ID SUPPLIER_SITE_ID SHIP_TO_PARTY_ID SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_CONTACT_ID CONFIG_ITEM_REFERENCE ITEM_SUB_TYPE_CODE REQUISITION_INVENTORY_ORG_ID REQUISITION_BU_ID FULFILLMENT_MODE PO_STATUS_CODE BUYER_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 DESTINATION_LOCATION_ID DESTINATION_ORG_ID QUANTITY_PER_MODEL CONFIG_INVENTORY_ITEM_ID PURCHASING_ENABLED_FLAG CUSTOMER_PO_SCHEDULE_NUMBER SUPPLY_STATUS_CODE SHIP_TO_CONTACT_POINT_ID PREF_OVERRIDDEN_BITSET APPLIED_PRICE_LIST_ID PRICED_ON REQUIRED_FULFILLMENT_DATE COMPONENT_ID_PATH VALID_CONFIGURATION_FLAG CONFIGURATOR_PATH CONFIG_HEADER_ID CONFIG_REVISION_NUMBER SHOW_IN_SALES CHANGE_ELIGIBLE_FLAG BILL_TO_CONTACT_POINT_ID UNIT_QUANTITY CONFIG_CREATION_DATE CONTRACT_START_DATE CONTRACT_END_DATE TOTAL_CONTRACT_QUANTITY TOTAL_CONTRACT_AMOUNT PROCESS_INSTANCE_ID PROCESS_NUMBER CREDIT_CHK_AUTH_NUM CREDIT_CHK_AUTH_EXP_DATE TRADE_COMPLIANCE_RESULT_CODE TRADE_COMPLIANCE_DATE TRANSPORTATION_PLANNED_FLAG CREATED_IN_RELEASE CONFIG_TRADE_COMPL_RESULT_CODE BILLING_TRX_TYPE_ID SERVICE_DURATION SERVICE_DURATION_PERIOD_CODE SALES_PRODUCT_TYPE_CODE ACTION_TYPE_CODE |
Query
SQL_Statement |
---|
SELECT DOO_DOCUMENT_REFERENCES.DOC_SYSTEM_REF_ID , DOO_DOCUMENT_REFERENCES.HEADER_ID DOCUMENT_HEADER_ID, DOO_DOCUMENT_REFERENCES.LINE_ID DOCUMENT_LINE_ID, DOO_DOCUMENT_REFERENCES.FULFILL_LINE_ID DOCUMENT_FULFILL_LINE_ID, DOO_DOCUMENT_REFERENCES.OWNER_TABLE_NAME, DOO_DOCUMENT_REFERENCES.OWNER_TABLE_ID, DOO_DOCUMENT_REFERENCES.DOC_REF_TYPE, DOO_DOCUMENT_REFERENCES.DOC_ID, DOO_DOCUMENT_REFERENCES.DOC_CONTEXT_ID, DOO_DOCUMENT_REFERENCES.DOC_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_ALT_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_LINE_ID, DOO_DOCUMENT_REFERENCES.DOC_LINE_CONTEXT_ID, DOO_DOCUMENT_REFERENCES.DOC_LINE_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_LINE_ALT_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_SUBLINE_ID, DOO_DOCUMENT_REFERENCES.DOC_SUBLINE_CONTEXT_ID, DOO_DOCUMENT_REFERENCES.DOC_SUBLINE_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_SUBLINE_ALT_USER_KEY, DOO_DOCUMENT_REFERENCES.REFERENCE_DOC_SYSTEM_REF_ID, DOO_DOCUMENT_REFERENCES.TASK_TYPE, DOO_FULFILL_LINES_ALL.FULFILL_LINE_ID FLINE_FULFILL_LINE_ID, DOO_FULFILL_LINES_ALL.RECEIVABLES_ORG_ID, DOO_FULFILL_LINES_ALL.HEADER_ID FLINE_HEADER_ID, DOO_FULFILL_LINES_ALL.LINE_ID FLINE_LINE_ID, DOO_FULFILL_LINES_ALL.FULFILL_LINE_NUMBER, DOO_FULFILL_LINES_ALL.INVENTORY_ITEM_ID, DOO_FULFILL_LINES_ALL.ITEM_TYPE_CODE, DOO_FULFILL_LINES_ALL.ORDERED_QTY, DOO_FULFILL_LINES_ALL.STATUS_CODE, DOO_FULFILL_LINES_ALL.SOURCE_LINE_ID, DOO_FULFILL_LINES_ALL.SOURCE_LINE_NUMBER, DOO_FULFILL_LINES_ALL.SOURCE_ORDER_ID, DOO_FULFILL_LINES_ALL.SOURCE_ORDER_NUMBER, DOO_FULFILL_LINES_ALL.SOURCE_ORDER_SYSTEM, DOO_FULFILL_LINES_ALL.SOURCE_SCHEDULE_ID, DOO_FULFILL_LINES_ALL.SOURCE_SCHEDULE_NUMBER, DOO_FULFILL_LINES_ALL.SOURCE_REVISION_NUMBER, DOO_FULFILL_LINES_ALL.COMP_SEQ_PATH, DOO_FULFILL_LINES_ALL.OWNER_ID, DOO_FULFILL_LINES_ALL.CREATION_DATE FLINE_CREATION_DATE, DOO_FULFILL_LINES_ALL.CREATED_BY FLINE_CREATED_BY, DOO_FULFILL_LINES_ALL.LAST_UPDATE_DATE FLINE_LAST_UPDATE_DATE, DOO_FULFILL_LINES_ALL.LAST_UPDATED_BY FLINE_LAST_UPDATED_BY, DOO_FULFILL_LINES_ALL.LAST_UPDATE_LOGIN FLINE_LAST_UPDATE_LOGIN, DOO_FULFILL_LINES_ALL.FULFILL_ORG_ID, DOO_FULFILL_LINES_ALL.CANCELED_QTY, DOO_FULFILL_LINES_ALL.ORDERED_UOM, DOO_FULFILL_LINES_ALL.PURCHASING_UOM, DOO_FULFILL_LINES_ALL.SHIPPED_UOM, DOO_FULFILL_LINES_ALL.RMA_DELIVERED_QTY, DOO_FULFILL_LINES_ALL.FULFILLED_QTY, DOO_FULFILL_LINES_ALL.SHIPPED_QTY, DOO_FULFILL_LINES_ALL.RESERVED_QTY, DOO_FULFILL_LINES_ALL.RESERVABLE_FLAG, DOO_FULFILL_LINES_ALL.SHIPPABLE_FLAG, DOO_FULFILL_LINES_ALL.INVOICEABLE_ITEM_FLAG, DOO_FULFILL_LINES_ALL.INVOICE_ENABLED_FLAG, DOO_FULFILL_LINES_ALL.RETURNABLE_FLAG, DOO_FULFILL_LINES_ALL.INVOICE_INTERFACED_FLAG, DOO_FULFILL_LINES_ALL.BILL_TO_CONTACT_ID, DOO_FULFILL_LINES_ALL.BILL_TO_CUSTOMER_ID, DOO_FULFILL_LINES_ALL.BILL_TO_SITE_USE_ID, DOO_FULFILL_LINES_ALL.SOURCE_ORG_ID, DOO_FULFILL_LINES_ALL.ORG_ID, DOO_FULFILL_LINES_ALL.REQUEST_ARRIVAL_DATE, DOO_FULFILL_LINES_ALL.REQUEST_SHIP_DATE, DOO_FULFILL_LINES_ALL.SCHEDULE_ARRIVAL_DATE, DOO_FULFILL_LINES_ALL.SCHEDULE_SHIP_DATE, DOO_FULFILL_LINES_ALL.PROMISE_ARRIVAL_DATE, DOO_FULFILL_LINES_ALL.PROMISE_SHIP_DATE, DOO_FULFILL_LINES_ALL.ACTUAL_SHIP_DATE, DOO_FULFILL_LINES_ALL.FULFILLMENT_DATE, DOO_FULFILL_LINES_ALL.CUSTOMER_ITEM_ID, DOO_FULFILL_LINES_ALL.CUSTOMER_PO_LINE_NUMBER, DOO_FULFILL_LINES_ALL.CUSTOMER_PO_NUMBER, DOO_FULFILL_LINES_ALL.DEMAND_CLASS_CODE, DOO_FULFILL_LINES_ALL.EXTENDED_AMOUNT, DOO_FULFILL_LINES_ALL.FOB_POINT_CODE, DOO_FULFILL_LINES_ALL.CARRIER_ID, DOO_FULFILL_LINES_ALL.INVOICING_RULE_ID, DOO_FULFILL_LINES_ALL.EXEMPTION_CERTIFICATE_NUMBER, DOO_FULFILL_LINES_ALL.ACCOUNTING_RULE_ID, DOO_FULFILL_LINES_ALL.LINE_TYPE_CODE, DOO_FULFILL_LINES_ALL.CATEGORY_CODE, DOO_FULFILL_LINES_ALL.OPEN_FLAG, DOO_FULFILL_LINES_ALL.CANCELED_FLAG, DOO_FULFILL_LINES_ALL.OVERRIDE_SCHEDULE_DATE_FLAG, DOO_FULFILL_LINES_ALL.ORIGINAL_INVENTORY_ITEM_ID, DOO_FULFILL_LINES_ALL.GOP_REFERENCE_ID, DOO_FULFILL_LINES_ALL.PACKING_INSTRUCTIONS, DOO_FULFILL_LINES_ALL.PARENT_FULFILL_LINE_ID, DOO_FULFILL_LINES_ALL.PAYMENT_TERM_ID, DOO_FULFILL_LINES_ALL.REQUEST_TYPE, DOO_FULFILL_LINES_ALL.RETURN_REASON_CODE, DOO_FULFILL_LINES_ALL.ORIG_SYS_DOCUMENT_REF, DOO_FULFILL_LINES_ALL.ORIG_SYS_DOCUMENT_LINE_REF, DOO_FULFILL_LINES_ALL.ROOT_PARENT_FULFILL_LINE_ID, DOO_FULFILL_LINES_ALL.SHIP_CLASS_OF_SERVICE, DOO_FULFILL_LINES_ALL.SHIP_MODE_OF_TRANSPORT, DOO_FULFILL_LINES_ALL.SHIP_TO_CONTACT_ID, DOO_FULFILL_LINES_ALL.SHIP_TO_CUSTOMER_ID, DOO_FULFILL_LINES_ALL.SHIP_TO_SITE_USE_ID, DOO_FULFILL_LINES_ALL.FULFILL_TOLERANCE_ABOVE, DOO_FULFILL_LINES_ALL.FULFILL_TOLERANCE_BELOW, DOO_FULFILL_LINES_ALL.SHIPMENT_PRIORITY_CODE, DOO_FULFILL_LINES_ALL.SHIPPING_INSTRUCTIONS, DOO_FULFILL_LINES_ALL.SHIP_SET_NAME, DOO_FULFILL_LINES_ALL.SPLIT_FROM_FLINE_ID, DOO_FULFILL_LINES_ALL.PARTIAL_SHIP_ALLOWED_FLAG, DOO_FULFILL_LINES_ALL.SUBSTITUTE_ALLOWED_FLAG, DOO_FULFILL_LINES_ALL.SUBSTITUTE_REASON_CODE, DOO_FULFILL_LINES_ALL.TAX_EXEMPT_FLAG, DOO_FULFILL_LINES_ALL.TAX_CLASSIFICATION_CODE, DOO_FULFILL_LINES_ALL.TAX_EXEMPTION_REASON_CODE, DOO_FULFILL_LINES_ALL.UNIT_LIST_PRICE, DOO_FULFILL_LINES_ALL.UNIT_SELLING_PRICE, DOO_FULFILL_LINES_ALL.REFERENCE_FLINE_ID, DOO_FULFILL_LINES_ALL.LATEST_ACCEPTABLE_SHIP_DATE, DOO_FULFILL_LINES_ALL.LATEST_ACCEPTABLE_ARRIVAL_DATE, DOO_FULFILL_LINES_ALL.EARLIEST_ACCEPTABLE_SHIP_DATE, DOO_FULFILL_LINES_ALL.ON_HOLD, DOO_FULFILL_LINES_ALL.RESERVATION_ID, DOO_FULFILL_LINES_ALL.ACTUAL_COMPLETION_DATE, DOO_FULFILL_LINES_ALL.INVENTORY_ORGANIZATION_ID, DOO_FULFILL_LINES_ALL.FULFILL_INSTANCE_ID, DOO_FULFILL_LINES_ALL.STATUS_RULESET_ID, DOO_FULFILL_LINES_ALL.REMNANT_FLAG, DOO_FULFILL_LINES_ALL.FULFILLMENT_SPLIT_REF_ID, DOO_FULFILL_LINES_ALL.ESTIMATE_MARGIN, DOO_FULFILL_LINES_ALL.ESTIMATE_FULFILLMENT_COST, DOO_FULFILL_LINES_ALL.FREIGHT_TERMS_CODE, DOO_FULFILL_LINES_ALL.CANCEL_REASON_CODE, DOO_FULFILL_LINES_ALL.LATEST_EXT_FULFILL_LINE_NUMBER, DOO_FULFILL_LINES_ALL.GOP_REQUEST_REGION, DOO_FULFILL_LINES_ALL.SCHEDULING_REASON_CODE, DOO_FULFILL_LINES_ALL.SUBINVENTORY, DOO_FULFILL_LINES_ALL.SUPPLIER_ID, DOO_FULFILL_LINES_ALL.SUPPLIER_SITE_ID, DOO_FULFILL_LINES_ALL.SHIP_TO_PARTY_ID, DOO_FULFILL_LINES_ALL.SHIP_TO_PARTY_SITE_ID, DOO_FULFILL_LINES_ALL.SHIP_TO_PARTY_CONTACT_ID, DOO_FULFILL_LINES_ALL.CONFIG_ITEM_REFERENCE, DOO_FULFILL_LINES_ALL.ITEM_SUB_TYPE_CODE, DOO_FULFILL_LINES_ALL.REQUISITION_INVENTORY_ORG_ID, DOO_FULFILL_LINES_ALL.REQUISITION_BU_ID, DOO_FULFILL_LINES_ALL.FULFILLMENT_MODE, DOO_FULFILL_LINES_ALL.PO_STATUS_CODE, DOO_FULFILL_LINES_ALL.BUYER_ID, DOO_FULFILL_LINES_ALL.REQUEST_CANCEL_DATE, DOO_FULFILL_LINES_ALL.COMMENTS, DOO_FULFILL_LINES_ALL.DEFAULT_TAXATION_COUNTRY, DOO_FULFILL_LINES_ALL.FIRST_PTY_REG_ID, DOO_FULFILL_LINES_ALL.THIRD_PTY_REG_ID, DOO_FULFILL_LINES_ALL.DOCUMENT_SUB_TYPE, DOO_FULFILL_LINES_ALL.TAX_INVOICE_NUMBER, DOO_FULFILL_LINES_ALL.TAX_INVOICE_DATE, DOO_FULFILL_LINES_ALL.FINAL_DISCHARGE_LOCATION_ID, DOO_FULFILL_LINES_ALL.PROD_FC_CATEG_ID, DOO_FULFILL_LINES_ALL.PRODUCT_TYPE, DOO_FULFILL_LINES_ALL.PRODUCT_CATEGORY, DOO_FULFILL_LINES_ALL.TRX_BUSINESS_CATEGORY, DOO_FULFILL_LINES_ALL.ASSESSABLE_VALUE, DOO_FULFILL_LINES_ALL.USER_DEFINED_FISC_CLASS, DOO_FULFILL_LINES_ALL.INTENDED_USE_CLASSIF_ID, DOO_FULFILL_LINES_ALL.DESTINATION_LOCATION_ID, DOO_FULFILL_LINES_ALL.DESTINATION_ORG_ID, DOO_FULFILL_LINES_ALL.QUANTITY_PER_MODEL, DOO_FULFILL_LINES_ALL.CONFIG_INVENTORY_ITEM_ID, DOO_FULFILL_LINES_ALL.PURCHASING_ENABLED_FLAG, DOO_FULFILL_LINES_ALL.CUSTOMER_PO_SCHEDULE_NUMBER, DOO_FULFILL_LINES_ALL.SUPPLY_STATUS_CODE, DOO_FULFILL_LINES_ALL.SHIP_TO_CONTACT_POINT_ID, DOO_FULFILL_LINES_ALL.PREF_OVERRIDDEN_BITSET, DOO_FULFILL_LINES_ALL.APPLIED_PRICE_LIST_ID, DOO_FULFILL_LINES_ALL.PRICED_ON, DOO_FULFILL_LINES_ALL.REQUIRED_FULFILLMENT_DATE, DOO_FULFILL_LINES_ALL.COMPONENT_ID_PATH, DOO_FULFILL_LINES_ALL.VALID_CONFIGURATION_FLAG, DOO_FULFILL_LINES_ALL.CONFIGURATOR_PATH, DOO_FULFILL_LINES_ALL.CONFIG_HEADER_ID, DOO_FULFILL_LINES_ALL.CONFIG_REVISION_NUMBER, DOO_FULFILL_LINES_ALL.SHOW_IN_SALES, DOO_FULFILL_LINES_ALL.CHANGE_ELIGIBLE_FLAG, DOO_FULFILL_LINES_ALL.BILL_TO_CONTACT_POINT_ID, DOO_FULFILL_LINES_ALL.UNIT_QUANTITY, DOO_FULFILL_LINES_ALL.CONFIG_CREATION_DATE, DOO_FULFILL_LINES_ALL.CONTRACT_START_DATE, DOO_FULFILL_LINES_ALL.CONTRACT_END_DATE, DOO_FULFILL_LINES_ALL.TOTAL_CONTRACT_QUANTITY, DOO_FULFILL_LINES_ALL.TOTAL_CONTRACT_AMOUNT, DOO_FULFILL_LINES_ALL.PROCESS_INSTANCE_ID, DOO_FULFILL_LINES_ALL.PROCESS_NUMBER, DOO_FULFILL_LINES_ALL.CREDIT_CHK_AUTH_NUM, DOO_FULFILL_LINES_ALL.CREDIT_CHK_AUTH_EXP_DATE, DOO_FULFILL_LINES_ALL.TRADE_COMPLIANCE_RESULT_CODE, DOO_FULFILL_LINES_ALL.TRADE_COMPLIANCE_DATE, DOO_FULFILL_LINES_ALL.TRANSPORTATION_PLANNED_FLAG, DOO_FULFILL_LINES_ALL.CREATED_IN_RELEASE, DOO_FULFILL_LINES_ALL.CONFIG_TRADE_COMPL_RESULT_CODE, DOO_FULFILL_LINES_ALL.BILLING_TRX_TYPE_ID, DOO_FULFILL_LINES_ALL.SERVICE_DURATION, DOO_FULFILL_LINES_ALL.SERVICE_DURATION_PERIOD_CODE, DOO_FULFILL_LINES_ALL.SALES_PRODUCT_TYPE_CODE, DOO_FULFILL_LINES_ALL.ACTION_TYPE_CODE FROM DOO_FULFILL_LINES_ALL, DOO_DOCUMENT_REFERENCES WHERE DOO_FULFILL_LINES_ALL.FULFILL_LINE_ID = DOO_DOCUMENT_REFERENCES.FULFILL_LINE_ID AND DOO_DOCUMENT_REFERENCES.DOC_REF_TYPE = 'COVERAGE_COVERED_ASSOCIATION' |