APPS.OPI_DBI_SCRAP_JOB_DTL_PKG dependencies on MTL_PARAMETERS

Line 22: l_flag mtl_parameters.process_enabled_flag%type ;

18: l_item_cat_where VARCHAR2(2000);
19: l_jobstatus_where VARCHAR2(1500);
20: l_lang_code VARCHAR2(20);
21: l_currency_code VARCHAR2(2);
22: l_flag mtl_parameters.process_enabled_flag%type ;
23: l_job_status VARCHAR2(1000);
24: l_respid VARCHAR(100);
25:
26: BEGIN

Line 178: FROM mtl_parameters mp

174: l_job_info_drill := 'OPI_DBI_JOB_INFO_DISC_REP&addBreadCrumb=Y&cloInd=1';
175:
176: SELECT process_enabled_flag
177: INTO l_flag
178: FROM mtl_parameters mp
179: WHERE mp.organization_id = trim(both '''' from l_org);
180:
181: IF(l_flag<>'Y') THEN
182: --{

Line 282: mtl_parameters mtp,

278: job.job_status_code,
279: scrap.organization_id,
280: scrap.inventory_item_id,
281: job.uom_code))) fact,
282: mtl_parameters mtp,
283: opi_mfg_wo_status_lvl_v jobstatus,
284: eni_item_org_v itemorg,
285: mtl_units_of_measure_vl uom
286: WHERE jobstatus.id = CASE WHEN fact.job_type=3 THEN DECODE (fact.job_status_code,2,12,1,3)