DBA Data[Home] [Help]

APPS.MST_RELEASE dependencies on MST_DELIVERY_DETAILS

Line 1891: , mst_delivery_details mdd

1887: , hzr.object_id
1888: from mst_plans mp
1889: , mst_release_temp_gt mrt
1890: , mst_delivery_assignments mda
1891: , mst_delivery_details mdd
1892: , mst_delivery_details mdd1
1893: , hz_relationships hzr
1894: where mrt.plan_id = mp.plan_id
1895: and mrt.plan_id = mda.plan_id

Line 1892: , mst_delivery_details mdd1

1888: from mst_plans mp
1889: , mst_release_temp_gt mrt
1890: , mst_delivery_assignments mda
1891: , mst_delivery_details mdd
1892: , mst_delivery_details mdd1
1893: , hz_relationships hzr
1894: where mrt.plan_id = mp.plan_id
1895: and mrt.plan_id = mda.plan_id
1896: and mrt.delivery_id = mda.delivery_id

Line 1995: , mst_delivery_details mdd

1991: , hzr.object_id
1992: from mst_plans mp
1993: , mst_release_temp_gt mrt
1994: , mst_delivery_assignments mda
1995: , mst_delivery_details mdd
1996: , hz_relationships hzr
1997: where mrt.plan_id = mp.plan_id
1998: and mrt.plan_id = mda.plan_id
1999: and mrt.delivery_id = mda.delivery_id

Line 2514: update mst_delivery_details

2510: close cur_delivery_details;
2511:
2512: if nvl(l_delivery_detail_id_tab.last,0) > 0 then
2513: forall i in 1..l_delivery_detail_id_tab.last
2514: update mst_delivery_details
2515: set sr_delivery_detail_id = l_sr_delivery_detail_id_tab(i)
2516: where plan_id = l_plan_id
2517: and delivery_detail_id = l_delivery_detail_id_tab(i);
2518: end if;