DOO_FULFILLMENT_DETAILS_V

Details

• Schema: FUSION

• Object owner: DOO

• Object type: VIEW

Columns

Name

DOO_ORDER_HEADER_ID SELLING_ORG_ID SELLING_LEGAL_ENTITY_ID CUSTOMER_ID DOO_ORDER_DATE DOO_ORDER_CURRENCY CONVERSION_RATE CONVERSION_TYPE_CODE CONVERSION_DATE DOO_LINE_ID DOO_LINE_NUMBER INVENTORY_ITEM_ID INVENTORY_ORGANIZATION_ID FULFILL_LINE_ID REFERENCE_FLINE_ID SOURCE_ORDER_NUMBER BILL_TO_CUSTOMER_ID BILL_TO_SITE_USE_ID SHIP_TO_PARTY_ID SHIP_TO_PARTY_SITE_ID SOLD_TO_PARTY_ID PARENT_FULFILL_LINE_ID SHIP_TO_CUSTOMER_ID UNIT_SELLING_PRICE ROOT_PARENT_FULFILL_LINE_ID SELLING_PROFIT_CENTER_BU_ID TASK_TYPE DELIVERY_NAME RMA_RECEIPT_TRANSACTION_ID STATUS FULFILL_LINE_DETAIL_ID INVENTORY_INTERFACED_FLAG SECONDARY_UOM SECONDARY_ORDERED_QTY SECONDARY_SHIPPED_QTY SECONDARY_RMA_DELIVERED_QTY PRICE_USING_SEC_UOM_FLAG SECONDARY_FULFILLED_QTY SECONDARY_QUANTITY

Query

SQL_Statement

SELECT doh.header_id doo_order_header_id ,doh.org_id selling_org_id ,doh.legal_entity_id selling_legal_entity_id ,doh.sold_to_customer_id customer_id ,doh.ordered_date doo_order_date ,doh.transactional_currency_code doo_order_currency ,doh.conversion_rate ,doh.conversion_type_code ,doh.conversion_date ,dol.line_id doo_line_id ,dol.line_number doo_line_number ,dol.inventory_item_id ,dol.inventory_organization_id ,dofl.fulfill_line_id ,dofl.reference_fline_id ,dofl.source_order_number ,dofl.bill_to_customer_id ,dofl.BILL_TO_SITE_USE_ID ,dofl.SHIP_TO_PARTY_ID ,dofl.SHIP_TO_PARTY_SITE_ID ,doh.SOLD_TO_PARTY_ID ,dofl.parent_fulfill_line_id ,dofl.ship_to_customer_id ,dofl.unit_selling_price ,dofl.root_parent_fulfill_line_id ,dofl.selling_profit_center_bu_id ,dofld.task_type ,dofld.delivery_name ,dofld.rma_receipt_transaction_id ,dofld.status ,dofld.fulfill_line_detail_id ,dofl.inventory_interfaced_flag ,dofl.secondary_uom ,dofl.secondary_ordered_qty ,dofl.secondary_shipped_qty ,dofl.secondary_rma_delivered_qty ,dofl.price_using_sec_uom_flag ,dofl.secondary_fulfilled_qty ,dofld.secondary_quantity FROM doo_headers_all doh ,doo_lines_all dol ,doo_fulfill_lines_all dofl ,doo_fulfill_line_details dofld WHERE doh.header_id = dol.header_id and dofl.header_id = dol.header_id and dofl.line_id = dol.line_id and dofld.fulfill_line_id(+) = dofl.fulfill_line_id