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 989: FROM mtl_parameters

985: , process_enabled_flag
986: INTO x_eam_enabled
987: , x_wms_enabled
988: , x_process_enabled
989: FROM mtl_parameters
990: WHERE organization_id = p_organization_id;
991:
992: -- Cache the attributes and the status for the organization.
993: --

Line 3420: l_tp_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

3416: l_comp_qty NUMBER;
3417: l_msg_data VARCHAR2(2000);
3418: l_msg_count NUMBER;
3419: l_osa_item MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE;
3420: l_tp_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
3421: l_message VARCHAR(2000);
3422: l_status_flag BOOLEAN;
3423:
3424: CURSOR c_osa_rec IS

Line 3621: FROM mtl_parameters

3617: WHERE inventory_item_id = l_osa_tbl(i).osa_item_id
3618: AND organization_id = l_osa_tbl(i).tp_organization_id ;
3619:
3620: SELECT organization_code INTO l_tp_organization
3621: FROM mtl_parameters
3622: WHERE organization_id =l_osa_tbl(i).tp_organization_id ;
3623:
3624: fnd_message.set_name('JMF','JMF_SHK_WIP_JOB_ERROR');
3625: fnd_message.set_token('OSA', l_osa_item);