APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on MTL_PARAMETERS

Line 325: , mtl_parameters mp

321: , p_vendor_site_id vendor_site_id
322: , 'Y' status
323: FROM HR_ORGANIZATION_INFORMATION hoi
324: , mtl_interorg_parameters mip
325: , mtl_parameters mp
326: WHERE mip.to_organization_id = mp.organization_id
327: AND mp.organization_id = hoi.organization_id
328: AND mp.trading_partner_org_flag = 'Y'
329: AND mip.from_organization_id = p_organization_id

Line 949: FROM mtl_parameters

945: , process_enabled_flag
946: INTO x_eam_enabled
947: , x_wms_enabled
948: , x_process_enabled
949: FROM mtl_parameters
950: WHERE organization_id = p_organization_id;
951:
952: -- Cache the attributes and the status for the organization.
953:

Line 3143: l_tp_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

3139: l_comp_qty NUMBER;
3140: l_msg_data VARCHAR2(2000);
3141: l_msg_count NUMBER;
3142: l_osa_item MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE;
3143: l_tp_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
3144: l_message VARCHAR(2000);
3145: l_status_flag BOOLEAN;
3146:
3147: CURSOR c_osa_rec IS

Line 3322: FROM mtl_parameters

3318: WHERE inventory_item_id = l_osa_tbl(i).osa_item_id
3319: AND organization_id = l_osa_tbl(i).tp_organization_id ;
3320:
3321: SELECT organization_code INTO l_tp_organization
3322: FROM mtl_parameters
3323: WHERE organization_id =l_osa_tbl(i).tp_organization_id ;
3324:
3325: fnd_message.set_name('JMF','JMF_SHK_WIP_JOB_ERROR');
3326: fnd_message.set_token('OSA', l_osa_item);