VIEW: APPS.ISC_EDW_BOOKINGS_F_FCV

Source

View Text - Preformatted

SELECT BOOKINGS_PK, AGREEMENT_TYPE_FK, BILL_TO_CUST_FK, BILL_TO_LOC_FK, CAMPAIGN_ACTL_FK, CAMPAIGN_INIT_FK, CAMPAIGN_STATUS_ACTL_FK, CAMPAIGN_STATUS_INIT_FK, CANCEL_REASON_FK, CURRENCY_TRN_FK, CUSTOMER_FK, DATE_BOOKED_FK, DATE_PROMISED_FK, DATE_REQUESTED_FK, DATE_SCHEDULED_FK, DEMAND_CLASS_FK, EVENT_OFFER_ACTL_FK, EVENT_OFFER_INIT_FK, EVENT_OFFER_REG_FK, INSTANCE_FK, INV_ORG_FK, ITEM_ORG_FK, MARKET_SEGMENT_FK, MEDCHN_ACTL_FK, MEDCHN_INIT_FK, OFFER_HDR_FK, OFFER_LINE_FK, OPERATING_UNIT_FK, ORDER_CATEGORY_FK, ORDER_SOURCE_FK, ORDER_TYPE_FK, RETURN_REASON_FK, SALES_CHANNEL_FK, SALES_PERSON_FK, SET_OF_BOOKS_FK, SHIP_TO_CUST_FK, SHIP_TO_LOC_FK, SOURCE_LIST_FK, TARGET_SEGMENT_ACTL_FK, TARGET_SEGMENT_INIT_FK, TASK_FK, TOP_MODEL_FK, UOM_UOM_FK, QTY_CANCELLED, QTY_FULFILLED, QTY_INVOICED, QTY_ORDERED, QTY_RESERVED, QTY_RETURNED, QTY_SHIPPED, TOTAL_NET_ORDER_VALUE, UNIT_COST_G, UNIT_COST_T, UNIT_LIST_PRC_G, UNIT_LIST_PRC_T, UNIT_SELL_PRC_G, UNIT_SELL_PRC_T, AGREEMENT_ID, BOOKED_DATE, CONFIGURATION_ITEM_FLAG, CONVERSION_DATE, CONVERSION_RATE, CONVERSION_TYPE, CUST_PO_NUMBER, DATE_FULFILLED, DATE_LATEST_PICK, DATE_LATEST_SHIP, FULFILLMENT_FLAG, HEADER_ID, INCLUDED_ITEM_FLAG, INSTANCE, ITEM_TYPE_CODE, LAST_UPDATE_DATE, LINE_DETAIL_ID, LINE_ID, ORDERED_DATE, ORDER_NUMBER, PRICE_LIST_ID, PROMISED_DATE, REQUESTED_DATE, SCHEDULED_DATE, SEQ_ID, SHIPPABLE_FLAG, TRANSACTABLE_FLAG, VIEW_TYPE, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NA_EDW', 'NA_EDW', 'NA_EDW', 'NA_EDW', 'NA_EDW', to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL) from ISCBV_BOOKINGS_FCV

View Text - HTML Formatted

SELECT BOOKINGS_PK
, AGREEMENT_TYPE_FK
, BILL_TO_CUST_FK
, BILL_TO_LOC_FK
, CAMPAIGN_ACTL_FK
, CAMPAIGN_INIT_FK
, CAMPAIGN_STATUS_ACTL_FK
, CAMPAIGN_STATUS_INIT_FK
, CANCEL_REASON_FK
, CURRENCY_TRN_FK
, CUSTOMER_FK
, DATE_BOOKED_FK
, DATE_PROMISED_FK
, DATE_REQUESTED_FK
, DATE_SCHEDULED_FK
, DEMAND_CLASS_FK
, EVENT_OFFER_ACTL_FK
, EVENT_OFFER_INIT_FK
, EVENT_OFFER_REG_FK
, INSTANCE_FK
, INV_ORG_FK
, ITEM_ORG_FK
, MARKET_SEGMENT_FK
, MEDCHN_ACTL_FK
, MEDCHN_INIT_FK
, OFFER_HDR_FK
, OFFER_LINE_FK
, OPERATING_UNIT_FK
, ORDER_CATEGORY_FK
, ORDER_SOURCE_FK
, ORDER_TYPE_FK
, RETURN_REASON_FK
, SALES_CHANNEL_FK
, SALES_PERSON_FK
, SET_OF_BOOKS_FK
, SHIP_TO_CUST_FK
, SHIP_TO_LOC_FK
, SOURCE_LIST_FK
, TARGET_SEGMENT_ACTL_FK
, TARGET_SEGMENT_INIT_FK
, TASK_FK
, TOP_MODEL_FK
, UOM_UOM_FK
, QTY_CANCELLED
, QTY_FULFILLED
, QTY_INVOICED
, QTY_ORDERED
, QTY_RESERVED
, QTY_RETURNED
, QTY_SHIPPED
, TOTAL_NET_ORDER_VALUE
, UNIT_COST_G
, UNIT_COST_T
, UNIT_LIST_PRC_G
, UNIT_LIST_PRC_T
, UNIT_SELL_PRC_G
, UNIT_SELL_PRC_T
, AGREEMENT_ID
, BOOKED_DATE
, CONFIGURATION_ITEM_FLAG
, CONVERSION_DATE
, CONVERSION_RATE
, CONVERSION_TYPE
, CUST_PO_NUMBER
, DATE_FULFILLED
, DATE_LATEST_PICK
, DATE_LATEST_SHIP
, FULFILLMENT_FLAG
, HEADER_ID
, INCLUDED_ITEM_FLAG
, INSTANCE
, ITEM_TYPE_CODE
, LAST_UPDATE_DATE
, LINE_DETAIL_ID
, LINE_ID
, ORDERED_DATE
, ORDER_NUMBER
, PRICE_LIST_ID
, PROMISED_DATE
, REQUESTED_DATE
, SCHEDULED_DATE
, SEQ_ID
, SHIPPABLE_FLAG
, TRANSACTABLE_FLAG
, VIEW_TYPE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM ISCBV_BOOKINGS_FCV