APPS.EAM_ASSET_MOVE_PUB dependencies on MTL_PARAMETERS

Line 253: mtl_parameters mp

249: FROM mtl_serial_numbers msn ,
250: mtl_object_genealogy mog,
251: mtl_system_items_b msi ,
252: csi_item_instances cii ,
253: mtl_parameters mp
254: WHERE mog.object_id = msn.gen_object_id
255: AND msn.current_organization_id = msi.organization_id
256: --AND msn.current_organization_id = p_current_org_id
257: AND msi.inventory_item_id = msn.inventory_item_id

Line 326: MTL_PARAMETERS mp ,

322: NULL ,
323: NULL
324: INTO l_parent_inf_rec
325: FROM CSI_ITEM_INSTANCES cii,
326: MTL_PARAMETERS mp ,
327: MTL_SERIAL_NUMBERS msn,
328: MTL_SYSTEM_ITEMS_B msi
329: WHERE cii.instance_id =p_parent_instance_id
330: AND cii.SERIAL_NUMBER = msn.SERIAL_NUMBER

Line 664: from MTL_PARAMETERS

660:
661:
662: BEGIN
663: select MAINT_ORGANIZATION_ID into l_maint_organization_id
664: from MTL_PARAMETERS
665: where ORGANIZATION_ID = P_CURRENT_ORGANIZATION_ID;
666: --Added for the bug 7681240
667: select INTERMEDIATE_SUBINVENTORY into l_intermediate_subinventory
668: from wip_eam_parameters

Line 880: FROM MTL_PARAMETERS

876:
877: IF(validAssets_rec.prepare_status='MR') THEN --As the Asset is Recieved into Maintenance Org
878: --Making the Current Organisation as Maint Org
879: SELECT maint_organization_id INTO l_CURRENT_ORGANIZATION_ID
880: FROM MTL_PARAMETERS
881: WHERE organization_id= l_CURRENT_ORGANIZATION_ID;
882:
883: If(l_transfer_organization_id = l_CURRENT_ORGANIZATION_ID) then
884: l_transfer_organization_id := NULL;

Line 1133: x_neg_flag,x_org_ctrl FROM MTL_PARAMETERS

1129: -- retrive organization level control information
1130: Begin
1131: SELECT
1132: negative_inv_receipt_code,stock_locator_control_code into
1133: x_neg_flag,x_org_ctrl FROM MTL_PARAMETERS
1134: WHERE
1135: organization_id = p_org;
1136: Exception
1137: When no_data_found then

Line 1335: FROM MTL_PARAMETERS WHERE

1331: END;
1332:
1333:
1334: SELECT maint_organization_id INTO l_org_id
1335: FROM MTL_PARAMETERS WHERE
1336: organization_id= p_CURRENT_ORGANIZATION_ID;
1337:
1338: SELECT ACCT_PERIOD_ID
1339: INTO l_acc_per_id