APPS.MRP_WB_BUCKET_DATES dependencies on MFG_LOOKUPS

Line 78: FROM mfg_lookups

74: DECLARE dummy NUMBER;
75: BEGIN
76: SELECT count(*)
77: INTO dummy
78: FROM mfg_lookups
79: WHERE lookup_type = 'MRP_WORKBENCH_BUCKET_TYPE'
80: AND lookup_code = arg_bucket_type;
81:
82: IF dummy = 0 THEN

Line 84: -- The bucket type is not in MFG_LOOKUPS

80: AND lookup_code = arg_bucket_type;
81:
82: IF dummy = 0 THEN
83: -- -------------------------------------
84: -- The bucket type is not in MFG_LOOKUPS
85: -- -------------------------------------
86: dbms_output.put_line('Creating new lookup');
87: INSERT INTO mfg_lookups
88: (lookup_type,

Line 87: INSERT INTO mfg_lookups

83: -- -------------------------------------
84: -- The bucket type is not in MFG_LOOKUPS
85: -- -------------------------------------
86: dbms_output.put_line('Creating new lookup');
87: INSERT INTO mfg_lookups
88: (lookup_type,
89: lookup_code,
90: last_update_date,
91: last_updated_by,