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.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_DELIVERY_DETAILS

Line 442: UPDATE wsh_delivery_details

438:
439: -- TPW - Distributed changes - Start
440: IF (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') in ( 'TPW', 'TW2')) THEN
441:
442: UPDATE wsh_delivery_details
443: SET released_status = 'Y'
444: WHERE delivery_detail_id IN (
445: SELECT delivery_detail_id
446: FROM wsh_delivery_assignments

Line 477: -- Update of wsh_delivery_details where requested_quantity/released_status

473: END IF; -- }
474: --Done Raise Event: Pick To Pod Workflow
475: --
476: -- DBI Project
477: -- Update of wsh_delivery_details where requested_quantity/released_status
478: -- are changed, call DBI API after the update.
479: -- This API will also check for DBI Installed or not
480: IF l_debug_on THEN
481: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_detail_tab.count);

Line 647: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

643: decode(wddi.container_flag, 'Y', wdai.parent_delivery_detail_id,null) desc nulls first;
644:
645: CURSOR cont_inst_exists(l_del_det_id NUMBER) IS
646: SELECT count(*)
647: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
648: WHERE wdd.source_line_id = l_del_det_id
649: AND wdd.source_code = 'WSH'
650: AND wdd.container_flag = 'Y'
651: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 1257: UPDATE wsh_delivery_details

1253:
1254:
1255:
1256: -- need to update the source_line_id of the newly created container instance
1257: UPDATE wsh_delivery_details
1258: SET source_line_id = del_det_int_rec.delivery_detail_id
1259: WHERE delivery_detail_id = l_cont_instance_id;
1260:
1261: IF(SQL%NOTFOUND) THEN

Line 1314: from wsh_delivery_details wdd,

1310:
1311: IF (del_det_int_rec.line_direction = 'IO') THEN
1312: select wdd.delivery_detail_id, wdd.requested_quantity BULK COLLECT
1313: into l_detail_id_tab, l_detail_qty_tab
1314: from wsh_delivery_details wdd,
1315: oe_order_lines_all ol,
1316: po_requisition_lines_all pl,
1317: po_requisition_headers_all ph
1318: where wdd.source_code = 'OE'

Line 1329: from wsh_delivery_details wdd,

1325: and ph.segment1 = del_det_int_rec.source_header_number;
1326: ELSE
1327: select wdd.delivery_detail_id, wdd.requested_quantity BULK COLLECT
1328: into l_detail_id_tab, l_detail_qty_tab
1329: from wsh_delivery_details wdd,
1330: wsh_shipment_batches wsb,
1331: wsh_transactions_history wth
1332: where wdd.source_code = 'OE'
1333: and wdd.shipment_batch_id = wsb.batch_id

