[Home] [Help]
849:
850: CURSOR CUR_VEH_WT_CAPACITY(pp_plan_id IN NUMBER,
851: pp_vehicle_type_id IN NUMBER) IS
852: SELECT MSI.Maximum_Load_Weight
853: FROM MTL_SYSTEM_ITEMS MSI,
854: FTE_VEHICLE_TYPES FVT
855: WHERE FVT.VEHICLE_TYPE_ID = pp_vehicle_type_id
856: AND MSI.INVENTORY_ITEM_ID = FVT.INVENTORY_ITEM_ID
857: AND MSI.ORGANIZATION_ID = FVT.ORGANIZATION_ID;
860: pp_vehicle_type_id IN NUMBER) IS
861: SELECT (FVT.USABLE_LENGTH *
862: FVT.USABLE_WIDTH *
863: FVT.USABLE_HEIGHT) USABLE_VOLUME
864: FROM MTL_SYSTEM_ITEMS MSI,
865: FTE_VEHICLE_TYPES FVT
866: WHERE FVT.VEHICLE_TYPE_ID = pp_vehicle_type_id
867: AND MSI.INVENTORY_ITEM_ID = FVT.INVENTORY_ITEM_ID
868: AND MSI.ORGANIZATION_ID = FVT.ORGANIZATION_ID;
870: CURSOR CUR_VEH_PAL_CAPACITY(pp_plan_id IN NUMBER,
871: pp_vehicle_type_id IN NUMBER) IS
872: SELECT (FVT.PALLET_FLOOR_SPACE *
873: FVT.PALLET_STACKING_HEIGHT ) Pallets
874: FROM MTL_SYSTEM_ITEMS MSI,
875: FTE_VEHICLE_TYPES FVT
876: WHERE FVT.VEHICLE_TYPE_ID = pp_vehicle_type_id
877: AND MSI.INVENTORY_ITEM_ID = FVT.INVENTORY_ITEM_ID
878: AND MSI.ORGANIZATION_ID = FVT.ORGANIZATION_ID;
1381: fnd_message.set_token('MODE_OF_TRANSPORT', l_temp);
1382: -- item_description
1383: select description, med.delivery_detail_id
1384: into l_temp1, l_id2
1385: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med
1386: where med.plan_id=p_plan_id
1387: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID
1388: and med.delivery_detail_id = mdd.delivery_detail_id
1389: and med.plan_id = mdd.plan_id
1406: AND trip_id = P_TRIP_ID;
1407: -- item_description
1408: select description, med.delivery_detail_id
1409: into l_temp, l_id3
1410: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med
1411: where med.plan_id=p_plan_id
1412: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID
1413: and med.delivery_detail_id = mdd.delivery_detail_id
1414: and med.plan_id=mdd.plan_id
1547: AND trip_id = P_TRIP_ID;
1548: fnd_message.set_token('TRIP_NUMBER', l_id1);
1549: -- item_description
1550: select msitl.description into l_temp1
1551: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med
1552: where med.plan_id=p_plan_id
1553: and med.plan_id = mdd.plan_id
1554: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID
1555: and med.delivery_detail_id = mdd.delivery_detail_id
1559: fnd_message.set_token('ITEM_DESCRIPTION', l_temp1);
1560: -- vehicle_type
1561: SELECT msikfv.concatenated_segments
1562: into l_temp
1563: FROM mtl_system_items_kfv msikfv, fte_vehicle_types fvt
1564: WHERE fvt.vehicle_type_id = l_id2
1565: AND fvt.organization_id = msikfv.organization_id
1566: AND fvt.inventory_item_id = msikfv.inventory_item_id;
1567: fnd_message.set_token('VEHICLE_TYPE', l_temp);
1580: AND trip_id = P_TRIP_ID;
1581: fnd_message.set_token('TRIP_NUMBER', l_id1);
1582: -- item_description
1583: select msitl.description into l_temp1
1584: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med
1585: where med.plan_id=p_plan_id
1586: and med.plan_id = mdd.plan_id
1587: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID
1588: and med.delivery_detail_id = mdd.delivery_detail_id
2164: l_temp,
2165: msikfv.organization_id,
2166: msikfv.inventory_item_id)
2167: INTO l_id1
2168: FROM mtl_system_items_kfv msikfv,
2169: fte_vehicle_types fvt
2170: WHERE msikfv.inventory_item_id = fvt.inventory_item_id
2171: AND msikfv.organization_id = fvt.organization_id
2172: AND fvt.vehicle_type_id = l_id8;
4443: WHERE plan_id = P_PLAN_ID;
4444:
4445: CURSOR l_vehicle_cur (p_vehicle_type_id IN NUMBER) IS
4446: SELECT msikfv.concatenated_segments
4447: FROM mtl_system_items_kfv msikfv,
4448: fte_vehicle_types fvt
4449: WHERE fvt.vehicle_type_id = p_vehicle_type_id
4450: AND fvt.organization_id = msikfv.organization_id
4451: AND fvt.inventory_item_id = msikfv.inventory_item_id;
4885: fnd_message.set_token('MODE_OF_TRANSPORT', l_str2);
4886:
4887: -- item_description
4888: select msitl.description into l_str3
4889: from mtl_system_items_tl msitl, mst_delivery_details mdd
4890: where mdd.plan_id = P_PLAN_ID
4891: and mdd.delivery_detail_id = l_id2
4892: and mdd.inventory_item_id = msitl.inventory_item_id
4893: and mdd.organization_id = msitl.organization_id
4912: fnd_message.set_token('DELIVERY_DETAIL_ID', l_id2);
4913:
4914: -- item_description
4915: select msitl.description into l_str2
4916: from mtl_system_items_tl msitl, mst_delivery_details mdd
4917: where mdd.plan_id = P_PLAN_ID
4918: and mdd.delivery_detail_id = l_id2
4919: and mdd.inventory_item_id = msitl.inventory_item_id
4920: and mdd.organization_id = msitl.organization_id
5228: l_str1,
5229: msikfv.organization_id,
5230: msikfv.inventory_item_id)
5231: INTO l_id9
5232: FROM mtl_system_items_kfv msikfv,
5233: fte_vehicle_types fvt
5234: WHERE msikfv.inventory_item_id = fvt.inventory_item_id
5235: AND msikfv.organization_id = fvt.organization_id
5236: AND fvt.vehicle_type_id = l_id8;
5356: END IF;
5357:
5358: -- item_description
5359: select msitl.description into l_str1
5360: from mtl_system_items_tl msitl, mst_delivery_details mdd
5361: where mdd.plan_id = P_PLAN_ID
5362: and mdd.delivery_detail_id = l_id2
5363: and mdd.inventory_item_id = msitl.inventory_item_id
5364: and mdd.organization_id = msitl.organization_id
5366: fnd_message.set_token('ITEM_DESCRIPTION', l_str1);
5367:
5368: SELECT msikfv.concatenated_segments
5369: into l_str2
5370: FROM mtl_system_items_kfv msikfv, fte_vehicle_types fvt
5371: WHERE fvt.vehicle_type_id = l_id3
5372: AND fvt.organization_id = msikfv.organization_id
5373: AND fvt.inventory_item_id = msikfv.inventory_item_id;
5374: fnd_message.set_token('VEHICLE_TYPE', l_str2);
5463: END IF;
5464:
5465: -- item_description
5466: select msitl.description into l_str1
5467: from mtl_system_items_tl msitl, mst_delivery_details mdd
5468: where mdd.plan_id = P_PLAN_ID
5469: and mdd.delivery_detail_id = l_id2
5470: and mdd.inventory_item_id = msitl.inventory_item_id
5471: and mdd.organization_id = msitl.organization_id