• Home
• org.kuali.ole
• ole-master-sql
• 1.5.8
• source code
• PUR_CONTR_MGR_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_CONTR_MGR_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE PUR_CONTR_MGR_T DROP STORAGE
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (10.0,'DC110C03-D20F-A572-E1E6-0037D4AD2D58',2.0,'WILLIE PARKE','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (12.0,'734B0177-D71A-AB7C-FAAA-91A929B7BA4C',2.0,'PATTI POTTER','777-777-7777','999-999-9999',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (14.0,'9CFA5F3C-0680-5D60-8997-064854C9CB62',3.0,'MCGEHEE,DARREL L','111-111-1111','222-222-2222',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (16.0,'D60C4B63-A174-440E-E291-00FF08842C45',3.0,'GINSBERG,DOYLE N','888-888-8888','333-333-3333',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (20.0,'4B796E80FD3B2827E0404F8189D82B5E',1.0,'KOONTZ,ANDREW H','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (21.0,'4B796E80FD3C2827E0404F8189D82B5E',1.0,'BURTON,AARON I','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (22.0,'4B796E80FD3D2827E0404F8189D82B5E',1.0,'YOUNG,ADAM J','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (23.0,'4B796E80FD3E2827E0404F8189D82B5E',1.0,'VOGEL,ANN K','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (24.0,'4B796E80FD3F2827E0404F8189D82B5E',1.0,'GETZ,ADRIANA L','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (25.0,'25',1.0,'KEISHA HUNTLEY Y','555-555-5555','444-444-4444',100000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (30.0,'4B796E80FD402827E0404F8189D82B5E',1.0,'DONNELLY,CHRIS K','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (31.0,'4B796E80FD412827E0404F8189D82B5E',1.0,'PETERSON,CECILIA L','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (32.0,'4B796E80FD422827E0404F8189D82B5E',1.0,'GREATHOUSE,CATHERINE M','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (33.0,'4B796E80FD432827E0404F8189D82B5E',1.0,'NOBLE,CARSON N','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (34.0,'4B796E80FD442827E0404F8189D82B5E',1.0,'MORRISON,CLIFFORD O','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (40.0,'4B796E80FD452827E0404F8189D82B5E',1.0,'MARIN,DAVID V','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (41.0,'4B796E80FD462827E0404F8189D82B5E',1.0,'FORSYTHE,DAMON W','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (42.0,'4B796E80FD472827E0404F8189D82B5E',1.0,'BERRY,DERRICK Y','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (43.0,'4B796E80FD482827E0404F8189D82B5E',1.0,'SHIPMAN,DELILAH A','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (44.0,'4B796E80FD492827E0404F8189D82B5E',1.0,'SEARS,DENISE B','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (50.0,'4B796E80FD4A2827E0404F8189D82B5E',1.0,'NELSON,HARRY O','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (51.0,'4B796E80FD4B2827E0404F8189D82B5E',1.0,'GONZALES,HECTOR R','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (52.0,'4B796E80FD4C2827E0404F8189D82B5E',1.0,'MOSS,HAROLD P','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (53.0,'4B796E80FD4D2827E0404F8189D82B5E',1.0,'WILLIAMS,HARRIET S','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (54.0,'4B796E80FD4E2827E0404F8189D82B5E',1.0,'BENDER,HANNIBAL T','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (60.0,'4B796E80FD4F2827E0404F8189D82B5E',1.0,'HENLEY,ISAAC A','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (61.0,'4B796E80FD502827E0404F8189D82B5E',1.0,'ANDERSON,IRENE B','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (62.0,'4B796E80FD512827E0404F8189D82B5E',1.0,'MATTHEWS,IMELDA C','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (63.0,'4B796E80FD522827E0404F8189D82B5E',1.0,'CAIN,IVERSON D','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (64.0,'4B796E80FD532827E0404F8189D82B5E',1.0,'KLEIN,IRVING E','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (70.0,'4B796E80FD542827E0404F8189D82B5E',1.0,'BAXTER,MICHAEL S','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (71.0,'4B796E80FD552827E0404F8189D82B5E',1.0,'GRAY,MARK T','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (72.0,'4B796E80FD562827E0404F8189D82B5E',1.0,'HANDLEY,MATTHEW U','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (73.0,'4B796E80FD572827E0404F8189D82B5E',1.0,'LEE,MARISSA V','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (74.0,'4B796E80FD582827E0404F8189D82B5E',1.0,'LAWYER,MELISSA W','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (80.0,'4B796E80FD592827E0404F8189D82B5E',1.0,'RYAN,ULYSSES E','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (81.0,'4B796E80FD5A2827E0404F8189D82B5E',1.0,'SAMPSON,URSULA F','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (82.0,'4B796E80FD5B2827E0404F8189D82B5E',1.0,'ALLEN,UTAH G','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (83.0,'4B796E80FD5C2827E0404F8189D82B5E',1.0,'VOSS,USHER H','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (84.0,'4B796E80FD5D2827E0404F8189D82B5E',1.0,'TROYER,ULRICH I','555-555-5555','444-444-4444',15000.0,'Y')
/
INSERT INTO PUR_CONTR_MGR_T (CONTR_MGR_CD,OBJ_ID,VER_NBR,CONTR_MGR_NM,CONTR_MGR_PHN_NBR,CONTR_MGR_FAX_NBR,CONTR_MGR_DLGN_DLR_LMT,ACTV_IND)
  VALUES (99.0,'2E5054C403C230CEE043814FD88130CE',1.0,'AUTOMATIC PURCHASE ORDER','7777777777','5554448888',100000.0,'Y')
/