VIEW: APPS.GMP_SR_SHIPMENT_DATA_V

Source

View Text - Preformatted

SELECT to_number(NULL) SR_INV_ORG_PK, NULL INV_ORG, to_number(NULL) SR_ITEM_PK, NULL ITEM, to_number(NULL) SR_CUSTOMER_PK, NULL CUSTOMER, NULL SR_SALES_CHANNEL_PK, NULL SALES_CHANNEL, to_number(NULL) SR_SALES_REP_PK, NULL SALES_REP, to_number(NULL) SR_SHIP_TO_LOC_PK, NULL SHIP_TO_LOC, to_date(NULL) BOOKED_DATE, to_date(NULL) REQUESTED_DATE, to_date(NULL) PROMISED_DATE, to_date(NULL) SCHEDULED_DATE, to_date(NULL) SHIPPED_DATE, to_number(NULL) AMOUNT, to_number(NULL) QTY_SHIPPED, to_number(NULL) SR_USER_DEFINED1_PK, NULL USER_DEFINED1, to_number(NULL) SR_USER_DEFINED2_PK, NULL USER_DEFINED2, to_number(NULL) SR_ORIGINAL_ITEM_PK, NULL SR_PARENT_ITEM_PK FROM SYS.DUAL WHERE 1 <> 1

View Text - HTML Formatted

SELECT TO_NUMBER(NULL) SR_INV_ORG_PK
, NULL INV_ORG
, TO_NUMBER(NULL) SR_ITEM_PK
, NULL ITEM
, TO_NUMBER(NULL) SR_CUSTOMER_PK
, NULL CUSTOMER
, NULL SR_SALES_CHANNEL_PK
, NULL SALES_CHANNEL
, TO_NUMBER(NULL) SR_SALES_REP_PK
, NULL SALES_REP
, TO_NUMBER(NULL) SR_SHIP_TO_LOC_PK
, NULL SHIP_TO_LOC
, TO_DATE(NULL) BOOKED_DATE
, TO_DATE(NULL) REQUESTED_DATE
, TO_DATE(NULL) PROMISED_DATE
, TO_DATE(NULL) SCHEDULED_DATE
, TO_DATE(NULL) SHIPPED_DATE
, TO_NUMBER(NULL) AMOUNT
, TO_NUMBER(NULL) QTY_SHIPPED
, TO_NUMBER(NULL) SR_USER_DEFINED1_PK
, NULL USER_DEFINED1
, TO_NUMBER(NULL) SR_USER_DEFINED2_PK
, NULL USER_DEFINED2
, TO_NUMBER(NULL) SR_ORIGINAL_ITEM_PK
, NULL SR_PARENT_ITEM_PK
FROM SYS.DUAL
WHERE 1 <> 1