DBA Data[Home] [Help]

APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on WSH_NEW_DELIVERIES

Line 1275: wsh_new_deliveries wnd

1271: wnd.confirm_date
1272: FROM
1273: wsh_delivery_details wdd,
1274: wsh_delivery_assignments wda,
1275: wsh_new_deliveries wnd
1276: WHERE
1277: wdd.delivery_detail_id = p_ddetail_id AND -- Added p_ddetail_id by bgowrava for bug#6126581
1278: wda.delivery_detail_id = wdd.delivery_detail_id AND
1279: wnd.delivery_id = wda.delivery_id ;

Line 2192: wsh_new_deliveries wnd

2188: wnd.confirm_date
2189: FROM
2190: wsh_delivery_details wdd,
2191: wsh_delivery_assignments wda,
2192: wsh_new_deliveries wnd
2193: WHERE
2194: wdd.delivery_detail_id = p_ddetail_id AND -- Added p_ddetail_id by bgowrava for bug#6126581
2195: wda.delivery_detail_id = wdd.delivery_detail_id AND
2196: wnd.delivery_id = wda.delivery_id ;

Line 5625: wsh_new_deliveries wnd

5621: confirm_date
5622: FROM
5623: wsh_delivery_details wdd,
5624: wsh_delivery_assignments wda,
5625: wsh_new_deliveries wnd
5626: WHERE
5627: wdd.delivery_detail_id = (p_delivery_Detail_id)
5628: AND
5629: wda.delivery_detail_id = wdd.delivery_detail_id

Line 5669: v_confirm_date wsh_new_deliveries.confirm_date%type;

5665: ln_item_exists NUMBER;
5666: /*bug#8485149,end*/
5667:
5668: v_ordered_Date oe_order_headers_all.ordered_date%type;
5669: v_confirm_date wsh_new_deliveries.confirm_date%type;
5670: v_excise_return_days Number;
5671: v_sales_return_days Number;
5672:
5673: -- ends here additions by sriram - bug # 2993645