APPS.MST_WB_UTIL dependencies on MTL_SYSTEM_ITEMS_TL

Line 1385: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med

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

Line 1410: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med

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

Line 1551: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med

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

Line 1584: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med

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

Line 4889: from mtl_system_items_tl msitl, mst_delivery_details mdd

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

Line 4916: from mtl_system_items_tl msitl, mst_delivery_details mdd

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

Line 5360: from mtl_system_items_tl msitl, mst_delivery_details mdd

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

Line 5467: from mtl_system_items_tl msitl, mst_delivery_details mdd

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