Line 1522: WSH_DELIVERY_DETAILS_GRP.Detail_To_Delivery(

1518: wsh_debug_sv.log (l_module_name, 'Assign table count', l_new_detail_ids.count);
1519: END IF;
1520:
1521: IF(l_new_detail_ids.count > 0) THEN
1522: WSH_DELIVERY_DETAILS_GRP.Detail_To_Delivery(
1523: p_api_version =>1.0,
1524: p_init_msg_list => l_init_msg_list,
1525: p_validation_level => l_validation_level,
1526: p_commit => l_commit,

Line 2067: from wsh_delivery_details wdd,

2063:
2064: IF (del_det_int_rec.line_direction = 'IO') THEN
2065: select wdd.delivery_detail_id, wdd.requested_quantity BULK COLLECT
2066: into l_detail_id_tab, l_detail_qty_tab
2067: from wsh_delivery_details wdd,
2068: oe_order_lines_all ol,
2069: po_requisition_lines_all pl,
2070: po_requisition_headers_all ph
2071: where wdd.source_code = 'OE'

Line 2082: from wsh_delivery_details wdd,

2078: and ph.segment1 = del_det_int_rec.source_header_number;
2079: ELSE
2080: select wdd.delivery_detail_id, wdd.requested_quantity BULK COLLECT
2081: into l_detail_id_tab, l_detail_qty_tab
2082: from wsh_delivery_details wdd,
2083: wsh_shipment_batches wsb,
2084: wsh_transactions_history wth
2085: where wdd.source_code = 'OE'
2086: and wdd.released_status in ('R','B','X')

Line 2107: from wsh_delivery_details

2103: l_detail_id_tab(1) := del_det_int_rec.delivery_detail_id;
2104:
2105: select requested_quantity
2106: into l_detail_qty_tab(1)
2107: from wsh_delivery_details
2108: where delivery_detail_id = del_det_int_rec.delivery_detail_id;
2109: END IF;
2110:
2111: l_curr_index := 1;

Line 2457: WSH_DELIVERY_DETAILS_GRP.Detail_To_Delivery(

2453: wsh_debug_sv.log (l_module_name, 'Assign table count', l_new_detail_ids.count);
2454: END IF;
2455:
2456: IF (l_new_detail_ids.count > 0) THEN
2457: WSH_DELIVERY_DETAILS_GRP.Detail_To_Delivery(
2458: p_api_version =>1.0,
2459: p_init_msg_list => l_init_msg_list,
2460: p_validation_level => l_validation_level,
2461: p_commit => l_commit,

Line 4177: wsh_delivery_Details_grp.create_update_delivery_detail(

4173: --jckwok: set UPDATE or CANCEL action codes
4174: l_in_rec.action_code := p_action_code;
4175: l_in_rec.phase := 1;
4176:
4177: wsh_delivery_Details_grp.create_update_delivery_detail(
4178: P_API_VERSION_NUMBER => 1.0,
4179: P_INIT_MSG_LIST => FND_API.G_FALSE,
4180: P_COMMIT => FND_API.G_FALSE,
4181: x_RETURN_STATUS => l_RETURN_STATUS,

Line 4209: p_api_name =>'WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail',

4205:
4206: Log_Errors(
4207: p_loc_interface_errors_rec => l_loc_interface_error_rec,
4208: p_msg_data => l_msg_data,
4209: p_api_name =>'WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail',
4210: x_return_status => l_return_status);
4211:
4212: IF l_debug_on THEN
4213: wsh_debug_sv.log (l_module_name,'Log_Errors l_return_status',l_return_status);

Line 4254: FROM wsh_delivery_details

4250: l_rsv_rec.revision,
4251: l_rsv_rec.subinventory_code,
4252: l_rsv_rec.lot_number,
4253: l_rsv_rec.locator_id
4254: FROM wsh_delivery_details
4255: WHERE delivery_detail_id = G_Update_Attributes_Tab(i).delivery_detail_id;
4256: --
4257: IF l_debug_on THEN
4258: wsh_debug_sv.logmsg (l_module_name,'Calling INV_SALESORDER.Get_Salesorder_For_Oeheader', WSH_DEBUG_SV.C_PROC_LEVEL );

Line 4853: l_subinventory wsh_delivery_details.subinventory%type;

4849: -- TPW - Distributed changes
4850: l_container_flag VARCHAR2(1);
4851:
4852: l_delivery_detail_id NUMBER;
4853: l_subinventory wsh_delivery_details.subinventory%type;
4854: l_locator_id NUMBER;
4855: l_wms_installed varchar2(1);
4856:
4857: -- cursors

Line 4860: FROM wsh_delivery_details wdd

4856:
4857: -- cursors
4858: CURSOR base_detail_cur(l_cont_inst_id NUMBER) IS
4859: SELECT wdd.delivery_detail_id
4860: FROM wsh_delivery_details wdd
4861: WHERE source_line_id = l_cont_inst_id
4862: AND wdd.source_code = 'WSH'
4863: AND wdd.container_flag = 'Y'
4864: AND wdd.organization_id = p_del_det_int_rec.organization_id;

Line 4877: FROM wsh_delivery_details wdd

4873:
4874: --bugfix 8841528 added cursor
4875: CURSOR inv_detail_cur IS
4876: SELECT wdd.delivery_detail_id,wdd.subinventory, wdd.locator_id
4877: FROM wsh_delivery_details wdd
4878: WHERE source_line_id = p_del_det_int_rec.delivery_detail_id
4879: AND wdd.source_code = 'WSH'
4880: AND wdd.container_flag = 'Y'
4881: AND wdd.organization_id = p_del_det_int_rec.organization_id;

Line 5145: FROM wsh_delivery_details wdd,

5141: wdd.source_line_id,
5142: wdd.source_code,
5143: wdd.container_flag,
5144: wdd.requested_quantity_uom
5145: FROM wsh_delivery_details wdd,
5146: wsh_delivery_assignments_v wda
5147: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
5148: AND wda.delivery_id = p_delivery_id;
5149:

Line 5235: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

5231: l_dummy_id NUMBER;
5232:
5233: CURSOR lock_delivery_details IS
5234: SELECT wdd.delivery_detail_id
5235: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
5236: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
5237: AND wda.delivery_id = p_delivery_id
5238: FOR UPDATE NOWAIT;
5239:

Line 5328: FROM wsh_delivery_details wdd,

5324: l_dummy_id NUMBER;
5325:
5326: CURSOR lock_delivery_details IS
5327: SELECT wdd.delivery_detail_id
5328: FROM wsh_delivery_details wdd,
5329: wsh_delivery_assignments wda
5330: WHERE wdd.source_code = 'OE'
5331: AND wdd.delivery_detail_id = wda.delivery_detail_id
5332: AND wdd.released_status in ('R','B','X')

Line 5339: wsh_delivery_details wdd1

5335: from wsh_del_details_interface wddi,
5336: wsh_del_assgn_interface wdai,
5337: wsh_shipment_batches wsb,
5338: wsh_transactions_history wth,
5339: wsh_delivery_details wdd1
5340: where wdd1.source_code = 'OE'
5341: and wdd1.released_status in ('R','B','X')
5342: and wdd1.shipment_line_number = wddi.delivery_detail_id
5343: and wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id

Line 5356: wsh_delivery_details wdd1,

5352: UNION
5353: SELECT wdd1.delivery_detail_id
5354: FROM wsh_del_details_interface wddi,
5355: wsh_del_assgn_interface wdai,
5356: wsh_delivery_details wdd1,
5357: oe_order_lines_all ol,
5358: po_requisition_lines_all pl,
5359: po_requisition_headers_all ph
5360: where wdd1.source_code = 'OE'

Line 5506: FROM wsh_delivery_details

5502: l_number_of_warnings NUMBER := 0;
5503: --
5504: CURSOR base_detail_qty(l_del_detail_id NUMBER) IS
5505: SELECT requested_quantity
5506: FROM wsh_delivery_details
5507: WHERE delivery_detail_id =l_del_detail_id;
5508: --
5509: l_debug_on BOOLEAN;
5510: --

Line 5556: wsh_delivery_details_actions.split_delivery_details(

5552: RAISE FND_API.G_EXC_ERROR;
5553: END IF;
5554:
5555: l_qty_to_split := p_qty_to_split;
5556: wsh_delivery_details_actions.split_delivery_details(
5557: p_from_detail_id => p_delivery_detail_id,
5558: p_req_quantity => l_qty_to_split,
5559: x_new_detail_id => x_new_detail_id,
5560: x_return_status => l_return_status);