DBA Data[Home] [Help]

APPS.INVIDIT1 dependencies on MTL_PARAMETERS

Line 110: from mtl_parameters a, mtl_parameters b

106: BEGIN
107: select a.master_organization_id, b.organization_code
108: , DECODE(X_mode,'DEFINE',NVL(b.encumbrance_reversal_flag,2),NVL(a.encumbrance_reversal_flag,2)) --* Added for Bug #3818342
109: into master_org, X_master_org_code, X_encumbrance_reversal_flag
110: from mtl_parameters a, mtl_parameters b
111: where a.organization_id = X_org_id
112: and a.master_organization_id = b.organization_id;
113:
114: X_master_org_id := master_org;

Line 329: from mtl_parameters mp, hr_organization_units hr

325: X_org_encumbrance_account,
326: X_org_sales_account,
327: X_org_expense_account,
328: X_master_org_name
329: from mtl_parameters mp, hr_organization_units hr
330: where mp.organization_id = master_org
331: and mp.organization_id = hr.organization_id;
332:
333: -- Get this info for the current org

Line 347: from mtl_parameters mp

343: X_cost_method,
344: X_lot_generation,
345: X_serial_generation,
346: X_tp_org
347: from mtl_parameters mp
348: where mp.organization_id = X_org_id;
349:
350: EXCEPTION
351: when NO_DATA_FOUND then

Line 824: ,mtl_parameters mp

820: begin
821: select mp.organization_code,hou.name
822: into X_source_organization, X_source_org_name
823: from hr_organization_units hou
824: ,mtl_parameters mp
825: where hou.organization_id = mp.organization_id
826: and mp.organization_id = X_source_organization_id;
827: exception
828: when NO_DATA_FOUND then