DBA Data[Home] [Help]

APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on WSH_NEW_DELIVERIES

Line 1094: wsh_new_deliveries wnd

1090: wnd.confirm_date
1091: FROM
1092: wsh_delivery_details wdd,
1093: wsh_delivery_assignments wda,
1094: wsh_new_deliveries wnd
1095: WHERE
1096: wdd.delivery_detail_id = p_ddetail_id AND -- Added p_ddetail_id by bgowrava for bug#6126581
1097: wda.delivery_detail_id = wdd.delivery_detail_id AND
1098: wnd.delivery_id = wda.delivery_id ;

Line 3519: wsh_new_deliveries wnd

3515: confirm_date
3516: FROM
3517: wsh_delivery_details wdd,
3518: wsh_delivery_assignments wda,
3519: wsh_new_deliveries wnd
3520: WHERE
3521: wdd.delivery_detail_id = (p_delivery_Detail_id)
3522: AND
3523: wda.delivery_detail_id = wdd.delivery_detail_id

Line 3538: v_confirm_date wsh_new_deliveries.confirm_date%type;

3534: organization_id = pr_new.ship_from_org_id
3535: AND location_id = 0;
3536:
3537: v_ordered_Date oe_order_headers_all.ordered_date%type;
3538: v_confirm_date wsh_new_deliveries.confirm_date%type;
3539: v_excise_return_days Number;
3540: v_sales_return_days Number;
3541:
3542: -- ends here additions by sriram - bug # 2993645