DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_PARAMETERS

Line 2352: mtl_parameters mp

2348: INTO l_prim_uom_code,
2349: l_item_id,
2350: l_to_organization_id
2351: FROM mtl_system_items_kfv msik,
2352: mtl_parameters mp
2353: WHERE mp.organization_id = l_rti_rec.to_organization_id
2354: AND msik.inventory_item_id = l_rti_rec.item_id
2355: AND mp.organization_id = msik.organization_id;
2356:

Line 2365: mtl_parameters mp

2361: INTO l_prim_uom_code,
2362: l_item_id,
2363: l_to_organization_id
2364: FROM mtl_system_items_kfv msik,
2365: mtl_parameters mp
2366: WHERE mp.organization_id = l_rti_rec.to_organization_id
2367: AND msik.concatenated_segments = l_rti_rec.item_num
2368: AND mp.organization_id = msik.organization_id;
2369: END IF; --IF (L_RTI_REC.ITEM_ID IS NOT NULL) THEN

Line 2381: mtl_parameters mp

2377: INTO l_prim_uom_code,
2378: l_item_id,
2379: l_to_organization_id
2380: FROM mtl_system_items_kfv msik,
2381: mtl_parameters mp
2382: WHERE mp.organization_code = l_rti_rec.to_organization_code
2383: AND msik.inventory_item_id = l_rti_rec.item_id
2384: AND mp.organization_id = msik.organization_id;
2385:

Line 2394: mtl_parameters mp

2390: INTO l_prim_uom_code,
2391: l_item_id,
2392: l_to_organization_id
2393: FROM mtl_system_items_kfv msik,
2394: mtl_parameters mp
2395: WHERE mp.organization_code = l_rti_rec.to_organization_code
2396: AND msik.concatenated_segments = l_rti_rec.item_num
2397: AND mp.organization_id = msik.organization_id;
2398:

Line 7641: FROM mtl_parameters

7637: BEGIN
7638:
7639: SELECT NVL(wms_enabled_flag,'N')
7640: INTO l_wms_enabled
7641: FROM mtl_parameters
7642: WHERE organization_id = p_org_id ;
7643:
7644: IF l_wms_enabled <> 'N' THEN
7645: success := true;