APPS.WSH_OTM_SYNC_ITEM_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

SELECT	mtlb.inventory_item_id,
	mtlk.concatenated_segments,
        substrb(mtlt.description,1,120),
	mtlb.last_update_date,
	mtlb.organization_id
FROM	wsh_delivery_assignments wda,
	wsh_delivery_details wdd,
	mtl_system_items_b mtlb,
	mtl_system_items_tl mtlt,
	mtl_system_items_kfv mtlk
WHERE	wda.delivery_id = p_delivery_id
AND	wda.delivery_detail_id = wdd.delivery_detail_id
AND	wdd.inventory_item_id = mtlb.inventory_item_id
AND	wdd.inventory_item_id = mtlt.inventory_item_id
AND	wdd.inventory_item_id = mtlk.inventory_item_id
AND	wdd.organization_id = mtlb.organization_id
AND	wdd.organization_id = mtlk.organization_id
AND	wdd.organization_id = mtlt.organization_id
AND	mtlb.shippable_item_flag = 'Y'
AND	mtlk.shippable_item_flag = 'Y'
AND	mtlt.language = userenv('LANG');

Line: 50

SELECT	mtlb.inventory_item_id,
	mtlk.concatenated_segments,
        substrb(mtlt.description,1,120),
	mtlb.last_update_date,
	mtlb.organization_id
FROM	wsh_delivery_assignments wda,
	wsh_delivery_details wdd,
	wsh_delivery_legs wdl,
	wsh_trip_stops wts,
	mtl_system_items_b mtlb,
	mtl_system_items_tl mtlt,
	mtl_system_items_kfv mtlk
WHERE	wts.trip_id = p_trip_id
AND	wts.stop_id = wdl.pick_up_stop_id
AND	wda.delivery_id = wdl.delivery_id
AND	wda.delivery_detail_id = wdd.delivery_detail_id
AND	wdd.inventory_item_id = mtlb.inventory_item_id
AND	wdd.inventory_item_id = mtlt.inventory_item_id
AND	wdd.inventory_item_id = mtlk.inventory_item_id
AND	wdd.organization_id = mtlb.organization_id
AND	wdd.organization_id = mtlk.organization_id
AND	wdd.organization_id = mtlt.organization_id
AND	mtlb.shippable_item_flag = 'Y'
AND	mtlk.shippable_item_flag = 'Y'
AND	mtlt.language = userenv('LANG');

Line: 78

SELECT	wsh_otm_sync_ref_data_log_s.NEXTVAL
FROM	dual;

Line: 94

l_last_update_date DATE;

Line: 198

		l_last_update_date := l_tbl_item(l_loop_index).last_update_date;

Line: 211

								P_ENTITY_UPDATED_DATE => l_last_update_date,
								X_SUBSTITUTE_ENTITY => l_substitute_entity,
								P_TRANSMISSION_ID => l_transmission_id ,
								X_SEND_ALLOWED => l_send_allowed,
								X_RETURN_STATUS => l_return_status
								 );

Line: 237

l_tbl_item.DELETE;