eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.DDR_SETUP_UTIL dependencies on DDR_R_LKUP_TYP

Line 463: DELETE ddr_r_lkup_typ;

459: END setup_ws_metadata;
460:
461: PROCEDURE setup_lookup_type IS
462: BEGIN
463: DELETE ddr_r_lkup_typ;
464: INSERT INTO ddr_r_lkup_typ
465: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
466: VALUES ('ADDR_TYP','Address Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
467: INSERT INTO ddr_r_lkup_typ

Line 464: INSERT INTO ddr_r_lkup_typ

460:
461: PROCEDURE setup_lookup_type IS
462: BEGIN
463: DELETE ddr_r_lkup_typ;
464: INSERT INTO ddr_r_lkup_typ
465: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
466: VALUES ('ADDR_TYP','Address Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
467: INSERT INTO ddr_r_lkup_typ
468: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 467: INSERT INTO ddr_r_lkup_typ

463: DELETE ddr_r_lkup_typ;
464: INSERT INTO ddr_r_lkup_typ
465: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
466: VALUES ('ADDR_TYP','Address Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
467: INSERT INTO ddr_r_lkup_typ
468: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
469: VALUES ('BRND','Item Brand',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
470: INSERT INTO ddr_r_lkup_typ
471: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 470: INSERT INTO ddr_r_lkup_typ

466: VALUES ('ADDR_TYP','Address Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
467: INSERT INTO ddr_r_lkup_typ
468: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
469: VALUES ('BRND','Item Brand',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
470: INSERT INTO ddr_r_lkup_typ
471: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
472: VALUES ('BSNS_UNIT_TYP','Business Unit Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
473: INSERT INTO ddr_r_lkup_typ
474: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 473: INSERT INTO ddr_r_lkup_typ

469: VALUES ('BRND','Item Brand',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
470: INSERT INTO ddr_r_lkup_typ
471: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
472: VALUES ('BSNS_UNIT_TYP','Business Unit Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
473: INSERT INTO ddr_r_lkup_typ
474: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
475: VALUES ('CHNL_TYP','Channel Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
476: INSERT INTO ddr_r_lkup_typ
477: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 476: INSERT INTO ddr_r_lkup_typ

472: VALUES ('BSNS_UNIT_TYP','Business Unit Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
473: INSERT INTO ddr_r_lkup_typ
474: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
475: VALUES ('CHNL_TYP','Channel Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
476: INSERT INTO ddr_r_lkup_typ
477: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
478: VALUES ('COATING','Coating Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
479: INSERT INTO ddr_r_lkup_typ
480: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 479: INSERT INTO ddr_r_lkup_typ

475: VALUES ('CHNL_TYP','Channel Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
476: INSERT INTO ddr_r_lkup_typ
477: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
478: VALUES ('COATING','Coating Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
479: INSERT INTO ddr_r_lkup_typ
480: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
481: VALUES ('COLOR','Color',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
482: INSERT INTO ddr_r_lkup_typ
483: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 482: INSERT INTO ddr_r_lkup_typ

478: VALUES ('COATING','Coating Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
479: INSERT INTO ddr_r_lkup_typ
480: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
481: VALUES ('COLOR','Color',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
482: INSERT INTO ddr_r_lkup_typ
483: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
484: VALUES ('DYE','Dye',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
485: INSERT INTO ddr_r_lkup_typ
486: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 485: INSERT INTO ddr_r_lkup_typ

481: VALUES ('COLOR','Color',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
482: INSERT INTO ddr_r_lkup_typ
483: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
484: VALUES ('DYE','Dye',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
485: INSERT INTO ddr_r_lkup_typ
486: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
487: VALUES ('ERR','Error',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
488: INSERT INTO ddr_r_lkup_typ
489: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 488: INSERT INTO ddr_r_lkup_typ

484: VALUES ('DYE','Dye',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
485: INSERT INTO ddr_r_lkup_typ
486: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
487: VALUES ('ERR','Error',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
488: INSERT INTO ddr_r_lkup_typ
489: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
490: VALUES ('FABRIC','Fabric',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
491: INSERT INTO ddr_r_lkup_typ
492: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 491: INSERT INTO ddr_r_lkup_typ

487: VALUES ('ERR','Error',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
488: INSERT INTO ddr_r_lkup_typ
489: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
490: VALUES ('FABRIC','Fabric',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
491: INSERT INTO ddr_r_lkup_typ
492: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
493: VALUES ('FIBER','Fiber',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
494: INSERT INTO ddr_r_lkup_typ
495: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 494: INSERT INTO ddr_r_lkup_typ

490: VALUES ('FABRIC','Fabric',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
491: INSERT INTO ddr_r_lkup_typ
492: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
493: VALUES ('FIBER','Fiber',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
494: INSERT INTO ddr_r_lkup_typ
495: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
496: VALUES ('GIID_TYP','GIID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
497: INSERT INTO ddr_r_lkup_typ
498: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 497: INSERT INTO ddr_r_lkup_typ

493: VALUES ('FIBER','Fiber',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
494: INSERT INTO ddr_r_lkup_typ
495: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
496: VALUES ('GIID_TYP','GIID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
497: INSERT INTO ddr_r_lkup_typ
498: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
499: VALUES ('GLID_TYP','GLID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
500: INSERT INTO ddr_r_lkup_typ
501: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 500: INSERT INTO ddr_r_lkup_typ

496: VALUES ('GIID_TYP','GIID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
497: INSERT INTO ddr_r_lkup_typ
498: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
499: VALUES ('GLID_TYP','GLID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
500: INSERT INTO ddr_r_lkup_typ
501: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
502: VALUES ('MEASURE','Measure Name',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
503: INSERT INTO ddr_r_lkup_typ
504: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 503: INSERT INTO ddr_r_lkup_typ

499: VALUES ('GLID_TYP','GLID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
500: INSERT INTO ddr_r_lkup_typ
501: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
502: VALUES ('MEASURE','Measure Name',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
503: INSERT INTO ddr_r_lkup_typ
504: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
505: VALUES ('MEASURE_TYP','Measure Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
506: INSERT INTO ddr_r_lkup_typ
507: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 506: INSERT INTO ddr_r_lkup_typ

502: VALUES ('MEASURE','Measure Name',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
503: INSERT INTO ddr_r_lkup_typ
504: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
505: VALUES ('MEASURE_TYP','Measure Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
506: INSERT INTO ddr_r_lkup_typ
507: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
508: VALUES ('MFG_ITEM_LVL','Mfg Item Level Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
509: INSERT INTO ddr_r_lkup_typ
510: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 509: INSERT INTO ddr_r_lkup_typ

505: VALUES ('MEASURE_TYP','Measure Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
506: INSERT INTO ddr_r_lkup_typ
507: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
508: VALUES ('MFG_ITEM_LVL','Mfg Item Level Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
509: INSERT INTO ddr_r_lkup_typ
510: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
511: VALUES ('ORG_LVL','Organization Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
512: INSERT INTO ddr_r_lkup_typ
513: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 512: INSERT INTO ddr_r_lkup_typ

508: VALUES ('MFG_ITEM_LVL','Mfg Item Level Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
509: INSERT INTO ddr_r_lkup_typ
510: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
511: VALUES ('ORG_LVL','Organization Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
512: INSERT INTO ddr_r_lkup_typ
513: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
514: VALUES ('ORG_TYP','Organization Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
515: INSERT INTO ddr_r_lkup_typ
516: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 515: INSERT INTO ddr_r_lkup_typ

511: VALUES ('ORG_LVL','Organization Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
512: INSERT INTO ddr_r_lkup_typ
513: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
514: VALUES ('ORG_TYP','Organization Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
515: INSERT INTO ddr_r_lkup_typ
516: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
517: VALUES ('RPLNSHMNT_TYP','Replenishment Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
518: INSERT INTO ddr_r_lkup_typ
519: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 518: INSERT INTO ddr_r_lkup_typ

514: VALUES ('ORG_TYP','Organization Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
515: INSERT INTO ddr_r_lkup_typ
516: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
517: VALUES ('RPLNSHMNT_TYP','Replenishment Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
518: INSERT INTO ddr_r_lkup_typ
519: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
520: VALUES ('RTL_ITEM_LVL','Retailer Item Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
521: INSERT INTO ddr_r_lkup_typ
522: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 521: INSERT INTO ddr_r_lkup_typ

517: VALUES ('RPLNSHMNT_TYP','Replenishment Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
518: INSERT INTO ddr_r_lkup_typ
519: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
520: VALUES ('RTL_ITEM_LVL','Retailer Item Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
521: INSERT INTO ddr_r_lkup_typ
522: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
523: VALUES ('RTL_TYP','Retail Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
524: INSERT INTO ddr_r_lkup_typ
525: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 524: INSERT INTO ddr_r_lkup_typ

520: VALUES ('RTL_ITEM_LVL','Retailer Item Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
521: INSERT INTO ddr_r_lkup_typ
522: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
523: VALUES ('RTL_TYP','Retail Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
524: INSERT INTO ddr_r_lkup_typ
525: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
526: VALUES ('SKU_ITEM_STYLE','SKU Item Style',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
527: INSERT INTO ddr_r_lkup_typ
528: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 527: INSERT INTO ddr_r_lkup_typ

523: VALUES ('RTL_TYP','Retail Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
524: INSERT INTO ddr_r_lkup_typ
525: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
526: VALUES ('SKU_ITEM_STYLE','SKU Item Style',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
527: INSERT INTO ddr_r_lkup_typ
528: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
529: VALUES ('SKU_ITEM_TYP','SKU Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
530: INSERT INTO ddr_r_lkup_typ
531: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 530: INSERT INTO ddr_r_lkup_typ

526: VALUES ('SKU_ITEM_STYLE','SKU Item Style',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
527: INSERT INTO ddr_r_lkup_typ
528: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
529: VALUES ('SKU_ITEM_TYP','SKU Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
530: INSERT INTO ddr_r_lkup_typ
531: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
532: VALUES ('SLNG_LOC_TYP','Selling Location Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
533: INSERT INTO ddr_r_lkup_typ
534: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 533: INSERT INTO ddr_r_lkup_typ

529: VALUES ('SKU_ITEM_TYP','SKU Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
530: INSERT INTO ddr_r_lkup_typ
531: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
532: VALUES ('SLNG_LOC_TYP','Selling Location Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
533: INSERT INTO ddr_r_lkup_typ
534: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
535: VALUES ('STCK_ITEM_TYP','Stock Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
536: INSERT INTO ddr_r_lkup_typ
537: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 536: INSERT INTO ddr_r_lkup_typ

532: VALUES ('SLNG_LOC_TYP','Selling Location Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
533: INSERT INTO ddr_r_lkup_typ
534: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
535: VALUES ('STCK_ITEM_TYP','Stock Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
536: INSERT INTO ddr_r_lkup_typ
537: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
538: VALUES ('SYS_PARAM','System Parameter',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
539: INSERT INTO ddr_r_lkup_typ
540: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 539: INSERT INTO ddr_r_lkup_typ

535: VALUES ('STCK_ITEM_TYP','Stock Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
536: INSERT INTO ddr_r_lkup_typ
537: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
538: VALUES ('SYS_PARAM','System Parameter',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
539: INSERT INTO ddr_r_lkup_typ
540: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
541: VALUES ('SZ_TYP','Size Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
542: INSERT INTO ddr_r_lkup_typ
543: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 542: INSERT INTO ddr_r_lkup_typ

538: VALUES ('SYS_PARAM','System Parameter',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
539: INSERT INTO ddr_r_lkup_typ
540: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
541: VALUES ('SZ_TYP','Size Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
542: INSERT INTO ddr_r_lkup_typ
543: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
544: VALUES ('TIME_LVL','Time Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
545: INSERT INTO ddr_r_lkup_typ
546: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 545: INSERT INTO ddr_r_lkup_typ

541: VALUES ('SZ_TYP','Size Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
542: INSERT INTO ddr_r_lkup_typ
543: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
544: VALUES ('TIME_LVL','Time Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
545: INSERT INTO ddr_r_lkup_typ
546: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
547: VALUES ('VRTY_TYP','Variety Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
548: INSERT INTO ddr_r_lkup_typ
549: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 548: INSERT INTO ddr_r_lkup_typ

544: VALUES ('TIME_LVL','Time Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
545: INSERT INTO ddr_r_lkup_typ
546: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
547: VALUES ('VRTY_TYP','Variety Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
548: INSERT INTO ddr_r_lkup_typ
549: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
550: VALUES ('WEAVE','Weave Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
551: INSERT INTO ddr_r_lkup_typ
552: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 551: INSERT INTO ddr_r_lkup_typ

547: VALUES ('VRTY_TYP','Variety Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
548: INSERT INTO ddr_r_lkup_typ
549: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
550: VALUES ('WEAVE','Weave Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
551: INSERT INTO ddr_r_lkup_typ
552: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
553: VALUES ('PRMTN_FLAG','Promotion Flag',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
554: INSERT INTO ddr_r_lkup_typ
555: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 554: INSERT INTO ddr_r_lkup_typ

550: VALUES ('WEAVE','Weave Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
551: INSERT INTO ddr_r_lkup_typ
552: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
553: VALUES ('PRMTN_FLAG','Promotion Flag',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
554: INSERT INTO ddr_r_lkup_typ
555: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
556: VALUES ('MKT_AREA_TYP','Market Area Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
557: INSERT INTO ddr_r_lkup_typ
558: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 557: INSERT INTO ddr_r_lkup_typ

553: VALUES ('PRMTN_FLAG','Promotion Flag',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
554: INSERT INTO ddr_r_lkup_typ
555: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
556: VALUES ('MKT_AREA_TYP','Market Area Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
557: INSERT INTO ddr_r_lkup_typ
558: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
559: VALUES ('ITM_TYP','Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
560: END setup_lookup_type;
561: END ddr_setup_util;