• Home
• org.kuali.ole
• ole-master-sql
• 1.6.2
• source code
• PUR_SHP_TTL_T.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.oracle.PUR_SHP_TTL_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE PUR_SHP_TTL_T DROP STORAGE
/
INSERT INTO PUR_SHP_TTL_T (VNDR_SHP_TTL_CD,OBJ_ID,VER_NBR,VNDR_SHP_TTL_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('CI','BD3A73C7-BA3E-A68C-8C3D-B2BAE3304C7B',1.0,'CUSTOMS-INTERNATIONAL PORT','Y')
/
INSERT INTO PUR_SHP_TTL_T (VNDR_SHP_TTL_CD,OBJ_ID,VER_NBR,VNDR_SHP_TTL_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('CU','2DD981DD-F80F-F5B4-C92C-39483A7394EE',1.0,'CUSTOMS-U.S. PORT','Y')
/
INSERT INTO PUR_SHP_TTL_T (VNDR_SHP_TTL_CD,OBJ_ID,VER_NBR,VNDR_SHP_TTL_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('DE','28767BE3-1708-2708-B113-99914AE68BF8',1.0,'DESTINATION','Y')
/
INSERT INTO PUR_SHP_TTL_T (VNDR_SHP_TTL_CD,OBJ_ID,VER_NBR,VNDR_SHP_TTL_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('OR','FC3AFA33-7C57-1A98-F3B2-39E67F0C2E01',1.0,'ORIGIN (VENDOR LOCATION)','Y')
/
INSERT INTO PUR_SHP_TTL_T (VNDR_SHP_TTL_CD,OBJ_ID,VER_NBR,VNDR_SHP_TTL_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('SP','BD314A70-DCE1-61CA-7B3A-6D1A340A95DE',1.0,'SHIPPING POINT (DISTRIBUTOR)','Y')
/