DBA Data[Home] [Help]

APPS.INVPVDR7 dependencies on MTL_PARAMETERS

Line 39: FROM mtl_parameters

35: NVL(wms_enabled_flag,'N'),
36: NVL(process_enabled_flag,'N'),
37: NVL(eam_enabled_flag,'N'),
38: NVL(trading_partner_org_flag,'N')
39: FROM mtl_parameters
40: where organization_id = cp_org_id;
41:
42: CURSOR c_subinv_loc_control(cp_org_id number,
43: cp_subinv_name varchar2) IS

Line 385: from mtl_parameters

381: END IF;
382: lot_num_generation_val := NULL;
383: select lot_number_generation
384: into lot_num_generation_val
385: from mtl_parameters
386: where organization_id = cr.organization_id
387: and rownum =1;
388:
389: if (cr.PARENT_CHILD_GENERATION_FLAG IS NOT NULL) then