SELECT dha.source_order_number , dha.order_number , dha.source_order_id , dla.line_number , dla.display_line_number , dfla.source_line_number , dfla.FULFILL_LINE_NUMBER , doc.ORDER_CHARGE_ID , doc.CHARGE_DEFINITION_CODE , doc.CHARGE_TYPE_CODE , doc.CHARGE_SUBTYPE_CODE , doc.CAN_ADJUST_FLAG , doc.PRICE_TYPE_CODE , doc.CHARGE_CURRENCY_CODE , doc.GSA_UNIT_PRICE , doc.PARENT_ENTITY_CODE , doc.PARENT_ENTITY_ID , doc.PRICED_QUANTITY , doc.PRICED_QUANTITY_UOM_CODE , doc.PRIMARY_FLAG , doc.SEQUENCE_NUMBER , doc.CHARGE_APPLIES_TO , doc.ROLLUP_FLAG , doc.PRICE_PERIODICITY_CODE , doc.SOURCE_CHARGE_ID , docc.ORDER_CHARGE_COMPONENT_ID , docc.ORDER_CHARGE_ID , docc.CREATION_DATE , docc.CHARGE_CURRENCY_CODE , docc.CHARGE_CURRENCY_EXT_AMOUNT , docc.HEADER_CURRENCY_CODE , docc.HEADER_CURRENCY_EXT_AMOUNT , docc.PERCENT_OF_COMPARISON_ELEMENT , docc.PRICE_ELEMENT_CODE , docc.PRICE_ELEMENT_USAGE_CODE , docc.SEQUENCE_NUMBER , docc.CHARGE_CURRENCY_UNIT_PRICE , docc.HEADER_CURRENCY_UNIT_PRICE , docc.ROLLUP_FLAG , docc.PARENT_CHARGE_COMPONENT_ID , docc.SOURCE_CHARGE_COMPONENT_ID , docc.SOURCE_CHARGE_ID , docc.SOURCE_MPA_ID , docc.SOURCE_PARENT_CHARGE_COMP_ID , docc.PRICING_SOURCE_ID , docc.PRICING_SOURCE_TYPE_CODE , docc.EXPLANATION , docc.EXPLANATION_MESSAGE_NAME , docc.REFERENCE_ORDER_CHARGE_COMP_ID , docc.OBJECT_VERSION_NUMBER , docc.TAX_INCLUDED_FLAG , docc.MODIFIED_FLAG , docc.CHARGE_CURR_DURATION_EXT_AMT , docc.HEADER_CURR_DURATION_EXT_AMT FROM fusion.doo_headers_all dha , fusion.doo_fulfill_lines_all dfla , fusion.doo_lines_all dla , fusion.DOO_ORDER_CHARGES doc , fusion.DOO_ORDER_CHARGE_COMPONENTS docc WHERE dha.header_id = dfla.header_id AND dfla.line_id = dla.line_id AND dha.submitted_flag = 'Y' AND doc.PARENT_ENTITY_CODE = 'LINE' AND doc.PARENT_ENTITY_ID = dfla.FULFILL_LINE_ID AND docc.ORDER_CHARGE_ID = doc.ORDER_CHARGE_ID AND dha.source_order_number = '11128' ORDER BY dha.creation_Date DESC , dla.line_number , dfla.FULFILL_LINE_NUMBER , doc.SEQUENCE_NUMBER , docc.SEQUENCE_NUMBER