APPS.EAM_ASSET_MOVE_PUB dependencies on MTL_PARAMETERS

Line 245: mtl_parameters mp

241: FROM mtl_serial_numbers msn ,
242: mtl_object_genealogy mog,
243: mtl_system_items_b msi ,
244: csi_item_instances cii ,
245: mtl_parameters mp
246: WHERE mog.object_id = msn.gen_object_id
247: AND msn.current_organization_id = msi.organization_id
248: --AND msn.current_organization_id = p_current_org_id
249: AND msi.inventory_item_id = msn.inventory_item_id

Line 313: MTL_PARAMETERS mp ,

309: NULL ,
310: NULL
311: INTO l_parent_inf_rec
312: FROM CSI_ITEM_INSTANCES cii,
313: MTL_PARAMETERS mp ,
314: MTL_SERIAL_NUMBERS msn,
315: MTL_SYSTEM_ITEMS_B msi
316: WHERE cii.instance_id =p_parent_instance_id
317: AND cii.SERIAL_NUMBER = msn.SERIAL_NUMBER

Line 650: from MTL_PARAMETERS

646:
647:
648: BEGIN
649: select MAINT_ORGANIZATION_ID into l_maint_organization_id
650: from MTL_PARAMETERS
651: where ORGANIZATION_ID = P_CURRENT_ORGANIZATION_ID;
652: --Added for the bug 7681240
653: select INTERMEDIATE_SUBINVENTORY into l_intermediate_subinventory
654: from wip_eam_parameters

Line 862: FROM MTL_PARAMETERS

858:
859: IF(validAssets_rec.prepare_status='MR') THEN --As the Asset is Recieved into Maintenance Org
860: --Making the Current Organisation as Maint Org
861: SELECT maint_organization_id INTO l_CURRENT_ORGANIZATION_ID
862: FROM MTL_PARAMETERS
863: WHERE organization_id= l_CURRENT_ORGANIZATION_ID;
864:
865: If(l_transfer_organization_id = l_CURRENT_ORGANIZATION_ID) then
866: l_transfer_organization_id := NULL;

Line 1049: x_neg_flag,x_org_ctrl FROM MTL_PARAMETERS

1045: -- retrive organization level control information
1046: Begin
1047: SELECT
1048: negative_inv_receipt_code,stock_locator_control_code into
1049: x_neg_flag,x_org_ctrl FROM MTL_PARAMETERS
1050: WHERE
1051: organization_id = p_org;
1052: Exception
1053: When no_data_found then

Line 1195: FROM MTL_PARAMETERS WHERE

1191: l_uom := 'Ea';
1192: l_sysdate := SYSDATE-1;
1193:
1194: SELECT maint_organization_id INTO l_org_id
1195: FROM MTL_PARAMETERS WHERE
1196: organization_id= p_CURRENT_ORGANIZATION_ID;
1197:
1198: SELECT ACCT_PERIOD_ID
1199: INTO l_acc_per_id