DBA Data[Home] [Help]

APPS.DDR_SETUP_UTIL dependencies on DDR_R_ORG

Line 29: FROM DDR_R_ORG

25: v_org_exists NUMBER:=0;
26: BEGIN
27: SELECT COUNT(*)
28: INTO v_org_exists
29: FROM DDR_R_ORG
30: WHERE mfg_org_cd = p_mfg_org
31: AND org_cd = p_mfg_org;
32:
33: IF v_org_exists = 0 THEN

Line 34: INSERT INTO ddr_r_org

30: WHERE mfg_org_cd = p_mfg_org
31: AND org_cd = p_mfg_org;
32:
33: IF v_org_exists = 0 THEN
34: INSERT INTO ddr_r_org
35: (mfg_org_cd, org_cd, org_typ, glbl_loc_id, glbl_loc_id_typ,
36: created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
37: VALUES
38: (p_mfg_org, p_mfg_org, 'MFG', -1, -1,