DBA Data[Home] [Help]

APPS.WSH_CONTAINER_UTILITIES dependencies on MTL_SYSTEM_ITEMS

Line 277: FROM mtl_system_items

273: AND preferred_flag = DECODE(nvl(v_cont_id,-99),-99,'Y',preferred_flag);
274:
275: CURSOR get_flag_value (v_inv_item_id NUMBER, v_org_id NUMBER) IS
276: SELECT indivisible_flag
277: FROM mtl_system_items
278: WHERE organization_id = v_org_id
279: AND inventory_item_id = v_inv_item_id;
280:
281: CURSOR Get_Delivery_Details (v_del_detail_id NUMBER) IS

Line 306: FROM MTL_SYSTEM_ITEMS

302: AND container_flag in ('Y', 'C');
303:
304: CURSOR Get_Cont_Msi (v_cont_item_id NUMBER, v_org_id NUMBER) IS
305: SELECT maximum_load_weight, internal_volume, weight_uom_code, volume_uom_code
306: FROM MTL_SYSTEM_ITEMS
307: WHERE inventory_item_id = v_cont_item_id
308: AND organization_id = v_org_id;
309:
310: CURSOR Get_Fill_Basis (v_org_id NUMBER) IS

Line 577: -- dbms_output.put_line('no cont_item in mtl_system_items');

573: l_mtl_wt_uom,
574: l_mtl_vol_uom;
575:
576: IF Get_Cont_Msi%NOTFOUND THEN
577: -- dbms_output.put_line('no cont_item in mtl_system_items');
578: --
579: -- Debug Statements
580: --
581: IF l_debug_on THEN

Line 1081: FROM MTL_SYSTEM_ITEMS

1077: AND container_flag in ('Y', 'C');
1078:
1079: CURSOR Get_Cont_Msi (v_cont_item_id NUMBER, v_org_id NUMBER) IS
1080: SELECT maximum_load_weight, internal_volume, weight_uom_code, volume_uom_code
1081: FROM MTL_SYSTEM_ITEMS
1082: WHERE inventory_item_id = v_cont_item_id
1083: AND organization_id = v_org_id;
1084:
1085: CURSOR Get_Fill_Basis (v_org_id NUMBER) IS

Line 1743: FROM MTL_SYSTEM_ITEMS

1739: AND container_flag in ('Y', 'C');
1740:
1741: CURSOR Get_Cont_Msi (v_cont_item_id NUMBER, v_org_id NUMBER) IS
1742: SELECT maximum_load_weight, internal_volume, weight_uom_code, volume_uom_code
1743: FROM MTL_SYSTEM_ITEMS
1744: WHERE inventory_item_id = v_cont_item_id
1745: AND organization_id = v_org_id;
1746:
1747: CURSOR Get_Fill_Basis (v_org_id NUMBER) IS