eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MST_RELEASE dependencies on WSH_DEL_DETAILS_INTERFACE

Line 1358: , wsh_del_details_interface wdd_iface

1354: is
1355: select wdd_iface.delivery_detail_interface_id, min(wdd.source_header_id), min(wdd.source_line_id), min(wdd.source_line_set_id)
1356: from wsh_delivery_details wdd
1357: , mst_release_temp_gt mrt
1358: , wsh_del_details_interface wdd_iface
1359: where wdd.source_code = wdd_iface.source_code
1360: and wdd.source_header_number = wdd_iface.source_header_number
1361: and substr(wdd.source_line_number,1,instr(wdd.source_line_number||'.','.',1,1)-1) = substr(wdd_iface.source_line_number,1,instr(wdd_iface.source_line_number||'.','.',1,1)-1)
1362: and (wdd_iface.source_header_id is null or wdd_iface.source_line_id = FND_API.G_MISS_NUM or wdd_iface.source_line_set_id is null)

Line 1379: update wsh_del_details_interface

1375: close cur_wdd_ids;
1376:
1377: if nvl(l_delivery_detail_iface_id_tab.last,0) > 0 then
1378: forall i in 1..l_delivery_detail_iface_id_tab.last
1379: update wsh_del_details_interface
1380: set source_header_id = l_source_header_id_tab(i)
1381: , source_line_id = l_source_line_id_tab(i)
1382: , source_line_set_id = l_source_line_set_id_tab(i)
1383: where delivery_detail_interface_id = l_delivery_detail_iface_id_tab(i);

Line 1393: , wsh_del_details_interface wdd_iface

1389: cursor cur_wdd_loc_ids (l_release_id in pls_integer)
1390: is
1391: select wda_iface.delivery_interface_id, wdd_iface.delivery_detail_interface_id, mplav.cust_location_id
1392: from mst_po_location_asso_v mplav
1393: , wsh_del_details_interface wdd_iface
1394: , wsh_del_assgn_interface wda_iface
1395: , wsh_delivery_details wdd
1396: , mst_release_temp_gt mrt
1397: where mplav.location_id = wdd_iface.ship_to_location_id

Line 1422: update wsh_del_details_interface

1418: end if;
1419:
1420: if nvl(l_delivery_detail_iface_id_tab.last,0) > 0 then
1421: forall i in 1..l_delivery_detail_iface_id_tab.last
1422: update wsh_del_details_interface
1423: set ship_to_location_id = l_ship_to_location_id_tab(i)
1424: where delivery_detail_interface_id = l_delivery_detail_iface_id_tab(i);
1425: end if;
1426: print_info(g_log_flow_of_control,'update_loc_id_in_wdd_iface_tab : Program ended');

Line 1857: , wsh_del_details_interface_s.nextval

1853: , mrt.sr_delivery_id
1854: , mrt.delivery_id_iface
1855: , mda.sr_delivery_assignment_id
1856: , mda.delivery_detail_id
1857: , wsh_del_details_interface_s.nextval
1858: , mdd1.sr_delivery_detail_id
1859: , mdd.source_code
1860: , mdd.customer_id
1861: , mdd.inventory_item_id

Line 1961: , wsh_del_details_interface_s.nextval

1957: , mrt.sr_delivery_id
1958: , mrt.delivery_id_iface
1959: , mda.sr_delivery_assignment_id
1960: , mda.delivery_detail_id
1961: , wsh_del_details_interface_s.nextval
1962: , mdd.sr_delivery_detail_id
1963: , mdd.source_code
1964: , mdd.customer_id
1965: , mdd.inventory_item_id

Line 2045: insert into wsh_del_details_interface

2041: where mrt.release_id = p_release_id
2042: and mrt.delivery_detail_id_iface is not null
2043: );
2044:
2045: insert into wsh_del_details_interface
2046: ( delivery_detail_interface_id
2047: , delivery_detail_id
2048: , source_code
2049: , customer_id

Line 2092: select mrt.delivery_detail_id_iface --wsh_del_details_interface_s.nextval

2088: , last_updated_by
2089: , last_update_login
2090: )
2091: (
2092: select mrt.delivery_detail_id_iface --wsh_del_details_interface_s.nextval
2093: , mrt.sr_delivery_detail_id
2094: , mrt.source_code
2095: , mrt.customer_id
2096: , mrt.inventory_item_id

Line 2494: , wsh_del_details_interface wddi

2490: cursor cur_delivery_details (l_release_id in pls_integer, l_group_id in pls_integer)
2491: is
2492: select mrt.delivery_detail_id, wddi.delivery_detail_id
2493: from mst_release_temp_gt mrt
2494: , wsh_del_details_interface wddi
2495: where mrt.release_id = l_release_id
2496: and mrt.group_id = l_group_id
2497: and mrt.delivery_detail_id is not null
2498: and mrt.delivery_detail_id_iface = wddi.delivery_detail_interface_id;

Line 3759: delete from wsh_del_details_interface

3755: end loop;
3756: print_info(g_log_must_message,'');
3757:
3758: for i in 1..g_delete_record_count_loop loop
3759: delete from wsh_del_details_interface
3760: where interface_action_code = g_tp_release_code
3761: and rownum < g_delete_record_count;
3762: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_details_interface.');
3763: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

Line 3762: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_details_interface.');

3758: for i in 1..g_delete_record_count_loop loop
3759: delete from wsh_del_details_interface
3760: where interface_action_code = g_tp_release_code
3761: and rownum < g_delete_record_count;
3762: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_details_interface.');
3763: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3764: fnd_message.set_token('N1',to_char(sql%rowcount));
3765: fnd_message.set_token('TABLE_NAME','WSH_DEL_DETAILS_INTERFACE');
3766: l_Message_Text := fnd_message.get;

Line 3765: fnd_message.set_token('TABLE_NAME','WSH_DEL_DETAILS_INTERFACE');

3761: and rownum < g_delete_record_count;
3762: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_details_interface.');
3763: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3764: fnd_message.set_token('N1',to_char(sql%rowcount));
3765: fnd_message.set_token('TABLE_NAME','WSH_DEL_DETAILS_INTERFACE');
3766: l_Message_Text := fnd_message.get;
3767: print_info(g_log_must_message,l_Message_Text);
3768: commit;
3769: end loop;