DBA Data[Home] [Help]

APPS.OPI_DBI_OPEN_JOB_DTL_PKG dependencies on MTL_PARAMETERS

Line 22: l_flag mtl_parameters.process_enabled_flag%type;

18: l_lang_code VARCHAR2(20);
19: l_currency_code VARCHAR2(2);
20: l_respid NUMBER;
21: l_job_info_drill VARCHAR2(255);
22: l_flag mtl_parameters.process_enabled_flag%type;
23: l_org_where VARCHAR2(2000);
24:
25:
26: BEGIN

Line 134: from mtl_parameters mp

130: ELSE
131: --{
132: select process_enabled_flag
133: into l_flag
134: from mtl_parameters mp
135: where mp.organization_id = trim(both '''' from l_org);
136: --}
137: END IF;
138:

Line 272: ,mtl_parameters mtp

268: fact.actual_value_sg
269: )))f
270: ,eni_item_org_v itemorg
271: ,mtl_units_of_measure_vl v2
272: ,mtl_parameters mtp
273: ,OPI_MFG_WO_STATUS_LVL_V job_status
274: where
275: mtp.organization_id = f.org_id
276: and itemorg.id = f.assembly_item_id||''-''|| f.org_id