FND Design Data [Home] [Help]

View: GMP_SR_SHIPMENT_DATA_V

Product: GMP - Process Manufacturing Process Planning
Description:
Implementation/DBA Data: ViewAPPS.GMP_SR_SHIPMENT_DATA_V
View Text

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

Columns

Name
SR_INV_ORG_PK
INV_ORG
SR_ITEM_PK
ITEM
SR_CUSTOMER_PK
CUSTOMER
SR_SALES_CHANNEL_PK
SALES_CHANNEL
SR_SALES_REP_PK
SALES_REP
SR_SHIP_TO_LOC_PK
SHIP_TO_LOC
BOOKED_DATE
REQUESTED_DATE
PROMISED_DATE
SCHEDULED_DATE
SHIPPED_DATE
AMOUNT
QTY_SHIPPED
SR_USER_DEFINED1_PK
USER_DEFINED1
SR_USER_DEFINED2_PK
USER_DEFINED2
SR_ORIGINAL_ITEM_PK
SR_PARENT_ITEM_PK