VIEW: APPS.ISC_BOOK_SUM2_F_V

Source

View Text - Preformatted

SELECT "LINE_ID","CURRENCY_FUNC_ID","CURR_WH_FUNC_ID","CUSTOMER_ID","INVENTORY_ITEM_ID","INV_ORG_ID","INV_OU_ID","ITEM_ID","ITEM_INV_ORG_ID","ORDER_CATEGORY_ID","ORDER_SOURCE_ID","ORDER_TYPE_ID","ORG_OU_ID","RETURN_REASON_ID","SALES_CHANNEL_ID","SHIP_TO_ORG_ID","SOLD_TO_ORG_ID","TIME_ACT_SHIP_DATE_ID","TIME_BOOKED_DATE_ID","TIME_FULFILLED_DATE_ID","TIME_ORDERED_DATE_ID","TIME_PROMISE_DATE_ID","TIME_REQUEST_DATE_ID","TIME_SCHEDULE_DATE_ID","TIME_SHIPPED_DATE_ID","TOP_MODEL_ITEM_ID","TOP_MODEL_ORG_ID","ACTUAL_SHIPMENT_DATE","ATO_LINE_ID","BOOKED_AMT_F","BOOKED_AMT_F1","BOOKED_AMT_G","BOOKED_QTY_INV","BOOKED_DATE","BOOKED_LIST_AMT_F","BOOKED_LIST_AMT_F1","BOOKED_LIST_AMT_G","COUNT_PDUE_LINE","COUNT_SHIP_LINE","FLOW_STATUS_CODE","FULFILLED_AMT_F","FULFILLED_AMT_F1","FULFILLED_AMT_G","FULFILLED_QTY_INV","FULFILLED_DATE","FULFILLED_FLAG","HEADER_ID","H_MARKETING_SOURCE_CODE_ID","INVOICED_AMT_F","INVOICED_AMT_F1","INVOICED_AMT_G","INVOICED_QTY_INV","INVOICE_TO_ORG_ID","ITEM_TYPE_CODE","LINE_CATEGORY_CODE","LINE_ITEM_TYPE","LINE_NUMBER","MARKETING_SOURCE_CODE_ID","OPEN_FLAG","ORDERED_DATE","ORDERED_QUANTITY","ORDER_DATE_TYPE_CODE","ORDER_NUMBER","ORDER_QUANTITY_UOM","INV_UOM_CODE","PROMISE_DATE","REQUEST_DATE","SCHEDULE_SHIP_DATE","SERVICE_PARENT_LINE_ID","SHIPPABLE_FLAG","SHIPPED_AMT_F","SHIPPED_AMT_F1","SHIPPED_AMT_G","SHIPPED_QTY_INV","SHIPPED_DATE","TOP_MODEL_LINE_ID","UNIT_LIST_PRICE","UNIT_SELLING_PRICE","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","SHIP_TO_PARTY_ID","BOOKED_AMT_G1","BOOKED_LIST_AMT_G1","FULFILLED_AMT_G1","INVOICED_AMT_G1","SHIPPED_AMT_G1","FREIGHT_CHARGE","FREIGHT_CHARGE_F","FREIGHT_CHARGE_G","FREIGHT_CHARGE_G1","FREIGHT_COST","FREIGHT_COST_F","FREIGHT_COST_G","FREIGHT_COST_G1" FROM ISC_BOOK_SUM2_F

View Text - HTML Formatted

SELECT "LINE_ID"
, "CURRENCY_FUNC_ID"
, "CURR_WH_FUNC_ID"
, "CUSTOMER_ID"
, "INVENTORY_ITEM_ID"
, "INV_ORG_ID"
, "INV_OU_ID"
, "ITEM_ID"
, "ITEM_INV_ORG_ID"
, "ORDER_CATEGORY_ID"
, "ORDER_SOURCE_ID"
, "ORDER_TYPE_ID"
, "ORG_OU_ID"
, "RETURN_REASON_ID"
, "SALES_CHANNEL_ID"
, "SHIP_TO_ORG_ID"
, "SOLD_TO_ORG_ID"
, "TIME_ACT_SHIP_DATE_ID"
, "TIME_BOOKED_DATE_ID"
, "TIME_FULFILLED_DATE_ID"
, "TIME_ORDERED_DATE_ID"
, "TIME_PROMISE_DATE_ID"
, "TIME_REQUEST_DATE_ID"
, "TIME_SCHEDULE_DATE_ID"
, "TIME_SHIPPED_DATE_ID"
, "TOP_MODEL_ITEM_ID"
, "TOP_MODEL_ORG_ID"
, "ACTUAL_SHIPMENT_DATE"
, "ATO_LINE_ID"
, "BOOKED_AMT_F"
, "BOOKED_AMT_F1"
, "BOOKED_AMT_G"
, "BOOKED_QTY_INV"
, "BOOKED_DATE"
, "BOOKED_LIST_AMT_F"
, "BOOKED_LIST_AMT_F1"
, "BOOKED_LIST_AMT_G"
, "COUNT_PDUE_LINE"
, "COUNT_SHIP_LINE"
, "FLOW_STATUS_CODE"
, "FULFILLED_AMT_F"
, "FULFILLED_AMT_F1"
, "FULFILLED_AMT_G"
, "FULFILLED_QTY_INV"
, "FULFILLED_DATE"
, "FULFILLED_FLAG"
, "HEADER_ID"
, "H_MARKETING_SOURCE_CODE_ID"
, "INVOICED_AMT_F"
, "INVOICED_AMT_F1"
, "INVOICED_AMT_G"
, "INVOICED_QTY_INV"
, "INVOICE_TO_ORG_ID"
, "ITEM_TYPE_CODE"
, "LINE_CATEGORY_CODE"
, "LINE_ITEM_TYPE"
, "LINE_NUMBER"
, "MARKETING_SOURCE_CODE_ID"
, "OPEN_FLAG"
, "ORDERED_DATE"
, "ORDERED_QUANTITY"
, "ORDER_DATE_TYPE_CODE"
, "ORDER_NUMBER"
, "ORDER_QUANTITY_UOM"
, "INV_UOM_CODE"
, "PROMISE_DATE"
, "REQUEST_DATE"
, "SCHEDULE_SHIP_DATE"
, "SERVICE_PARENT_LINE_ID"
, "SHIPPABLE_FLAG"
, "SHIPPED_AMT_F"
, "SHIPPED_AMT_F1"
, "SHIPPED_AMT_G"
, "SHIPPED_QTY_INV"
, "SHIPPED_DATE"
, "TOP_MODEL_LINE_ID"
, "UNIT_LIST_PRICE"
, "UNIT_SELLING_PRICE"
, "CREATED_BY"
, "CREATION_DATE"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_DATE"
, "LAST_UPDATE_LOGIN"
, "SHIP_TO_PARTY_ID"
, "BOOKED_AMT_G1"
, "BOOKED_LIST_AMT_G1"
, "FULFILLED_AMT_G1"
, "INVOICED_AMT_G1"
, "SHIPPED_AMT_G1"
, "FREIGHT_CHARGE"
, "FREIGHT_CHARGE_F"
, "FREIGHT_CHARGE_G"
, "FREIGHT_CHARGE_G1"
, "FREIGHT_COST"
, "FREIGHT_COST_F"
, "FREIGHT_COST_G"
, "FREIGHT_COST_G1"
FROM ISC_BOOK_SUM2_F