DBA Data[Home] [Help]

APPS.JAI_OM_TAX_PROCESSING_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 1222: wsh_delivery_assignments wda,

1218:
1219: CURSOR c_get_detail_id(p_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type) IS
1220: SELECT wdd.delivery_detail_id, wnd.confirm_date
1221: FROM wsh_delivery_details wdd,
1222: wsh_delivery_assignments wda,
1223: wsh_new_deliveries wnd
1224: WHERE wdd.delivery_detail_id = p_ddetail_id
1225: AND wda.delivery_detail_id = wdd.delivery_detail_id
1226: AND wnd.delivery_id = wda.delivery_id;

Line 1978: wsh_delivery_assignments wda,

1974:
1975: CURSOR c_get_detail_id(p_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type) IS
1976: SELECT wdd.delivery_detail_id, wnd.confirm_date
1977: FROM wsh_delivery_details wdd,
1978: wsh_delivery_assignments wda,
1979: wsh_new_deliveries wnd
1980: WHERE wdd.delivery_detail_id = p_ddetail_id
1981: AND wda.delivery_detail_id = wdd.delivery_detail_id
1982: AND wnd.delivery_id = wda.delivery_id;

Line 4515: wsh_delivery_assignments wda,

4511:
4512: cursor c_confirmed_date(p_delivery_Detail_id Number) is
4513: select confirm_date
4514: FROM wsh_delivery_details wdd,
4515: wsh_delivery_assignments wda,
4516: wsh_new_deliveries wnd
4517: WHERE wdd.delivery_detail_id = (p_delivery_Detail_id)
4518: AND wda.delivery_detail_id = wdd.delivery_detail_id
4519: AND wnd.delivery_id = wda.delivery_id;