DBA Data[Home] [Help]

APPS.OPI_DBI_PTP_JOB_DTL_PKG dependencies on MTL_PARAMETERS

Line 15: l_flag mtl_parameters.process_enabled_flag%type;

11: l_item_org VARCHAR2(255);
12: l_item_cat VARCHAR2(255);
13: l_currency VARCHAR2(255);
14: l_currency_code VARCHAR2(2);
15: l_flag mtl_parameters.process_enabled_flag%type;
16: l_flag_where VARCHAR2(255);
17: l_lang_code VARCHAR2(20);
18: l_item_org_where VARCHAR2(2000);
19: l_jobstatus_where VARCHAR2(1500);

Line 137: FROM mtl_parameters mp

133:
134:
135: SELECT process_enabled_flag
136: INTO l_flag
137: FROM mtl_parameters mp
138: WHERE mp.organization_id = trim(both '''' from l_org);
139:
140:
141: IF (UPPER(l_item_org) <> 'ALL') THEN

Line 241: mtl_parameters mtp,

237: job.organization_id,
238: job.job_status_code,
239: job.uom_code,
240: job.assembly_item_id)) f,
241: mtl_parameters mtp,
242: opi_mfg_wo_status_lvl_v jobstatus,
243: eni_item_org_v itemorg,
244: mtl_units_of_measure_vl uom
245: WHERE