DOO_COVERAGE_FLINES_DETAILS

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

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'

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'